https://sesi.ch Sesi - Società epilettici della Svizzera italiana - - RSS (c) sesi.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='54' ) ORDER by m1.top DESC,m1.datecreation DESC LIMIT 300