SELECT * FROM cs WHERE id_ap = 'PNCIR' AND rs = '1' AND fonte > ' ' AND fonte LIKE '%www.ilcaffe.tv%' UNION SELECT C.* FROM cs C JOIN cs_ap CA ON (C.id=CA.id_cs) WHERE CA.id_ap = 'PNCIR' AND id_lingua = 'it' AND rs = '1' AND fonte > ' ' AND fonte LIKE '%www.ilcaffe.tv%' ORDER BY data DESC, id DESC, titolo ASC LIMIT -10, 10