TL Consulting - Attività commerciali - RSS http://tlconsulting.ch TL Consulting - Attività commerciali - RSS (c) tlconsulting.chSELECT m1.id ,m1.title ,m1.description,m1.datecreation,m1.username,m1.price,m1.yellow,m1.category FROM ads m1 WHERE m1.publish= '1' AND m1.block= '0' AND (SELECT count(m2.id) FROM adssites m2 WHERE m1.id = m2.adsid AND m2.siteid = '1' ORDER by m2.top ASC) > 0 AND ( m1.category='21' ) ORDER by m1.top DESC,m1.datecreation DESC LIMIT 300