imho darai where not exists (select FROM `sp_inbox` aa WHERE `to` = 'c585d46c5b9b308f07c58a65176e5298' and aa.id = `sp_inbox`.id ORDER 
 BY `datetime` DESC LIMIT 300)
"Nezinau" <nezinau@nieko.lt> wrote in message news:gt9d1e$526$1@trimpas.omnitel.net...
> Sveiki,
> 
> Yra tokia mysql uzklausa. Bet ji neveikia nes "LIMIT 300,1000" su DELETE 
> neveikia, o tik "LIMIT 300" veikia.
> DELETE FROM `sp_inbox` WHERE `to` = 'c585d46c5b9b308f07c58a65176e5298' ORDER 
> BY `datetime` DESC LIMIT 300,1000
> 
> klausimas:
> kaip padaryti kad is DB trintu visus likusius irasus kurie nepatenka i ta 
> 300 kriteriju.
> 
> Isanksto aciu!!! 
>