Contatti: 0302884412
SELECT med.idmedia, med.title, med.path, med.insdatetime, med.description, sub.subcategory  FROM media med  NATURAL JOIN subcategories sub  NATURAL JOIN categories cat  WHERE insdatetime > DATE_SUB(NOW(), INTERVAL 182 DAY)  AND idcategory IN (6,7,8,9,14,15) AND idmedia > 0  ORDER BY insdatetime DESC LIMIT 2184,21
SELECT med.idmedia, med.title, med.path, med.insdatetime, med.description, sub.subcategory FROM media med NATURAL JOIN subcategories sub NATURAL JOIN categories cat WHERE insdatetime > DATE_SUB(NOW(), INTERVAL 182 DAY) AND idcategory IN (6,7,8,9,14,15) AND idmedia > 0 ORDER BY insdatetime DESC LIMIT 2184,21
first prevoius prevoius  101   102   103   104   105    
rec: 2185..2187 /2187 - pag: 105/105