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 365 DAY)  AND idcategory IN (6,7,8,9,14,15)   ORDER BY insdatetime DESC LIMIT 4830,10
first prevoius prevoius  481   482   483   484    
rec: 4831..4835 /4835 - pag: 484/484