SELECT DISTINCT c.ordine1 AS ordering, c.imgtitle, c.imgauthor, c.id FROM sma1e_location_film AS l LEFT JOIN sma1e_cinema AS c ON l.id_film=c.id WHERE l.s_f=1 AND l.id_film<>0 LIMIT 100