gistfile1.sql

SELECT SQL_NO_CACHE COUNT(*) AS `count` FROM `posts` AS `Post` left JOIN `campaigns` AS `Campaign` ON (`Post`.`campaign_id` = `Campaign`.`id`) WHERE `Campaign`.`id` IN (1977, 779, 780, 782, 783, 784, 785, 786, 1750, 787, 1356, 790, 791, 792, 793, 794, 795, 796, 797, 799, 800, 802, 803, 804, 805, 806, 807, 808, 809, 810, 813, 814, 815, 730, 816, 819, 821, 822, 823, 824, 811, 827, 829, 731, 830, 831, 1425, 890, 832, 833, 835, 254, 837, 839, 841, 842, 843, 844, 845, 846, 847, 848, 1020, 849, 850, 851, 852, 853, 798, 812, 818, 825, 826, 836, 838, 856, 732, 828, 855, 857, 859, 860, 861, 862, 864, 865, 866, 867, 869, 871) AND `Post`.`updated_timestamp` BETWEEN 1392219518 AND 1394807918 AND `Post`.`from_cms` = 1