All pastes #927073 Raw Edit

Unnamed

public text v1 · immutable
·published 2008-03-04 00:44 UTC
rendered paste body
+-------+----------------+-----------+----------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
| Id    | User           | Host      | db             | Command | Time | State                | Info                                                                                                 |
+-------+----------------+-----------+----------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
| 63688 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1334 | Locked               | SELECT a.aid, a.title, a.description, category, visibility, filepath, filename, url_prefix, pwidth,  |
| 63699 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1347 | Locked               | UPDATE cpg_pictures SET hits=hits+1, lasthit_ip='195.225.178.21', mtime=CURRENT_TIMESTAMP WHERE pid= |
| 63701 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1348 | Copying to tmp table | SELECT p.*, msg_id, author_id, msg_author, UNIX_TIMESTAMP(msg_date) as msg_date, msg_body, aid FROM  |
| 63702 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1346 | Locked               | SELECT COUNT(*) from cpg_comments, cpg_pictures  WHERE approved = 'YES' AND cpg_comments.pid = cpg_p |
| 63703 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1346 | Locked               | SELECT aid from cpg_pictures WHERE pid='3519' AND aid IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17, |
| 63706 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1346 | Locked               | UPDATE cpg_pictures SET hits=hits+1, lasthit_ip='195.225.178.21', mtime=CURRENT_TIMESTAMP WHERE pid= |
| 63708 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1347 | Locked               | UPDATE cpg_pictures SET hits=hits+1, lasthit_ip='195.225.178.21', mtime=CURRENT_TIMESTAMP WHERE pid= |
| 63709 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1346 | Locked               | UPDATE cpg_pictures SET hits=hits+1, lasthit_ip='195.225.178.21', mtime=CURRENT_TIMESTAMP WHERE pid= |
| 63710 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1345 | Locked               | SELECT COUNT(*) from cpg_comments, cpg_pictures  WHERE approved = 'YES' AND cpg_comments.pid = cpg_p |
| 63711 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1345 | Locked               | SELECT aid from cpg_pictures WHERE pid='259' AND aid IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,1 |
| 63712 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1345 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND hits > 0  AND aid NOT IN (19,30,62) AND |
| 63713 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1345 | Locked               | SELECT COUNT(*) from cpg_comments, cpg_pictures  WHERE approved = 'YES' AND cpg_comments.pid = cpg_p |
| 63714 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1344 | Locked               | UPDATE cpg_pictures SET hits=hits+1, lasthit_ip='195.225.178.21', mtime=CURRENT_TIMESTAMP WHERE pid= |
| 63716 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1345 | Locked               | SELECT COUNT(*) from cpg_comments, cpg_pictures  WHERE approved = 'YES' AND cpg_comments.pid = cpg_p |
| 63718 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1343 | Locked               | UPDATE cpg_pictures SET hits=hits+1, lasthit_ip='195.225.178.21', mtime=CURRENT_TIMESTAMP WHERE pid= |
| 63719 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1335 | Locked               | SELECT * FROM cpg_pictures WHERE approved = 'YES'AND hits > 0 AND aid IN (1,2,3,4,5,6,7,8,9,10,11,12 |
| 63720 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1334 | Locked               | SELECT * FROM cpg_pictures WHERE approved = 'YES'AND hits > 0 AND aid IN (1,2,3,4,5,6,7,8,9,10,11,12 |
| 63721 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1334 | Locked               | SELECT comments FROM cpg_pictures, cpg_albums WHERE cpg_pictures.aid = cpg_albums.aid AND pid='3523' |
| 63722 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1334 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND hits > 0  AND aid IN (66)               |
| 63726 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1325 | Locked               | SELECT COUNT(*) from cpg_comments, cpg_pictures  WHERE approved = 'YES' AND cpg_comments.pid = cpg_p |
| 63727 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1325 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE ((aid='55'  AND aid NOT IN (19,30,62) ) ) AND approved='YES' |
| 63728 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1324 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE ((aid='28'  AND aid NOT IN (19,30,62) ) ) AND approved='YES' |
| 63729 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1323 | Locked               | SELECT count(*) FROM cpg_comments as c LEFT JOIN cpg_pictures as p ON c.pid=p.pid LEFT JOIN cpg_albu |
| 63730 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1320 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND hits > 0  AND aid NOT IN (19,30,62)     |
| 63731 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1320 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND hits > 0  AND aid IN (67) AND aid NOT I |
| 63732 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1319 | Locked               | SELECT count(*) FROM cpg_comments as c LEFT JOIN cpg_pictures as p ON c.pid=p.pid LEFT JOIN cpg_albu |
| 63733 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1318 | Locked               | SELECT count(*) FROM cpg_comments as c LEFT JOIN cpg_pictures as p ON c.pid=p.pid LEFT JOIN cpg_albu |
| 63734 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1316 | Locked               | SELECT * FROM cpg_pictures WHERE approved = 'YES'AND hits > 0 AND aid IN (1,2,3,4,5,6,7,8,9,10,11,12 |
| 63735 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1316 | Locked               | SELECT count(*) FROM cpg_comments as c LEFT JOIN cpg_pictures as p ON c.pid=p.pid LEFT JOIN cpg_albu |
| 63736 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1315 | Locked               | SELECT * FROM cpg_pictures WHERE approved = 'YES'AND hits > 0 AND aid IN (1,2,3,4,5,6,7,8,9,10,11,12 |
| 63737 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1313 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND hits > 0  AND aid IN (53) AND aid NOT I |
| 63738 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1313 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND aid IN (1,2,3,4,5,6,7,8,9,10,11,12,13,1 |
| 63739 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1313 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND votes >= '1' AND aid NOT IN (19,30,62)  |
| 63740 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1313 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND hits > 0  AND aid IN (58) AND aid NOT I |
| 63741 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1313 | Locked               | SELECT count(*) FROM cpg_comments as c LEFT JOIN cpg_pictures as p ON c.pid=p.pid LEFT JOIN cpg_albu |
| 63742 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1312 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND hits > 0  AND aid NOT IN (19,30,62)     |
| 63743 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1308 | Locked               | SELECT count(*) FROM cpg_comments as c LEFT JOIN cpg_pictures as p ON c.pid=p.pid LEFT JOIN cpg_albu |
| 63744 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1308 | Locked               | SELECT aid from cpg_pictures WHERE pid='4256' AND aid IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17, |
| 63745 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1305 | Locked               | SELECT aid from cpg_pictures WHERE pid='3903' AND aid IN (1,8,13,16,18,20,21,22,23,28,33,35,40,41,44 |
| 63746 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1299 | Locked               | SELECT aid from cpg_pictures WHERE pid='292' AND aid IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,1 |
| 63747 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1299 | Locked               | SELECT * FROM cpg_pictures WHERE approved = 'YES'AND hits > 0 AND aid IN (1,2,3,4,5,6,7,8,9,10,11,12 |
| 63751 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1290 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND hits > 0  AND aid NOT IN (19,30,62)     |
| 63754 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1286 | Locked               | SELECT count(cpg_albums.aid) FROM cpg_pictures,cpg_albums WHERE cpg_pictures.aid = cpg_albums.aid AN |
| 63755 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1286 | Locked               | SELECT * FROM cpg_pictures WHERE approved = 'YES' AND votes >= '1' AND aid IN (1,2,3,4,5,6,7,8,9,10, |
| 63756 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1286 | Locked               | SELECT * FROM cpg_pictures WHERE approved = 'YES'AND hits > 0 AND aid IN (1,2,3,4,5,6,7,8,9,10,11,12 |
| 63757 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1285 | Locked               | SELECT * FROM cpg_pictures WHERE approved = 'YES'AND hits > 0 AND aid IN (1,2,3,4,5,6,7,8,9,10,11,12 |
| 63758 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1285 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND votes >= '1' AND aid NOT IN (19,30,62)  |
| 63759 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1284 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND votes >= '1' AND aid IN (67) AND aid NO |
| 63760 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1283 | Locked               | SELECT * from cpg_pictures WHERE ((aid='10'  AND aid NOT IN (19,30,62) ) ) AND approved='YES' AND ai |
| 63763 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1279 | Locked               | SELECT * FROM cpg_pictures WHERE approved = 'YES' AND cpg_pictures.aid IN (1,8,13,16,18,20,21,22,23, |
| 63764 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1279 | Locked               | SELECT * FROM cpg_pictures WHERE approved = 'YES' AND cpg_pictures.aid IN (1,8,13,16,18,20,21,22,23, |
| 63766 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1279 | Locked               | SELECT * FROM cpg_pictures WHERE approved = 'YES' AND cpg_pictures.aid IN (2,3,4,53,67,68,69)  ORDER |
| 63767 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1280 | Locked               | SELECT * FROM cpg_pictures WHERE approved = 'YES'AND hits > 0 AND aid IN (1,2,3,4,5,6,7,8,9,10,11,12 |
| 63768 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1279 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND pid IN (4354) AND aid NOT IN (19,30,62) |
| 63769 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1278 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND votes >= '1' AND aid IN (58) AND aid NO |
| 63770 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1278 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND votes >= '1' AND aid IN (53) AND aid NO |
| 63772 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1277 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND votes >= '1' AND aid NOT IN (19,30,62)  |
| 63773 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1277 | Locked               | SELECT * FROM cpg_pictures WHERE approved = 'YES' AND cpg_pictures.aid IN (2,3,4,53,67,68,69)  ORDER |
| 63775 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1271 | Locked               | SELECT * FROM cpg_pictures WHERE approved = 'YES' AND cpg_pictures.aid IN (5,7,10,11,14,15,29,31,32, |
| 63778 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1257 | Locked               | SELECT aid from cpg_pictures WHERE pid='4251' AND aid IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17, |
| 63780 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1256 | Locked               | SELECT * FROM cpg_pictures WHERE approved = 'YES'AND hits > 0 AND aid IN (1,2,3,4,5,6,7,8,9,10,11,12 |
| 63781 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1255 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND votes >= '1' AND aid NOT IN (19,30,62)  |
| 63782 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1252 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND aid IN (59) AND aid NOT IN (19,30,62)   |
| 63784 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1250 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND pid IN (141) AND aid NOT IN (19,30,62)  |
| 63785 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1250 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND pid IN (4265) AND aid NOT IN (19,30,62) |
| 63786 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1247 | Locked               | SELECT * FROM cpg_pictures WHERE approved = 'YES'AND hits > 0 AND aid IN (1,2,3,4,5,6,7,8,9,10,11,12 |
| 63787 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1247 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND aid IN (66) AND aid NOT IN (19,30,62)   |
| 63788 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1247 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND aid IN (66) AND aid NOT IN (19,30,62)   |
| 63791 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1244 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND pid IN (3918) AND aid NOT IN (19,30,62) |
| 63792 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1244 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE ((aid='39'  AND aid NOT IN (19,30,62) ) ) AND approved='YES' |
| 63793 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1244 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND pid IN (3724) AND aid NOT IN (19,30,62) |
| 63794 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1243 | Locked               | SELECT COUNT(*) FROM cpg_pictures WHERE ((title LIKE '%hGgriDprrtxYuwnK%' OR caption LIKE '%hGgriDpr |
| 63795 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1242 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND pid IN (923) AND aid NOT IN (19,30,62)  |
| 63797 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1241 | Locked               | SELECT aid from cpg_pictures WHERE pid='3876' AND aid IN (1,8,13,16,18,20,21,22,23,28,33,35,40,41,44 |
| 63798 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1239 | Locked               | SELECT COUNT(*) from cpg_comments, cpg_pictures  WHERE approved = 'YES' AND cpg_comments.pid = cpg_p |
| 63799 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1239 | Locked               | SELECT COUNT(*) from cpg_comments, cpg_pictures  WHERE approved = 'YES' AND cpg_comments.pid = cpg_p |
| 63800 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1238 | Locked               | SELECT aid from cpg_pictures WHERE pid='242' AND aid IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,1 |
| 63801 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1238 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND aid IN (10) AND aid NOT IN (19,30,62)   |
| 63802 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1226 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND votes >= '1' AND aid IN (2,3,4,53,67,68 |
| 63803 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1218 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND pid IN (295) AND aid NOT IN (19,30,62)  |
| 63804 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1217 | Locked               | SELECT COUNT(*) from cpg_comments, cpg_pictures  WHERE approved = 'YES' AND cpg_comments.pid = cpg_p |
| 63807 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1214 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND votes >= '1' AND aid IN (2,3,4,53,67,68 |
| 63808 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1214 | Locked               | SELECT COUNT(*) FROM cpg_pictures WHERE ((title LIKE '%aLFfUnQpGyXaT%' OR caption LIKE '%aLFfUnQpGyX |
| 63809 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1213 | Locked               | SELECT COUNT(*) FROM cpg_pictures WHERE ((title LIKE '%lJWMJJXORJYN%' OR caption LIKE '%lJWMJJXORJYN |
| 63810 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1212 | Locked               | SELECT COUNT(*) from cpg_comments, cpg_pictures  WHERE approved = 'YES' AND cpg_comments.pid = cpg_p |
| 63811 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1212 | Locked               | SELECT COUNT(*) from cpg_comments, cpg_pictures  WHERE approved = 'YES' AND cpg_comments.pid = cpg_p |
| 63812 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1210 | Locked               | SELECT * FROM cpg_pictures WHERE approved = 'YES' AND votes >= '1' AND aid IN (1,2,3,4,5,6,7,8,9,10, |
| 63815 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1208 | Locked               | SELECT COUNT(*) FROM cpg_pictures WHERE ((title LIKE '%HLCzivPPsCpZB%' OR caption LIKE '%HLCzivPPsCp |
| 63816 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1207 | Locked               | SELECT COUNT(*) FROM cpg_pictures WHERE ((title LIKE '%HyqVMKuTR%' OR caption LIKE '%HyqVMKuTR%' OR  |
| 63818 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1206 | Locked               | SELECT COUNT(*) FROM cpg_pictures WHERE ((title LIKE '%BmWMXOVzGZALsHgoL%' OR caption LIKE '%BmWMXOV |
| 63821 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1204 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND hits > 0  AND aid IN (67) AND aid NOT I |
| 63822 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1203 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND hits > 0  AND aid IN (67) AND aid NOT I |
| 63823 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1202 | Locked               | SELECT COUNT(*) from cpg_comments, cpg_pictures  WHERE approved = 'YES' AND cpg_comments.pid = cpg_p |
| 63824 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1196 | Locked               | SELECT * FROM cpg_pictures WHERE approved = 'YES'AND hits > 0 AND aid IN (1,2,3,4,5,6,7,8,9,10,11,12 |
| 63825 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1195 | Locked               | SELECT * FROM cpg_pictures WHERE approved = 'YES'AND hits > 0 AND aid IN (1,2,3,4,5,6,7,8,9,10,11,12 |
| 63826 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1188 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND aid IN (1,2,3,4,5,6,7,8,9,10,11,12,13,1 |
| 63827 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1188 | Locked               | SELECT * FROM cpg_pictures WHERE approved = 'YES'AND hits > 0 AND aid IN (1,2,3,4,5,6,7,8,9,10,11,12 |
| 63829 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1182 | Locked               | SELECT COUNT(*) FROM cpg_pictures WHERE ((title LIKE '%yqmvvIFiXQmbGmxaBu%' OR caption LIKE '%yqmvvI |
| 63830 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1182 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND hits > 0  AND aid IN (59) AND aid NOT I |
| 63831 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1179 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE ((aid='4'  AND aid NOT IN (19,30,62) ) ) AND approved='YES'  |
| 63832 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1177 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND hits > 0  AND aid IN (66) AND aid NOT I |
| 63833 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1176 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND hits > 0  AND aid IN (66) AND aid NOT I |
| 63835 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1169 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND votes >= '1' AND aid IN (67) AND aid NO |
| 63836 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1167 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND votes >= '1' AND aid IN (67) AND aid NO |
| 63837 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1167 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND hits > 0  AND aid IN (10) AND aid NOT I |
| 63838 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1162 | Locked               | SELECT aid from cpg_pictures WHERE pid='184' AND aid IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,1 |
| 63839 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1161 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND aid IN (1,2,3,4,5,6,7,8,9,10,11,12,13,1 |
| 63841 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1152 | Locked               | SELECT * FROM cpg_pictures WHERE approved = 'YES'AND hits > 0 AND aid IN (1,2,3,4,5,6,7,8,9,10,11,12 |
| 63842 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1151 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND aid IN (1,2,3,4,5,6,7,8,9,10,11,12,13,1 |
| 63843 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1147 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND votes >= '1' AND aid IN (59) AND aid NO |
| 63845 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1145 | Locked               | SELECT aid from cpg_pictures WHERE pid='2549' AND aid IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17, |
| 63846 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1142 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND votes >= '1' AND aid IN (66) AND aid NO |
| 63847 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1138 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND hits > 0  AND aid IN (66)               |
| 63849 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1134 | Locked               | SELECT aid from cpg_pictures WHERE pid='2428' AND aid IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17, |
| 63850 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1133 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND pid IN (4256) AND aid NOT IN (19,30,62) |
| 63851 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1132 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND votes >= '1' AND aid IN (10) AND aid NO |
| 63852 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1132 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND pid IN (4257) AND aid NOT IN (19,30,62) |
| 63853 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1131 | Locked               | SELECT * FROM cpg_pictures WHERE approved = 'YES'AND hits > 0 AND aid IN (1,2,3,4,5,6,7,8,9,10,11,12 |
| 63854 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1127 | Locked               | SELECT * FROM cpg_pictures WHERE approved = 'YES'AND hits > 0 AND aid IN (1,2,3,4,5,6,7,8,9,10,11,12 |
| 63855 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1121 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE ((aid='58'  AND aid NOT IN (19,30,62) ) ) AND approved='YES' |
| 63856 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1110 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND pid IN (3990) AND aid NOT IN (19,30,62) |
| 63857 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1107 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND pid IN (4225) AND aid NOT IN (19,30,62) |
| 63860 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1097 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND pid IN (449) AND aid NOT IN (19,30,62)  |
| 63861 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1096 | Locked               | SELECT COUNT(*) FROM cpg_pictures WHERE ((title LIKE '%CgSvWyJv%' OR caption LIKE '%CgSvWyJv%' OR ke |
| 63862 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1096 | Locked               | SELECT COUNT(*) FROM cpg_pictures WHERE ((title LIKE '%MzXmcqhNYvPv%' OR caption LIKE '%MzXmcqhNYvPv |
| 63863 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1092 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND votes >= '1' AND aid IN (66) AND aid NO |
| 63870 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1060 | Locked               | SELECT COUNT(*) FROM cpg_pictures WHERE ((title LIKE '%mOnxqvAiCZhjJcVTRM%' OR caption LIKE '%mOnxqv |
| 63872 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1058 | Locked               | SELECT COUNT(*) FROM cpg_pictures WHERE ((title LIKE '%tpTXEsPpWv%' OR caption LIKE '%tpTXEsPpWv%' O |
| 63873 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1055 | Locked               | SELECT COUNT(*) FROM cpg_pictures WHERE ((title LIKE '%WYrUOCUMLdUm%' OR caption LIKE '%WYrUOCUMLdUm |
| 63874 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1050 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND pid IN (4238) AND aid NOT IN (19,30,62) |
| 63892 | factsite_copp2 | localhost | factsite_copp2 | Query   | 1021 | Locked               | SELECT COUNT(*) FROM cpg_pictures WHERE ((title LIKE '%cDByxryiMDxym%' OR caption LIKE '%cDByxryiMDx |
| 63940 | factsite_copp2 | localhost | factsite_copp2 | Query   |  449 | Locked               | SELECT aid from cpg_pictures WHERE pid='186' AND aid IN (6,9,12,17,34,38,42,49,51,59,61,70)  LIMIT 1 |
| 63941 | factsite_copp2 | localhost | factsite_copp2 | Query   |  449 | Locked               | SELECT * FROM cpg_pictures WHERE approved = 'YES'AND hits > 0 AND aid IN (1,2,3,4,5,6,7,8,9,10,11,12 |
| 63942 | factsite_copp2 | localhost | factsite_copp2 | Query   |  444 | Locked               | SELECT aid from cpg_pictures WHERE pid='2879' AND aid IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17, |
| 63943 | factsite_copp2 | localhost | factsite_copp2 | Query   |  444 | Locked               | SELECT * FROM cpg_pictures WHERE approved = 'YES'AND hits > 0 AND aid IN (1,2,3,4,5,6,7,8,9,10,11,12 |
| 63945 | factsite_copp2 | localhost | factsite_copp2 | Query   |  441 | Locked               | SELECT * FROM cpg_pictures WHERE approved = 'YES'AND hits > 0 AND aid IN (1,2,3,4,5,6,7,8,9,10,11,12 |
| 63946 | factsite_copp2 | localhost | factsite_copp2 | Query   |  440 | Locked               | SELECT aid from cpg_pictures WHERE pid='3920' AND aid IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17, |
| 63947 | factsite_copp2 | localhost | factsite_copp2 | Query   |  434 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND aid IN (55)                             |
| 63948 | factsite_copp2 | localhost | factsite_copp2 | Query   |  429 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND aid IN (1,2,3,4,5,6,7,8,9,10,11,12,13,1 |
| 63949 | factsite_copp2 | localhost | factsite_copp2 | Query   |  427 | Locked               | SELECT aid from cpg_pictures WHERE pid='3737' AND aid IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17, |
| 63950 | factsite_copp2 | localhost | factsite_copp2 | Query   |  427 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE ((aid='3'  AND aid NOT IN (19,30,62) ) ) AND approved='YES'  |
| 63953 | factsite_copp2 | localhost | factsite_copp2 | Query   |  383 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND aid IN (1,2,3,4,5,6,7,8,9,10,11,12,13,1 |
| 63955 | factsite_copp2 | localhost | factsite_copp2 | Query   |  308 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND aid IN (1,2,3,4,5,6,7,8,9,10,11,12,13,1 |
| 63963 | factsite_copp2 | localhost | factsite_copp2 | Query   |  236 | Locked               | SELECT * FROM cpg_pictures WHERE approved = 'YES'AND hits > 0 AND aid IN (1,2,3,4,5,6,7,8,9,10,11,12 |
| 63970 | factsite_copp2 | localhost | factsite_copp2 | Query   |  121 | Locked               | SELECT COUNT(*) from cpg_pictures WHERE ((aid='45'  AND aid NOT IN (19,30,62) ) ) AND approved='YES' |
| 63971 | factsite_copp2 | localhost | factsite_copp2 | Query   |  104 | Locked               | SELECT aid from cpg_pictures WHERE pid='3674' AND aid IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17, |
| 63980 | factsite_copp2 | localhost | factsite_copp2 | Query   |   74 | Locked               | SELECT comments FROM cpg_pictures, cpg_albums WHERE cpg_pictures.aid = cpg_albums.aid AND pid='876'  |
| 63995 | factsite_copp2 | localhost | factsite_copp2 | Query   |   24 | Locked               | SELECT aid from cpg_pictures WHERE pid='302' AND aid IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,1 |
| 64004 | factsite_copp2 | localhost | factsite_copp2 | Query   |    7 | Locked               | SELECT * FROM cpg_pictures WHERE approved = 'YES'AND hits > 0 AND aid IN (1,2,3,4,5,6,7,8,9,10,11,12 |
| 64007 | root           | localhost | NULL           | Query   |    0 | NULL                 | show processlist                                                                                     |
+-------+----------------+-----------+----------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
150 rows in set (0.00 sec)