SELECT titlu, idstr, datamodificare, devanzare, pretvanzare, pretvanzaremp, localitate, zona, suprafatateren, frontstradal, umsuprafatateren FROM anunturi WHERE devanzare=1 and idstr like "X0M013%" and localitate like "%%" and zona like "%%" ORDER BY datamodificare desc LIMIT 1070, 10