Анонсы - Рестораны

SELECT fg.*, p.* FROM te_nanons as fg LEFT JOIN te_npub as p ON p.cat_id=fg.a_pub WHERE fg.a_reg_id='1' AND fg.a_on_off='1' AND fg.a_pub IN (1,2,3,4,5,6,7,8,10,12,13,22,23,24,28,30,34,35,40,41,42,43,44,76,79,134,136,138,141,142,143,144,146,147,148,149,151,152,153,154,155,156,157,158,159,160,164,165,168,171,173,175,182,178,291,467,468,497,559,639,649) AND fg.a_data BETWEEN '2020-01-11 00:00:00' AND '2020-01-18 00:00:00 00:00:00' ORDER BY a_data DESC
SELECT fg.*, p.* FROM te_nanons as fg LEFT JOIN te_npub as p ON p.cat_id=fg.a_pub WHERE fg.a_reg_id='1' AND fg.a_on_off='1' AND fg.a_pub IN (1,2,3,4,5,6,7,8,10,12,13,22,23,24,28,30,34,35,40,41,42,43,44,76,79,134,136,138,141,142,143,144,146,147,148,149,151,152,153,154,155,156,157,158,159,160,164,165,168,171,173,175,182,178,291,467,468,497,559,639,649) AND fg.a_data BETWEEN '2020-01-19 23:59:59 00:00:00' AND '2020-01-19 00:00:00 00:00:00' ORDER BY a_data DESC
SELECT fg.*, p.* FROM te_nanons as fg LEFT JOIN te_npub as p ON p.cat_id=fg.a_pub WHERE fg.a_reg_id='1' AND fg.a_on_off='1' AND fg.a_pub IN (1,2,3,4,5,6,7,8,10,12,13,22,23,24,28,30,34,35,40,41,42,43,44,76,79,134,136,138,141,142,143,144,146,147,148,149,151,152,153,154,155,156,157,158,159,160,164,165,168,171,173,175,182,178,291,467,468,497,559,639,649) AND fg.a_data BETWEEN '2020-01-20 23:59:59 00:00:00' AND '2020-01-20 00:00:00 00:00:00' ORDER BY a_data DESC
SELECT fg.*, p.* FROM te_nanons as fg LEFT JOIN te_npub as p ON p.cat_id=fg.a_pub WHERE fg.a_reg_id='1' AND fg.a_on_off='1' AND fg.a_pub IN (1,2,3,4,5,6,7,8,10,12,13,22,23,24,28,30,34,35,40,41,42,43,44,76,79,134,136,138,141,142,143,144,146,147,148,149,151,152,153,154,155,156,157,158,159,160,164,165,168,171,173,175,182,178,291,467,468,497,559,639,649) AND fg.a_data BETWEEN '2020-01-21 23:59:59 00:00:00' AND '2020-01-21 00:00:00 00:00:00' ORDER BY a_data DESC
SELECT fg.*, p.* FROM te_nanons as fg LEFT JOIN te_npub as p ON p.cat_id=fg.a_pub WHERE fg.a_reg_id='1' AND fg.a_on_off='1' AND fg.a_pub IN (1,2,3,4,5,6,7,8,10,12,13,22,23,24,28,30,34,35,40,41,42,43,44,76,79,134,136,138,141,142,143,144,146,147,148,149,151,152,153,154,155,156,157,158,159,160,164,165,168,171,173,175,182,178,291,467,468,497,559,639,649) AND fg.a_data BETWEEN '2020-01-22 23:59:59 00:00:00' AND '2020-01-22 00:00:00 00:00:00' ORDER BY a_data DESC
SELECT fg.*, p.* FROM te_nanons as fg LEFT JOIN te_npub as p ON p.cat_id=fg.a_pub WHERE fg.a_reg_id='1' AND fg.a_on_off='1' AND fg.a_pub IN (1,2,3,4,5,6,7,8,10,12,13,22,23,24,28,30,34,35,40,41,42,43,44,76,79,134,136,138,141,142,143,144,146,147,148,149,151,152,153,154,155,156,157,158,159,160,164,165,168,171,173,175,182,178,291,467,468,497,559,639,649) AND fg.a_data BETWEEN '2020-01-23 23:59:59 00:00:00' AND '2020-01-23 00:00:00 00:00:00' ORDER BY a_data DESC
SELECT fg.*, p.* FROM te_nanons as fg LEFT JOIN te_npub as p ON p.cat_id=fg.a_pub WHERE fg.a_reg_id='1' AND fg.a_on_off='1' AND fg.a_pub IN (1,2,3,4,5,6,7,8,10,12,13,22,23,24,28,30,34,35,40,41,42,43,44,76,79,134,136,138,141,142,143,144,146,147,148,149,151,152,153,154,155,156,157,158,159,160,164,165,168,171,173,175,182,178,291,467,468,497,559,639,649) AND fg.a_data BETWEEN '2020-01-24 23:59:59 00:00:00' AND '2020-01-24 00:00:00 00:00:00' ORDER BY a_data DESC
SELECT fg.*, p.* FROM te_nanons as fg LEFT JOIN te_npub as p ON p.cat_id=fg.a_pub WHERE fg.a_reg_id='1' AND fg.a_on_off='1' AND fg.a_pub IN (1,2,3,4,5,6,7,8,10,12,13,22,23,24,28,30,34,35,40,41,42,43,44,76,79,134,136,138,141,142,143,144,146,147,148,149,151,152,153,154,155,156,157,158,159,160,164,165,168,171,173,175,182,178,291,467,468,497,559,639,649) AND fg.a_data BETWEEN '2020-01-25 23:59:59 00:00:00' AND '2020-01-25 00:00:00 00:00:00' ORDER BY a_data DESC
SELECT fg.*, p.* FROM te_nanons as fg LEFT JOIN te_npub as p ON p.cat_id=fg.a_pub WHERE fg.a_reg_id='1' AND fg.a_on_off='1' AND fg.a_pub IN (1,2,3,4,5,6,7,8,10,12,13,22,23,24,28,30,34,35,40,41,42,43,44,76,79,134,136,138,141,142,143,144,146,147,148,149,151,152,153,154,155,156,157,158,159,160,164,165,168,171,173,175,182,178,291,467,468,497,559,639,649) AND fg.a_data BETWEEN '2020-01-26 23:59:59 00:00:00' AND '2020-01-26 00:00:00 00:00:00' ORDER BY a_data DESC