SmartCJ Support Forum

Code: Select all

1.
Query 	120 	Sending data 	select  g.id, g.gallery_md5, gs.total_shows as thumb_casts, gs.total_clicks as clicks, if (gs.total_shows < 200, 1, 0) as new_thumb  FROM rot_galleries as g JOIN rot_gallery_stats11 as gs on gs.thumb_id = g.id WHERE g.status = 1   AND g.rgroup != 0  and g.sponsor_id NOT IN (28,29,30,28,29,30)  AND g.id IN ( SELECT gal_id FROM rot_gal2group as g2gr WHERE g2gr.group_id NOT IN (3))  AND g.id NOT IN ( SELECT gal_id FROM rot_gal2group as g2gr WHERE g2gr.group_id IN (3))  AND g.gallery_md5 NOT IN ('8ef2e43d4ec3219ce1cfd378dd6ea52e','4038ec527227bef57695121ab2afd412','509ce9a83d3ca1c202ada17b6f681e76','a80f5d9975fc9327a1f9360cab0fe37e','6598b0e5fa1afa59cecbdaa9b54a2af5','a87717340cd15a86e6b7617c0c035d1e','5b77f10e4bc9158dd03ab37c66cba73a','827aa9c1c6b3796349bd5436c500a6b8','a26b88af519ee848965d72ce544dde07','679481cfc5dda9718b66248c648c541b','85ebdbc684313e9fb93f05ab40c56b76','43093bc7e1b75064134acd4cbd0e78d6','9d450a0558965f81e68792ea40c64231','a194124f91000edf22a39e6d84e09bc6','4683b1d515f80dfd37177e903c3d4d4c','65d9c9205317f2584a717ee8bed36f0d','7cdd0187885954a1d5c36d472905dbf1','a5b45c0c63e08181afb3c9c8b74ae524','7aa12d2ef3af103de86eeb738a293b94','a5cd1771214d1cd69ab778ab68b2dd1a','a463b4c47551bdf50e663f96337cf0d8','a6795d155ce6459b1cfb0b3191af49a1','a25919d2f4754d2b677f3ae43a2edc5c','96aac30e29c4e8f5aaa61bc58e216eb4','7a1e6f1fa2a33065a3f90c744a7f7aaa','98785a5dc3948b9acb52516cb1c42328','579df54a55fd5abb24e7af22b8c53942','90afcb6c36db14d89e4c8a527d43a7d3','aa27d6ac6e74686745f991c4bbcdc134','a7ee4a141ae5d7e3e3a42ae540728256','a2baebe5076a43da96643f64a9e2de67','a28b93eafb26d21bdf87a78bf9697e4e','515d2fd82af7ff576f1ba67fd33d5f66','8fca3ea1ebc9ec442055419bb80ee28b','a769e9f653722ccac70ef12d15d5c22a','8460a5e2db6b9a0b9fe5a2b1556d835a','a5a81d7617ac56d85aef6bb3599533c2','5182e70742fcb8eec25a8a5b311e2e43','51a503f1483daa52423f42394db82b1e','a9ce675534078774493d483fee624435','e8591f81ce6fc08f282ff6db2d2122a3','49185d57481bb05ff11f8239ae5a7255','a7165a60a8cf1ba9f97141d1fd3015c6','9a8a98045cbc5e827f4d135896edc725','a8a69cacf894000c8560f6feef85c539','5ceb8937b327e7a9b2c107236a26c398','a65a29212a4bedbc6f0729647e433692','a99a7254c17991feda24990ec0d00328','a92481121049fa3b9e8f0ccade3ef87a','a2b576b14d54bff35135d68edb506ff9','98cf49e40063aac94c444efda69b7164','56a9844280b80ecf450b3b109157f202','a630f7f266f528d98d597fb361c42eaf','9f7152cbc18de76ef9be78a25f0c93c1','90e883c7695393a1e69797ec4330093a','a25692a1b3ca80b1dabe6b4cd94eec37','9cf1b4e150963531687e1ab011b78e07','ef7aaa3604df8e58ea7a27f583a9dd5e','b1bbed222f3c02a549dfc1f33488ac3a','9ab57f99598838ed083ae9b1846afc32','1795f2b700fca3bc22699072834b4433','9e07c0b741448f57fde70111b03c47f8','375f7f74590fb025d549b639de0def02','a80b15bc3a0c5ae92fe10d8da682f3ad','a6aca6f821edebb49c7074327625220e','a7b172c02f4ca496697e84c6aa8dd652','a649cd39f984816efae90acd96542e0a','2aa59a4b647af2043adb225f479b2a1f','a8faea65a3e503cd1797ffa44f2c6e93','7698c7101efb41c6036430c7e3cf74bb','a6e00102b1245584e15d8cb29d9aaa71','a86e1572bb4e69689e53cc3bd4d739a5','a81e9e65cee19888239183d8500c1131','a2cc6647b4bad4e9f07e861ca04ea7ac','a81cd44c0cacf26f559de278e36e3f06','9fc9c044d6b980e8691eeb63d899bf01','95aee59f06ea6197058ba5cc20c8cfea','4ccbb8eeeda629c82157e433a3c45422','6429f5b2c0b4b3661cd65230a0ad4ee8','460dfc870427fcbbf557c669826350ae','a3e6a92450a0e6a68502f3ede453c499','89813236665156b0c85082004112aaf5','2f3434416de6e68b5e8ee70970ca433a','9ea7df938b9b4952a3bcfe2ad67f14b1','981b75e92640b4bdf81fb6fd875b75c7','a45877da2fdf1647848a1deb05e656d5','94a064bec42f815e8ea799a7f8d90f96','a50ec851b02d2e507f8912f02912385a','170717635f4f196a3b76c47606e94d3e','debfa33a324de84535ca604e9c2c5356','aa524c1c86ccacb0ffb02193aa59a381','a5daab14d71874462b2ffc58c5d0b167','5305e516751dc27181a900761adb27ab','a1b8f6afa2967864037c2e54e86949db','9c73682df8424c0804b7e2314aff4f59','a3ff015268bc74663d2695761f0809d2','a9b29e1c72f4cfa72a85b6115f97b071','a7ada1f49c53fc6c7e3a6f8287be7577','94baacc92c8b46ea32b5483e5336951f','669664c985e27783d67a0aee5c41264c','a84e793d750a1372b0a3788dcf5d5288','a5d9c9c7854b599e73e7740c9da3696b','d002882cfe2e85282b1b1ccdb4474237','a38bb836d7b620fdbe4a2b97059c017c','a670df1a230f8ab15fb0b14479d0bac6','a5967ce238a7c920195c7a5698e9e766','a5198f052c9e6dad9a71a7c85a191ffc','9f67213f4a0968b74c1fc0aa87a762aa','18da5131df39ff6b47ad1c80d0da0f82','6b5149d8e631cf3b2734af4e48d21fd7','a571abbda9374087fe6fadc92b4c0595','b1068ba894745819dee631d1fe218919','4bc75659d1dac719ca2e382a893354f2','517354958bff391d084ab498ee7e7e80','a8547bfd7231f602022cc9b3120baa5a','a1efb2c610f70a4cb169c9bf2200027a','a985ae58cd80dfce30399017ce1e7b6e','a7a299d5430839f816e780e2554ba287','a66dab2c4c80ff26c482030b904089a7','a4c3ba70f225f8fca2d61b97eb1571ca','a81ef0f500a8da2f8b13799e87751880','f91ca6e6e4ccd2d90d227a177e78ad04','a957cf0c2ae0be2385f9e1e72f742cfd','a317f0d72bf1b7c0c4a81e7de02102d2','a6ad30cf4aa22edf5b32b9d5b1e50466','a0a16b35523f7ee9fdff5cf4b0a04d46','a93623cea184659e21750bc61cb1c99b','a3f1dd8e80d87a9d8c2933f14f54de09','a5ace9103a8eb4fc4dedd8390013b26a','a8d461718f4eae0ff908be3710175230','a8b3328be5f626b78c40d8db83fdb8a6','a86b539fe23c6ecc69366ec94180d2b6','a4cb38e0c972bb5f72735eb9766e2adf','dff5a953d06d511a90fafadab00fdc78','a78b367eef6a9f9700372b0b2233749e','a4a2978c7d078e4a425b5091c36cba2f','367548f0a82ebd0d8a2a410a496367ae','5c80866cb93df77ca6ab6982095ab201','355adf6d044c8c42812a8cda0de403e7','9e3b2d244a153c162650a69aa4ceec58','50c6058a2b55b865e3d4e38d90f1f6f0','26ec275e34563c0fcbca21aab33df2ec','1f3f01b4feec3fbe93d8c8fec436a467','d8e3d8d2ca20db209051c6854f871826')  AND gs.total_shows < 200 GROUP BY gallery_md5   LIMIT 0, 14# queryitems
2.
Query 	473 	Sending data 	select  g.id, g.gallery_md5, gs.total_shows as thumb_casts, gs.total_clicks as clicks, if (gs.total_shows < 500, 1, 0) as new_thumb  FROM rot_galleries as g JOIN rot_gallery_stats32 as gs on gs.thumb_id = g.id WHERE g.status = 1   AND g.rgroup != 0  AND g.id IN ( SELECT gal_id FROM rot_gal2group as g2gr WHERE g2gr.group_id NOT IN (3))  AND g.id NOT IN ( SELECT gal_id FROM rot_gal2group as g2gr WHERE g2gr.group_id IN (3))  AND g.gallery_md5 NOT IN ('88678013559f88030ee62feb0ff84eaf','ca940ca0e7d3b390272e4777f48d5deb','0b85362fadc046b184c4c0f2cefdd038','1b712ddd93b6c4f59dc1c2edec09e404','686a3053f4af7b9c902616bf54c0b550','fa5b204bdaaaa503ffbec56026fc0ea3','a70c3b3db5c829dfd613ab6cb4d02de1','2027f80e5779cb775dcbf615ac8ae63c','edfc9beb7fddd8de3f9067d23dd153fc','047309b57c2e319f101d7b1b125b163a','c146f1f56577fa2a3c957555b815340a','61ca02d2eafd2db4ea6077e736ceeb60','15c0ec3abc6f83c0fbefb3cb06125192','2d63f60726ef834ee3a3164bf3cc16c5','3420e8dee0df35562025a7a430f37795','1875cd903a2d62bcc40fd53a07835574','66b3e10ffd6b84ae999a578db7b33eaf','2029b8d6b1f620f33bfdaf1c74c93db1','097b839de162184252398a7517978edf','f5c87c29a991248a1b089a3814d68ec0','21fa4b22b5645de797b5d3ee46eaa905','f5105a93c9c099352fe00f8b1642201c','c96cac3774fd4f0d3e06d1e172da2677','85a58663f8316c26395faa2e64fc56e8','7da777b2d66c92e4c9d093e67a1cde6e','19047ffbcba02da7b6c34d777b067ee5','1bda08d0fd869609cbeaa3b6c7f97a43','115503313305272f68764789ad3eec12','14d5b03dc99d9d6390d3f7d48ada1370','82b41bd6c0f5bff2dd36875907038671','e79a7e0cfbc193e8bb977a14a3849024','dd18ab8814074acb6b1df81e03fa2879','34b8937c8eed5b7248a121f87c354d91','a3116322df33e1bd7c5805df634cf23e','531dca92a463845b18859407122ac84a','de425350c11083435ea85d13ae9f9c48','b54626b9b9c8f2500483a91764eecca9','3d9cdab60e12dfa579dbf9393aa3912f','d3580480ab868ef27947c96b3d410cbe','9ceef90afb9e8f2db17e5e896cd1fa33','e2bca764db8791efcdd5988636ae0473','d4f2d4b2e87bde3292fb051c95a1cf24','d20e70e8b79622071bfb1d08aa660b89','dab9d16736fcb3d727d97afb88d7f0d2','e9ab50e9ea83df162b734a69e1ff80e2','5b354f6e01929760ae95c19141e93136','0587ccda9a11aeefbb46d048f6bc949e','e361cda31325bcf623115add9764139a','f95e4a5be5d66b88a1f16d9178963a6b','18819ab6e67e9b43c065bef7554af05c','738450a1e78b7890ed69f4f724c9082e','fdaad01f98efed6f7d4bfc70e0a9b7b8','b28d19931d784146ea7ace0266888175','3cba8584ea887e37b2a426c71ebe85fb','2685969b717c6405628d092a7cab4180','09d83900f8349dca50feb5b3d2c7a6d4','83b2ba194acb809fa01b249ab5762717','5287f99f34947927c6721c4f7d14fd78','4308c058c5582adf9d6f7229e9c44d8d','4b298694de297bc64f3458676a955c8e','46adfaacc88e8819a367c53c0828b905','960e3cca20df45011f411138aac43c52','74c1ff9059ba2f03838685da5e3dda77','06ecabb52a226aa6e131aaac5d667d10','8508ec1aab6613ce4cbef1799062afda','3b968224a38689c1b28a9cc8833156e7','ddfca5e4342e0fffad19e3c13e160c1a','f443718e5b16913e7b3a8b3947ccd8c0','7454ed17bb32ff59d07c9094611af0c7','c3e14afb5373c91f79bdf8e1570f0374','c655a339428255ff59afc80ecfb1e4f6','5c4d8fa8a507869e583b931303c75030','4bcfe01c476da0878a907abbf445e048','37400589dbc832a5e693b2e5f79630c5','09cb6c01d8a1ec966daa29ee8b41b9f5','bab989abcdb97891e7cbca230a579bee','95c7cbfe61f6e5677f4c681284eb43ed','6c27257aa496cab859479948a6a67182','d3f3be5b7b2ecf2ecf3de8da4f216bd3','cea8140d14e89621da6ce67c06f70d14','043535406665bb95963424f6bb2aa9b8','184bea29e14ec6521ed2322e2f32ad2c','2b87c442e289702ef5af401adc8f4420','cf6cbcf2c23b6a040259b20e28dadfce','19ba104856a25d4498a21fa289e08383','b93c0248c04320e67d10f8e515bc8a01','96800399efde33a4beb09d48b8443ffd','bb90c6fdea8b687fe5ee8735cae29555','f97a66be17a69278ec32aec801f08ab2','07d8b7afb653e1c0f4ebd19ef79142e7','3076c0b98541dbaf33ebafecc943d904','13c9c6fb062d4d0aa02a78cbea4f4870','fdca7c3bb9f23b8ee1a9e2142f257a08','9c3b71fd9c60e1f60faaecdd6df69270','66a5b79d9f2a8b18e0fef81a3a13c432','94a992697c69b2487897714ad0e6a766','223d8cfbb1df54eb7c7ec863f14c0f88','3977bd71eb39509184dba4895074c684','7a6b6d1e585d832371babd814bdfa49a','ec46706771d5518385f60b2028b9e843','2fe12c844bff3e0f32a12164fd036d3a','486373f3f580d3adb25b582720fa15f9','c511fefd0b1ea5abcfafdb1702ed4536','871c9539c2e76eb853bc4773f8f2ccb2','9183f3976ef350efdfbf4ddc26624b37','3af1a6d08e929aee01ea3da04149d6aa','fc87490abfb1318885fc700f9bdee43b','c95f2ddc41e3eda0e556e5ae34eb51ce','cd679ae8fd29c07ed1f8f47852c82296','f3c81278795ce983e6ef8a1f89034010','5ce43b6dc07bacc267475588142349c8','d22a6d8a5a80be60ab1bb5e5416f5ddf','2688ce2be8635233ef138c751ef20cdf','a9cefd2eb7b017ed0c976197c19eb68a','b7bc354e91b1d8342dc674b6625f7896','592d72f8e76d0c34d09d5270ecc736cd','9de7292dc2152f239ab94cef6fd1821e','3a5eb3c9dd373a3349f350eea6c2c054','4058088f69938345b5ccefaa3becea2d','4c991af7c90fa0968d5c2d05078f989b','45ea332a311a1e0e6179299a9054e112','947003df09290044c253c2b31358c849','1ccd812436041afa7ba7f83f7428a75b','4b4b5f568ef2df54c5f91278132312de','fd8ef958a0dab78753bcb381c46f08be','c236c5474560d75499379238efc6262c','e9a4a6be0aa7ea324da5519be33c0d89','db80f8219bbac827bec1b7995ea9fd9b','9d9643d7c06f6e044c63c3f4289048ab','6110ae0af7e98f7ad5166b03a57687b9','1a1e2ef722021f9870357ae0934ebd3b','c60a5c9b3351be22a33a202fd11832b3','5e763537c159edcad68e202cc2f161ef','1c2d5951082fa6914aa224f86c614602','fbec0339eb396fef31cf95c51ef2e4ad','ac821f86b1527d63cd414339ae7b9a1a','ca3cb02bdaad78fd367032925609d606','84b4e1798ec80139c1bcb2cb0d8365a1','fbeff17eaec8edd73ebb37732d512346','297c95bb7e29befd84b1adcbf81594ab','8f67ace871a784c8640a1bd9487590ec','2358df3ab50d0e5a6bbaf1434c57d83b','824b56dd6391e6c52c4136d03c12b41f','594edbc56a927dc780b619ea9b815148')  AND gs.total_shows < 500 GROUP BY gallery_md5   LIMIT 0, 20# queryitems
3.
Query 	81 	Sending data 	select  g.id, g.gallery_md5, gs.total_shows as thumb_casts, gs.total_clicks as clicks, if (gs.total_shows < 500, 1, 0) as new_thumb  FROM rot_galleries as g JOIN rot_gallery_stats14 as gs on gs.thumb_id = g.id WHERE g.status = 1   AND g.rgroup != 0  AND g.id IN ( SELECT gal_id FROM rot_gal2group as g2gr WHERE g2gr.group_id NOT IN (3))  AND g.id NOT IN ( SELECT gal_id FROM rot_gal2group as g2gr WHERE g2gr.group_id IN (3))  AND g.gallery_md5 NOT IN ('413d0ef0fc3a47e2350f7d5515d0d2ec','25b04acdd0fbafdc9fed9b7e85b08dd2','42faeecf1edc6dbfbba1dca30b905bab','0187d36df63ab304bfde858e2d4aca1a','6d519e0ad40f7737cf20d75c0467017d','edfc9beb7fddd8de3f9067d23dd153fc','21e8106d48124ac456601658fdb1140d','18b8f76965807945d08f5e318cadced0','27dd846e22625022e217b4260a13d380','2fffde3ec5821321b7740bb293578f03','fa5b204bdaaaa503ffbec56026fc0ea3','964b3e1d901c7630b87535220b58abca','4cbd0098fa1d41035417f79c0cf7cf4e','93946e474755b4f633ce202923fb10ae','7a840177042bb6c2c2b30717653d75c8','29625a32dad5edfa5c093d0b97529feb','7e92328bd5f797036496f5129be580e1','5662cbe683badf5f02b3f09b591b0ed1','4194645a6fc5f31de6fc27a87acad609','cb62da33044468c936252f4634670c9d','d8acb9d2f4bf81cdce3f4fa2a689a43a','6c27e64abd3a225d84e5b1719789204a','d5916cb45d460a6d30808d5302c2aeba','cba3f963eb42a84472141513f3096383','b964566d59608831613a0de6776118d1','9f773f65dfd5ad6554c6de1d9a290995','b4c591db1888259c5e123250348e198d','86354b8a28f04f42a3a4a186e36c9deb','585dde9aebd8c88ac143118a313587ce','eb1cbb89b9e4ffe6a2ce3f4122dbfdaa','100ad61598ad9da8bb2fa828648eea22','bf1b27771f2931b54745e3ab99acdb3b','9edac472fb688ff558e5904c6dbe9715','85ee31792309e43d334888351de48d39','b8bcfb1d065aa63ac77f798866a16380','e8d4c7c98ffe9ab3693949ec6d37bfbe','d78cf468c56d8729592705ca5af2a745','ba089e24cddaed6b59561bb468345ed9','344c0eeca4692ee69f8e6824290b7866','185fe61154c040b2d2ee8f36d2c996a4','6c3367a80805314436d4eed17160eb0d','c0fd6e80fbc955b8c7f889c15d0ecadc','10bffe678af6585393ff32294c5b9637','336021801073efffedec7663ba47ee8e','b206b938a97176f672ca0976cf935f27','7b5714625535bdfc764ee648e9ebcfdd','bc1ff7b5e784c15e0db941b92e170531','62b8d268dde125ee50dfce9437da483e','335e4d44e1fce4f6dd0ca04272410c43','2e3679c55a64ad463e32dcb5318797b1','27a03920cf6e1d861ad35bec7072d4db','71783e966497710ba3acf6974d88ce24','7b9538e4ecea6e691c0641808d40795b','acdebcb6c03a8964827cdca1d2550e33','590044fd2210392a8bce9cf1bb1902ad','841ee2986d658d8296860661de505ea1','16dad3c586754d7890ba5b61a9953e1b','3c109bf84df8486a67b2f603e793ef62','d9d5b444467489ce7ab48091212e02c7','ae089fb6bfe4286917e36246bee6e62d','956f8ada670c17902979d4e33fae4e88','a6cacf7eb51c2c991b3707777f8d6ab0','87cc1b25e7cdd69990954cb920c40fcb','e9c323c2d79958006014d8b302b53bfc','ad677adfc172a233e3634c21aeacd5c4','b30b7330181a46278dcc5749774c5fb4','389fb1254dbdfe337177076d43a2e3e0','dd646a6cb08ecc245d17e5d813fb629e','5150bf98496d9d842c191187fa9fe549','20e506032014eaade3452d999df7533b','d8fa079f86f7e9fae6eaac8f142df0cf','26d6fac394aaf12a85115bf2e3c6db34','20c56b01abe419d775a3a47ae03da187','76c3b49fe372e1c8175c0fafc25b467d','2378e5f84d10fb445cd1fd7ca8cf600a','15b705f6755780249340e3c3452ac294','b1fc88ac6e33c74da41f5ea6660cecf1','7384b6c643ecb5dc2629156beb42a2f0','adb5ec8b5fb1509b8b62ca92f11440f4','6b429d0dced773818590398688cbbb94','0a88a50f95e130b3ae2682b1dbc06322','4b5ffb0a4256fa5e32e795adb2e14b17','fe4dd2a079dd86c98e53edf80a43f855','100173e92a0a97591e0eb618a30213d4','a18ad9a7143582946e16cd1725bfb234','129e9ba160130988b3f8194d31e67127','950c86215918ca5c193e102e585654b5','960e3cca20df45011f411138aac43c52','9a17030e9abcd83de5d3e4eeb330ba28','61ac99436374f1d8e90af59b16381605','4fb2b205b06ca531dcc87a8ef0725a5b','b98b6a3ae073b5d28f4b62a092861bb7','5b6b9f242bc539d4c6e323dc628c3bac','36519564b2f9ac2d26a8ad33ea7016e7','77fd49098a5b58604c68b209b9f1b4c5','32ed8646630869de8374b1037bd617e6','2274177bf506ccb86fe1bda072db19bb','1eacfb6a7861c3910dfc08eeda6fe650','63ca1692ee305345047ffbd97403e505','a26bdc9a5bb7d3fbf2b945271bd21b22','5ca13ec41d3cf087e5bf4350be99dbcb','fe6c7aa479bbe69e62d41f7f5cea713b','00974aa6882ebec328b3deca41d60438','6cea515f5c7b92227ce24b3f5078a256','d380a1e17eb37e5db11a632541c5e409','7488f3811c205ee60e7f6f3183119573','c470c16ef134b085e4f87274c3b61f1d','ca07b896732c4bc47ff8cb0034decc46','49f9db0aa3f3c14b8c3418e53c482113','6c92ba0aa3d9f37e0be8aaffb70c87f3','57aa7e46c549eb59836a11729f88a287','6ee314b422e714e29d57d5c2b109a093','0736b6da88e433aa411943d944b3c7ee','ff55c6a16feee3feb0a1acfaa230c727','57f9881c39fdf66a5bfe716164f2da5b','0ecdf93051098a592ddcc6989a2ea205','341e9356f481cd886cc1c3e078647215','693ad6b31655c3d00314620c71904218','19c8144fb4076931c543f02f0474b478','5191ae6b91e9858a1ecb25ceb10e5b2b','4d702c835935c5f5806ce69d363faa4f','42f28fa13bbdd04697878f4f8cf60d9c','80b7f281dfac62e7fc8e5ab43e465dca','01ae926a98773f9838d4ca4911f0dcac','53e32d3b2e6239c3e4123c67c427ebe4','69077dc38bbcc80f5ae3088cbe8177c4','d3a383687275fb21d6633517d3e99868','9b87074336289671dd1ee8748f45a070','c94f0c9cee89559d04a9ffe80367307f','1676b02ca966e2d922ddde8ed94e3f6d','8319de42292524b6176744488c947c2a','c5702b3b2a2029ed447a6fad83711051','d407fbb91e1ca2c7427ad434b35b67bd','d3ebf0d78ce557821f8c11ed9be839ff','6c53b7b35c8869d1d3171f3b58287796','ca45e42996317dff1ee07b070a684ac9','097b839de162184252398a7517978edf','e06acf496162c3c365058b84890f30f9','ebfebec03ce3709f63118a2ed2f99c46','b3d4ab2c17f42c472c006f902d71e6a6','f2355ea12c5c0950ce3c6cc5d989350d','63695fba9a01b47c9d98e5459de81f41','7ebc0923d4ef5cc9608e789b353af20b','f4f6cf13f253f693b11eb584049e91d2')  AND gs.total_shows < 500 GROUP BY gallery_md5   LIMIT 0, 20# queryitems