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 sub.subcategory="Spettacoli"  ORDER BY insdatetime DESC LIMIT 1763,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 10000 DAY) AND idcategory IN (6,7,8,9,14,15) AND idmedia > 0 AND sub.subcategory="Spettacoli" ORDER BY insdatetime DESC LIMIT 1763,21
SPETTACOLI 06/11/18
SPETTACOLI 05/11/18
SPETTACOLI 05/11/18
SPETTACOLI 05/11/18
SPETTACOLI 31/10/18
SPETTACOLI 25/10/18
SPETTACOLI 24/10/18
SPETTACOLI 24/10/18
SPETTACOLI 23/10/18
SPETTACOLI 22/10/18
SPETTACOLI 21/10/18
SPETTACOLI 16/10/18
SPETTACOLI 14/10/18
SPETTACOLI 14/10/18
SPETTACOLI 10/10/18
first prevoius prevoius  81   82   83   84   85   86   87   88   89   90  next next last
rec: 1764..1784/3389 - pag: 84/162