+-------+----------------+-----------+----------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+ | 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)