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 dev.ext='mp4' AND idcategory IN (6,7,8,9,14,15) AND status = 'done' AND med.title LIKE '%winter marathon%' AND med.insdatetime BETWEEN '2022-01-20 00:00:00' AND '2022-01-20 23:59:59'   ORDER BY insdatetime DESC LIMIT 0,10
rec: 1..2 /2 - pag: 1/1