Contatti: 0302884412
SELECT med.idmedia, med.title, med.path, med.insdatetime, med.description, sub.subcategory  FROM derivates dev  JOIN media med ON dev.idmedia=med.idmedia  NATURAL JOIN subcategories sub  NATURAL JOIN categories cat  WHERE insdatetime > DATE_SUB(NOW(), INTERVAL 365 DAY)  AND dev.ext='mp4' AND idcategory IN (6,7,8,9,14,15) AND status = 'done'   ORDER BY insdatetime DESC LIMIT 176,10
first prevoius prevoius  11   12   13   14   15   16   17   18   19   20  next next last
rec: 177..186/4856 - pag: 18/486