SmartCJ Support Forum

Code: Select all

SELECT   DISTINCT(g.id), g.gallery_md5, gs.total_shows as thumb_casts, gs.total_clicks as clicks, if (gs.total_shows < 20, 1, 0) as new_thumb  FROM rot_galleries as g JOIN rot_gallery_stats as gs on gs.thumb_id = g.id  JOIN rot_gal2tag as t ON t.gallery_md5 = g.gallery_md5 WHERE g.status = 1   AND g.rgroup != 0  and g.sponsor_id NOT IN (40,38,40,38)  and t.tag_id = '22'  and (g.content_type = 2 or g.content_type = 4 ) AND g.gallery_md5 NOT IN ('bbfd95ecee5c89708883f5acb2d0dfed','f9b50c4ca50a6c713b4a9519b8b1163f','fcf07fd5b4e244a468752f97cc4011be','557ed4035720a3a254db0c345e60503c','7443fad41ad266edaa12ed0f192a82af','a580fb06947267c9b336d5e609660dc9','4a4bf180a5721c2cecdb67e0086fca01','767181cd7023dcddf31167c36d4b748f','6a53dea7001886d3805b94cfcfd7ccc6','bb6a0f381ac4d85ef729e1e1091775a1','468bfe1f14061ba48f1a2327cacc4a77','5f5e1ef75baf6d20292eca808538506a','915777b37448af48d865263eb76da8bc','98cb811654c589023ecfd7152d79cd64','9f7957a455c1c6bc1ba9bd2fa7ee116f','cec37888f0acc292e2d9580ada58bc14','e4d88f7919e189bc8962437aa3202199','c244c1600fa2fdd996b8b1b7f7b93c93','ebc139e5f9ebc718a0332ba12574e403','4c783364bbaa021c4931eed5c6356386','1cd0451c6d57491a2861ed8470d74a5c','359dbccbf0dd21a73de95398f749c448','7c3d5924d5269949ff828547f5d5327e','e6de26aa71e405ae70c428db0c515872','83ed348ba0261af9f7c355be542cfbc8','fae6916a7abe84bfd051268d0a7bddd8','07e81dd27fb6f400b5ea23ec1b187a32','3dee4491aa4cc5144feb0e443073e1eb','f6836383386e845ac18a57bfd4292e1e','644862d16939cf53b4bf408309376408','b622e91e74dd04ffe73cb41688cc3b1e','6b269f7a4976ea0d5f2efa98947ee123','8f7b5be5ea731d9544fbd7a76ea9ea10','62d024080a9de2cb66059692e5ebb0a5','0baab9f8d4c74135d2b35c21424708ec','3f742cdcc2b2e8021930c58a5636867e','a85172882f358c6c3605cd1601085789','6b636f9853811904ff96accb8ea80f71','513b9957d22799cf8fdf6fe878c820ad','162a95acb4df1247e7bed422cc17bedc','977abd041e0be46b5eda0d1f46c83ab4','d390a35ff7feabed5a617f7716c20a84','88fe26db18b89ba83eda4a4f38dffa84','ecf5d72da03c79d9a28697128bbb1faa','ad2528c36fa4f35523d0db40ea0999b0','bfaf0d739e241f18b19f26c4af5aa5b1','7b03109e212775c91a629c3471090c06','3a96ed899bb76d6ce8b4448c2dd8753d','06b1fe479a594b68a8aada84cd203081','b2701a2d7ab00070ca28d1ef9ba4944c','0d17a148735666515ebdc7d54fb9d319','5e7de6d2b5423df096f81f7f14e2683c','6ec739889c7fdab6bbd6325e13e18c67','ab191ee1b9e79e11af441db1e1e13cd8','eb21776aa33136a89b2eab5ef55f545e','62ca7100dbf5f4dbcbc53f11c1235d69','c3af01e3d832a5a040317f1a4c96d776','147081bd51f0c22c934854661d619e9e','5228022f92a2ba4ead74c1db4f39ce28','920546aafc3e95a1f0cc7362c3dc1390','62e4a3ac48e1f0d268e3841587bc3bd6','c29a4d2eafb70325aee2e1069a9f7be0','ea21a2bb9db92b8afc5ba8080d1a9b48','a5efb0b5b807ce5c5d40c0881ccaf043','c54b2fdcbfc10739babb8150937804f1','0de256eecae37b37fed62ada4943e11e','7f3fc14589d743d63f94c7110a5541b0','d01b154bc2e35c0d497e17ad78cfee23','8e1df115a480a54fc82d8985550f6f49','ef412b6a1beca466b7f96b261d9ea6bd','2340b491bd6bee9d158b53e103e6e5e4','bbe74fba4e57c515cfcddcf48b838c02','15efb7bff605b6a7b4085d50ebc0c0a4','f106144a356ccd82b7b48b7a047cfc03','edb2750863f42f34e63c54480625d358','58e4fef3166ed527588b5a929626c907','9007c2419231f333cb2889955e43e791','5967824cf6386d5bd198470c07b56138','89564919b26f99dacf717033b2c508e1','f97f11747e353e9e525ae3fd7747f9c7','27388fc0a6c6d8e7a966c8490580863e','483bbc810f9a0186033bc66382250aa5','5e0501c0d087f08ad2cf96abb3f4c97a','9397a700663b674b6ca8bee888483eac','6775b73edb3d26b287e0ee42f3326f77','80bd9736402c0bfaacf4c0a1a87c848b','6b72f81eea4810d86349995da0644c64','5ac069799c45802426b6a9aa0d66b734','9cfdc9386c253f99885f64a55de04acd','96182ab636b05c875f888571f07c99b6','a214991b9d3e44cb6e0ec0430bc5d6d4','7eec3209f4722b91ee30df559a4d9d1f','54dc854e89acdaf513115806c3a0c07b','409e2a5d6b64217b3fdb5127446c692e','443ab69397de4486d9215cef7ddbd2dd','e34403994dffbfa8e590d8920438e4cd','0f8f4e808bd1ba889e168556de935f82','ff4272c5ca070cbbff96ce1fe9f6aaaa','513392c782586526b0b44395b5a3e666','61efd4bdfc4b33bddbebeac414e6c9aa','e38998b06640803ce626acfb1cf0b4a5','7de00eba0728c3a6aaf3bbb6830620dc','645ae26ffcbca933a9f10d56afb034ea','0849da20d09eab7e29692aad23372437','91bb6948c80d2e0699a56d6f2fa9a5ec','3c8bc3ad976287dbfb9cf6809a538897','51e188e993763c30f5527f784cba70ac','9248b178c5b75df79e094a5e57ef9ad1','b50db05902742f0d385a59092af572ad','c5867a441dc51076f98cc5481cff379e','7afeec5ec75ab87b0b9e8b297ac89836','920d033c94a83d5aac5b1c17f93db34b','ff8a684687556404a7c760d5b5cb2188','df4b209847e4ffca98643d527d4b9e5a','65e5299933c91601ab2f7009c9284dca','fd2fbdbaabe818341100d38777c555a7','6892c4ec7511fef885f60fb85b002c58','42f004923ac22ab1efd14efdbadb1a4b','6681abbeba6e5cf13061666a4594fffa','9345f732e7b4acd52b20c46d9209afca')  AND gs.total_shows < 20 GROUP BY gallery_md5   LIMIT 0, 17