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 10000 DAY)  AND idcategory IN (6,7,8,9,14,15) AND idmedia > 0 AND med.title LIKE '%its%'  AND med.insdatetime BETWEEN '2021-10-27 00:00:00' AND '2021-10-27 23:59:59'   ORDER BY insdatetime DESC LIMIT 0,21
TUTTI I VIDEO
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 10000 DAY) AND idcategory IN (6,7,8,9,14,15) AND idmedia > 0 AND med.title LIKE '%its%' AND med.insdatetime BETWEEN '2021-10-27 00:00:00' AND '2021-10-27 23:59:59' ORDER BY insdatetime DESC LIMIT 0,21
CRONACA 27/10/21
ITS MACHINA LONATI E' DIGITAL
rec: 1..1 /1 - pag: 1/1