terrafied · October 5, 2012 18:16
diff --git a/query.sql b/query.sql
 SELECT question_records.* FROM `question_records` WHERE `question_records`.`enrollment_id` IN (50912, 59119, 56414, 59171, 52856, 59168, 52857, 59169, 52858, 59170, 52859, 59173, 52860, 59172, 52861, 59118, 52862, 59114, 52863, 59112, 52864, 59116, 52865, 59113, 52866, 59115, 52867, 59117, 52868, 59124, 52869, 59123, 52871, 59121, 52872, 59126, 52873, 59127, 52874, 59128, 52875, 59122, 52876, 59125, 52877, 59129, 52878, 59132, 52879, 59135, 52880, 59134, 52881, 59131, 52882, 52883, 59133, 52884, 59130, 52886, 59136, 52887, 59138, 52888, 59137, 52889, 59140, 52890, 59142, 52891, 59141, 52892, 59139, 52893, 59144, 52894, 59149, 52895, 59147, 52896, 59151, 52898, 59150, 52899, 59148, 52900, 59145, 52901, 59157, 52902, 59154, 52903, 59158, 52904, 59152, 52905, 59153, 52906, 59155, 52907, 52908, 59156, 52909, 59159, 52910, 59166, 52911, 59167, 52912, 59165, 52913, 59163, 52914, 59164, 52915, 59160, 52916, 59162, 52917, 59161, 58688, 59120, 60804, 60805, 60806, 60807, 60808, 60809, 60810, 65942, 65943, 65944) AND `question_records`.`question_id` IN (21724, 21725, 21726, 21727) AND (NOT question_records.id in(1,7,61,381,413,438 ... 8893312,8893316,8893341,8893375)) GROUP BY question_records.question_id

 (Where the "in" is thousands of IDs long)
	SELECT question_records.* FROM `question_records` WHERE `question_records`.`enrollment_id` IN (50912, 59119, 56414, 59171, 52856, 59168, 52857, 59169, 52858, 59170, 52859, 59173, 52860, 59172, 52861, 59118, 52862, 59114, 52863, 59112, 52864, 59116, 52865, 59113, 52866, 59115, 52867, 59117, 52868, 59124, 52869, 59123, 52871, 59121, 52872, 59126, 52873, 59127, 52874, 59128, 52875, 59122, 52876, 59125, 52877, 59129, 52878, 59132, 52879, 59135, 52880, 59134, 52881, 59131, 52882, 52883, 59133, 52884, 59130, 52886, 59136, 52887, 59138, 52888, 59137, 52889, 59140, 52890, 59142, 52891, 59141, 52892, 59139, 52893, 59144, 52894, 59149, 52895, 59147, 52896, 59151, 52898, 59150, 52899, 59148, 52900, 59145, 52901, 59157, 52902, 59154, 52903, 59158, 52904, 59152, 52905, 59153, 52906, 59155, 52907, 52908, 59156, 52909, 59159, 52910, 59166, 52911, 59167, 52912, 59165, 52913, 59163, 52914, 59164, 52915, 59160, 52916, 59162, 52917, 59161, 58688, 59120, 60804, 60805, 60806, 60807, 60808, 60809, 60810, 65942, 65943, 65944) AND `question_records`.`question_id` IN (21724, 21725, 21726, 21727) AND (NOT question_records.id in(1,7,61,381,413,438 ... 8893312,8893316,8893341,8893375)) GROUP BY question_records.question_id

	(Where the "in" is thousands of IDs long)