string(26351) "SELECT DISTINCT ranked_results.ID, ranked_results.meta_key, ranked_results.post_date, ranked_results.meta_value, ranked_results.title, ranked_results.stock, ranked_results.group_id FROM ( SELECT wp_30a7d99a36_posts.ID, author_id.meta_key, wp_30a7d99a36_posts.post_date, book_year.meta_value, books.title, books.stock, books.group_id, ROW_NUMBER() OVER ( PARTITION BY books.group_id ORDER BY CASE WHEN books.stock > 0 THEN 0 ELSE 1 END, wp_30a7d99a36_posts.post_date DESC ) as rn FROM wp_30a7d99a36_posts INNER JOIN books ON wp_30a7d99a36_posts.ID = books.id LEFT JOIN wp_30a7d99a36_postmeta author_id ON (author_id.post_id = wp_30a7d99a36_posts.ID AND author_id.meta_key LIKE 'acf_book_creators_%_acf_book_creator_id') LEFT JOIN wp_30a7d99a36_postmeta book_group_id ON (book_group_id.post_id = wp_30a7d99a36_posts.ID AND book_group_id.meta_key = 'acf_book_argo_group_id') LEFT JOIN wp_30a7d99a36_postmeta author_role ON (author_role.post_id = wp_30a7d99a36_posts.ID AND author_role.meta_key LIKE REPLACE(author_id.meta_key, 'id', 'role')) LEFT JOIN wp_30a7d99a36_postmeta book_id ON (book_id.post_id = wp_30a7d99a36_posts.ID AND book_id.meta_key = 'acf_book_argo_id') LEFT JOIN wp_30a7d99a36_postmeta book_year ON (book_year.post_id = wp_30a7d99a36_posts.ID AND book_year.meta_key = 'acf_book_year') LEFT JOIN wp_30a7d99a36_term_relationships determination ON (determination.object_id = wp_30a7d99a36_posts.ID AND determination.term_taxonomy_id = 48) LEFT JOIN wp_30a7d99a36_postmeta thumbnail_id ON (thumbnail_id.post_id = wp_30a7d99a36_posts.ID AND thumbnail_id.meta_key = '_thumbnail_id') WHERE wp_30a7d99a36_posts.post_type = 'book' AND wp_30a7d99a36_posts.post_status IN ('publish', 'future') AND author_id.meta_value = 2760 AND author_role.meta_value IN ('Autor', 'Ilustrace', 'Překlad') AND books.binding <> '' AND book_id.meta_value IN (5589,61611,62865,63204,103512,104519,106192,106294,106718,107860,108697,108812,108834,108850,108872,108953,108968,109015,109044,109072,109188,109302,109338,109555,109600,109699,109838,109923,109981,110021,110046,110227,110265,110304,110549,110551,111416,111437,111861,112803,113036,113043,113215,113582,113583,113731,113736,113751,113783,114146,114216,114625,115950,115955,115956,116116,116182,116329,116384,116438,116444,116484,116508,116515,116519,116520,116522,116523,116574,116597,116601,116626,116627,116628,117099,118131,118648,118842,119004,119005,119182,119671,119914,120097,120247,122652,124716,124743,124831,124841,124848,124869,124870,125207,125235,125236,129954,130339,131050,131160,131295,132425,132439,132669,132925,132999,133025,133354,133371,133382,133404,133700,133724,133726,133787,133965,134038,134039,134137,134206,134555,134608,134627,134682,134886,134929,134974,135065,135151,135280,135283,135286,135379,135407,135452,135461,135476,135780,135788,135853,136018,136032,136044,136047,136088,136151,136164,136198,136202,136272,136277,136306,136307,136356,136407,136573,136604,136657,136661,136855,136979,137070,137092,137100,137159,137160,137167,137183,137196,137302,137327,137386,137413,137519,137520,137765,137767,137850,137859,137860,137905,137954,138045,138046,138069,138075,138121,138141,138148,138150,138187,138215,138247,138300,138312,138320,138324,138358,138496,138611,138626,138796,138842,138928,138985,139080,139082,139150,139163,139168,139204,139220,139344,139345,139364,139489,139561,139572,139743,139888,139889,139961,140047,140048,140064,140162,140300,140307,140313,140379,140417,140564,140652,140658,140786,140930,140950,140983,140988,140991,141002,141003,141033,141120,141124,141218,141345,141558,141624,141707,141779,141841,141921,141968,142039,142082,142093,142098,142145,142505,142506,142553,142612,142613,142619,142620,142701,142749,142825,142937,143108,143112,143113,143295,143362,143411,143440,143581,143702,143707,143709,143749,143766,143818,143848,143859,143861,143864,143890,143892,143911,143914,143920,144013,144082,144110,144113,144138,144139,144175,144287,144313,144352,144429,144448,144503,144546,144596,144597,144733,144790,144851,144872,144886,144898,144946,144961,144963,145053,145055,145137,145154,145377,145477,145488,145563,145611,145653,145753,145820,145825,145893,145957,145970,146140,146293,146316,146351,146361,146454,146455,146456,146457,146459,146460,146564,146632,146701,146752,146807,146810,146812,146814,146832,146887,146901,146902,146913,147031,147069,147083,147118,147196,147197,147198,147249,147420,147434,147447,147448,147450,147515,147705,147750,147756,147759,147957,148096,148111,148152,148153,148199,148205,148386,148390,148593,148594,148681,148913,148922,149151,149320,149345,149415,149803,149805,149821,149862,149935,149970,149971,149977,150020,150051,150178,150323,150347,150428,150429,150453,150493,150516,150558,150565,150612,150690,150715,150721,150769,151052,151054,151068,151133,151225,151287,151321,151326,151360,151382,151478,151563,151616,151790,151889,151924,152009,152241,152278,152602,152666,152760,152786,152820,152829,152976,153005,153204,153297,153508,153890,154054,154183,154262,154263,154492,154597,154623,154739,154758,155170,155171,155172,155173,155174,155175,155176,155177,155178,155179,155284,155285,155316,155623,155654,155655,155665,155675,155684,155685,155713,155739,155786,155787,155863,155864,155868,155872,155874,155898,156204,156240,156241,156758,156899,157135,157439,157533,157570,157733,157802,157840,157841,157884,158062,158431,158434,158522,158747,158763,158783,158793,158807,158810,158814,158817,158873,158909,159092,159096,159212,159233,159697,159698,159762,159835,159853,160244,160264,160376,160446,160506,160590,160592,160617,160656,160749,160920,160949,161027,161028,161029,161030,161031,161032,161033,161061,161065,161133,161232,161246,161330,161377,161388,161486,161574,161683,162052,162359,162390,162645,162712,162715,162950,163015,163097,163107,163230,163243,163287,163378,163419,163448,163654,163763,163794,163953,164048,164103,164245,164256,164257,164278,164315,164348,164349,164351,164492,164503,164550,164563,164627,164664,164675,164694,164718,164762,164763,164844,164980,165174,165206,165246,165251,165253,165270,165342,165345,165419,165426,165427,165470,165559,165674,165899,166002,166062,166118,166183,166281,166345,166585,166599,166671,166697,166788,166819,166903,167006,167038,167157,167231,167369,167405,167413,167414,167415,167530,167682,168685,168691,168886,170115,170252,170254,171249,171291,171922,171932,171959,173148,173593,175479,177017,178909,179387,179686,180188,180524,181654,181657,181659,181698,181855,181941,181942,182244,182272,182326,182393,182424,182539,182559,182708,182722,182727,182943,183048,183076,183183,183205,183212,183311,183405,183415,183774,183984,183985,183997,184137,184174,184196,184198,184231,184429,184480,184501,184531,184533,184534,184561,184606,184642,184659,184660,184666,184931,184942,184980,184986,185147,185188,185288,185358,185374,185396,185556,185568,185630,185634,185635,185637,185774,185897,185952,186013,186144,186261,186262,186320,186373,186374,186375,186376,186384,186460,186465,186467,186468,186470,186471,186492,186541,186568,186570,186606,186617,186695,186797,186907,186919,186947,187025,187052,187145,187237,187238,187239,187240,187255,187328,187414,187459,187467,187575,187583,187614,187617,187663,187696,187698,187720,187741,187742,187743,187770,187877,187985,188046,188070,188224,188237,188262,188489,188644,188645,188666,188674,188723,188773,188798,188836,188969,189161,189250,189300,189390,189410,189411,189453,189455,189464,189466,189552,189557,189582,189600,189645,189659,189669,189825,189891,189937,189999,190000,190052,190092,190170,190199,190206,190226,190257,190321,190342,190379,190386,190402,190435,190497,190502,190509,190617,190684,190711,190746,190847,190891,190937,191110,191139,191165,191175,191228,191282,191440,191447,191525,191554,191567,191569,191582,191607,191795,191800,191904,191964,191965,191972,191984,191989,192000,192012,192035,192147,192149,192150,192154,192331,192412,192416,192462,192540,192541,192542,192543,192544,192561,192578,192579,192611,192683,192684,192689,192717,192724,192725,192760,192782,192786,192838,192842,192851,192882,192902,192931,193001,193018,193107,193117,193130,193156,193159,193189,193201,193202,193223,193232,193258,193264,193293,193392,193395,193398,193424,193425,193468,193483,193487,193489,193492,193499,193514,193533,193549,193557,193562,193567,193570,193575,193578,193580,193636,193638,193639,193641,193648,193657,193695,193730,193802,193836,193846,193849,193855,193901,193909,193912,193915,193938,193970,193982,194063,194121,194202,194214,194270,194289,194320,194324,194343,194390,194393,194435,194459,194491,194504,194528,194529,194571,194622,194640,194716,194722,194743,194750,194863,194895,194902,194909,194912,194920,194936,194941,194979,195065,195072,195099,195244,195321,195326,195373,195404,195406,195419,195453,195554,195562,195655,195707,195735,195736,195744,195775,195777,195778,195780,195818,195819,195938,195985,195990,196019,196041,196045,196048,196142,196171,196172,196201,196217,196219,196233,196274,196303,196369,196376,196377,196378,196381,196384,196386,196411,196413,196458,196459,196459,196473,196494,196518,196648,196655,196660,196685,196725,196736,196788,196805,196811,196815,196817,196850,196901,196934,196981,196982,196993,197064,197107,197125,197195,197237,197345,197365,197408,197577,197660,197670,197674,197676,197687,197711,197765,197776,197797,197803,197832,197865,197876,197974,198014,198024,198026,198029,198030,198032,198065,198067,198073,198086,198106,198109,198126,198131,198216,198234,198313,198319,198324,198325,198335,198370,198374,198376,198406,198443,198448,198450,198506,198555,198566,198585,198638,198770,198814,198821,198831,198860,198885,198893,198955,199014,199047,199061,199083,199168,199181,199183,199197,199207,199261,199267,199279,199489,199493,199506,199530,199560,199594,199599,199641,199729,199730,199732,199740,199747,199752,199774,199862,199921,199943,200000,200057,200065,200081,200137,200187,200235,200293,200445,200471,200543,200648,200680,200711,200730,200851,200922,200935,200962,200967,201022,201057,201059,201070,201111,201124,201178,201189,201218,201228,201231,201300,201346,201402,201498,201507,201510,201541,201689,201741,201744,201790,201798,201821,201851,201861,201875,201879,201886,201993,201995,202030,202030,202038,202051,202156,202222,202322,202341,202375,202407,202415,202416,202428,202431,202433,202482,202483,202507,202526,202544,202573,202711,202782,202854,202858,202907,202919,203099,203100,203123,203149,203150,203150,203219,203238,203401,203460,203464,203557,203585,203697,203700,203701,203703,203704,203707,203716,203802,203940,203972,204004,204120,204218,204302,204308,204322,204465,204583,204586,204613,204629,204638,204676,204700,204701,204704,204706,204708,204732,204737,204747,204748,204750,204755,204759,204760,204763,204804,204823,204824,204830,204833,204836,204838,204839,204842,204845,204848,204850,204853,204858,204946,204952,204968,204992,204992,205007,205028,205032,205033,205037,205051,205068,205195,205242,205243,205244,205284,205314,205338,205359,205538,205543,205559,205567,205568,205570,205573,205574,205587,205656,205662,205687,205750,205776,205798,205843,205888,205934,205941,205957,205990,206030,206033,206034,206067,206113,206258,206295,206302,206326,206334,206351,206422,206442,206496,206511,206545,206582,206586,206591,206591,206641,206739,206742,206796,206814,206819,206857,206880,206884,206906,206942,207008,207040,207095,207099,207141,207142,207150,207158,207160,207163,207164,207167,207170,207172,207173,207211,207212,207288,207384,207394,207403,207407,207434,207439,207506,207552,207613,207693,207701,207787,207789,207868,207876,208077,208087,208122,208131,208218,208252,208258,208278,208308,208338,208409,208443,208459,208527,208560,208566,208567,208647,208651,208667,208722,208742,208827,208860,208973,209060,209062,209068,209137,209189,209192,209355,209372,209387,209438,209563,209673,209692,209728,209760,209763,209766,209767,209773,209782,209891,209971,210022,210030,210031,210036,210142,210146,210194,210244,210321,210405,210409,210421,210463,210507,210655,210682,210701,210732,210793,210909,210911,210949,210988,210992,210999,211109,211170,211214,211298,211361,211373,211375,211406,211460,211460,211464,211474,211633,211690,211703,211776,211788,211827,211833,211834,211863,211879,211932,212071,212138,212171,212177,212182,212197,212209,212229,212260,212262,212291,212306,212335,212351,212354,212458,212482,212517,212522,212621,212644,212652,212663,212673,212777,212807,212839,212842,212974,212990,213072,213089,213098,213113,213169,213201,213242,213280,213284,213287,213324,213458,213496,213558,213560,213599,213600,213642,213650,213679,213713,213727,213761,213769,213810,213835,213847,213855,213859,213923,213944,213951,213972,213986,214006,214101,214199,214314,214325,214328,214410,214428,214450,214466,214467,214470,214516,214527,214541,214546,214602,214643,214692,214705,214805,214827,214838,214840,214844,214883,214929,214982,214989,214999,215024,215042,215053,215087,215092,215118,215176,215195,215212,215238,215247,215272,215300,215329,215356,215357,215359,215360,215367,215370,215411,215422,215454,215512,215514,215613,215618,215623,215665,215668,215696,215721,215743,215743,215847,215872,216075,216122,216123,216124,216125,216127,216230,216267,216338,216344,216347,216373,216394,216405,216454,216515,216548,216561,216592,216599,216600,216638,216653,216680,216698,216784,216853,216855,216856,216857,216858,216864,216873,216874,216895,216907,216919,216951,216975,217029,217124,217177,217217,217219,217318,217321,217399,217401,217438,217491,217592,217713,217727,217736,217775,217836,217866,217972,218081,218222,218239,218311,218318,218318,218341,218341,218344,218403,218454,218463,218465,218468,218469,218472,218475,218477,218478,218522,218581,218625,218687,218743,218749,218750,218751,218752,218753,218846,218897,218905,218935,219035,219036,219052,219079,219153,219170,219343,219367,219372,219398,219434,219487,219510,219617,219632,219639,219641,219642,219645,219648,219649,219676,219677,219685,219724,219826,219827,219828,219829,219830,219841,219882,219890,219913,219939,219998,220019,220020,220088,220118,220155,220260,220263,220336,220344,220348,220352,220359,220361,220363,220366,220368,220370,220372,220374,220375,220377,220416,220446,220451,220459,220467,220468,220479,220487,220513,220555,220590,220600,220657,220658,220672,220673,220730,220733,220734,220740,220768,220833,220848,220859,220864,220877,220888,220994,221025,221045,221087,221088,221124,221124,221135,221151,221191,221215,221255,221289,221408,221446,221448,221450,221488,221523,221598,221624,221629,221718,221757,221765,221809,221917,221929,221983,221986,221995,222014,222015,222126,222140,222202,222203,222291,222316,222390,222407,222450,222534,222564,222633,222671,222780,222796,223520,223533,223548,223561,223606,223665,223717,223730,223794,223804,223858,223983,224013,224029,224055,224257,224484,224497,224504,224675,224724,224795,224796,224841,224845,224846,224847,224929,225052,225215,225296,225297,225306,225333,225340,225347,225353,225354,225394,225408,225436,225439,225461,225513,225517,225536,225539,225634,225697,225724,225764,225771,225786,225936,225941,225949,226001,226003,226035,226147,226172,226217,226258,226271,226287,226301,226321,226378,226440,226515,226550,226551,226557,226560,226802,226895,226936,226938,227481,227925,227967,227969,228008,228009,228018,228029,228266,228287,228297,228342,228354,228359,228450,228469,228544,228558,228765,228815,228849,228862,228889,228891,228892,228893,228908,229101,229121,229377,229424,229571,229581,229676,229904,229981,230033,230048,230271,230284,230309,230312,230471,230475,230579,230580,230590,230792,230919,230993,231152,231204,231315,231351,231605,231670,231729,231739,231783,231827,231933,231935,232008,232024,232043,232044,232060,232069,232084,232101,232192,232294,232332,232345,232355,232504,232556,232572,232773,232782,232918,232987,232990,232991,232992,232994,232995,232996,232997,233003,233208,233246,233320,233335,233336,233386,233392,233457,233476,233498,233526,233559,233699,233714,233715,233761,233863,234046,234279,234318,234319,234419,234543,234902,234905,234907,235079,235085,235165,235192,235226,235389,235535,235655,235657,235741,235750,235752,235753,235876,236153,236213,236309,236391,236597,236716,236954,236959,237081,237206,237215,237225,237350,237354,237909,238122,238124,238155,238186,238227,238233,238235,238237,238238,238239,238246,238265,238269,238271,238340,238366,238377,238408,238412,238488,238588,238597,238612,238776,239017,239222,239252,239464,239510,239520,239550,239767,239808,239839,239844,239850,239857,239891,239901,239956,239970,239999,240027,240060,240136,240141,240143,240144,240146,240195,240211,240231,240264,240389,240512,240570,240673,240713,240784,240792,241075,241076,241096,241117,241295,241302,241325,241437,241458,241460,241492,242303,242330,242362,242555,242556,242567,242748,242907,242972,243068,243075,243076,243117,243226,243362,243372,243524,243588,243659,243692,243730,243784,243785,243840,243875,243890,243891,243892,243893,243894,243895,243896,243897,243944,243950,244005,244035,244040,244185,244318,244406,244430,244456,244468,244508,244523,244570,244571,244598,244646,244650,244651,244653,244679,244685,244737,244738,244792,244974,245201,245456,245586,245643,245683,245710,245813,245815,245828,245847,245862,245865,245873,245874,245907,245941,245944,245991,246001,246015,246021,246029,246059,246150,246325,246355,246356,246358,246359,246360,246386,246391,246517,246549,246549,246562,246567,247160,247253,247385,247386,247531,247713,247793,247814,247924,247981,247995,248235,248240,248261,248570,248585,248588,248599,248621,248639,248648,248750,248908,248994,249032,249037,249139,249140,249182,249188,249193,249221,249223,249271,249354,249470,249484,249507,249519,249555,249591,249642,249690,249733,249766,249767,249809,249812,249813,249814,249815,249816,249817,249819,249891,249892,249986,250048,250262,250284,250287,250362,250371,250420,250422,250459,250461,250538,250595,250605,250611,250708,250714,250725,250739,250792,250940,250941,250954,251045,251052,251059,251065,251085,251170,251184,251327,251342,251431,251432,251433,251436,251437,251477,251479,251593,251710,251747,251749,251752,251753,251766,251779,251808,251860,251882,251913,251949,251994,252044,252071,252279,252281,252282,252353,252464,252484,252634,252854,252885,252894,252968,253025,253029,253076,253183,253189,253201,253202,253212,253222,253297,253329,253368,253403,253413,253441,253444,253451,253540,253580,253580,253620,253681,253684,253726,253777,253803,253838,253839,253866,253867,253916,253928,253958,253959,253973,253986,254012,254014,254016,254113,254125,254127,254292,254348,254350,254352,254353,254355,254356,254359,254361,254414,254425,254446,254468,254517,254534,254536,254571,254724,254735,254923,254970,254976,255085,255138,255164,255175,255183,255185,255199,255202,255307,255308,255311,255317,255320,255358,255472,255606,255666,255676,255705,256021,256024,256036,256037,256038,256042,256045,256059,256075,256080,256170,256259,256370,256538,256692,256720,256756,256777,256779,256973,256979,256995,257057,257114,257402,257473,257482,257489,257543,257569,257722,257789,257998,258215,258332,258400,258438,258565,258567,258568,258586,258633,258651,258653,258682,258683,258684,258726,258726,258783,258829,258868,259017,259101,259153,259174,259193,259201,259396,259505,259506,259560,259671,259676,259698,259770,259794,259800,259859,259907,259918,259930,260007,260013,260015,260058,260069,260072,260073,260118,260151,260153,260243,260442,260481,260483,260487,260553,260557,260728,260732,260815,260899,261017,261033,261044,261060,261188,261266,261269,261291,261329,261342,261405,261408,261460,261523,261532,261534,261550,261552,261643,261877,261952,261987,262217,262493,262497,262572,262584,262587,262602,262620,262750,263319,263457,263541,263554,263570,263788,263866,263874,263909,263991,264193,264262,264313,264318,264332,264333,264396,264399,264400,264401,264484,264500,264567,264693,264694,264695,264696,264734,264737,264739,264776,264779,264867,264876,264902,264967,265052,265217,265318,265352,265471,265639,265643,265759,265809,265820,265864,265929,265943,266000,266001,266002,266010,266049,266062,266063,266065,266145,266196,266279,266307,266308,266309,266310,266348,266406,266466,266490,266587,266619,266677,266735,266869,266905,266954,266956,266960,267043,267052,267095,267103,267118,267149,267165,267257,267356,267402,267451,267481,267529,267534,267548,267556,267605,267607,267622,267647,267957,267959,268009,268037,268069,268270,268288,268344,268428,268486,268510,268589,268602,268603,268667,268678,268679,268680,268762,268792,268864,268876,268908,269007,269048,269291,269433,269554,269843,269940,270013,270020,270021,270026,270142,270156,270361,270363,270995,271218,271297,271393,271481,271567,271804,271944,272014,272025,272085,272088,272118,272245,272247,272249,272289,272459,272692,272724,272858,272878,272936,273079,273082,273084,273102,273137,273156,273281,273313,273362,273364,273367,273398,273439,273521,273771,273771,273874,273874,273950,273958,274084,274121,274386,274730,274744,274745,274829,274864,274897,275102,275220,275238,275425,275507,275656,275683,275692,275693,275703,275733,275929,276010,276052,276154,276161,276349,276414,276477,276561,276597,276653,276770,276826,276980,277077,277175,277207,277275,277446,277470,277561,277572,277649,277736,277796,277813,277853,277933,278386,278390,278395,278396,278448,278465,278485,278506,278507,278508,278528,278587,278635,278705,278705,279242,279267,279375,279407,279458,279617,279658,279734,279734,279775,279811,279884,280062,280164,280199,280253,280403,280413,280623,280623,280666,280738,280785,280791,280922,280950,280959,280988,281071,281083,281084,281096,281157,281158,281203,281386,281400,281457,281460,281467,281489,281555,281766,281804,281805,281811,281896,281903,281949,281951,281954,281962,281962,282011,282013,282014,282015,282017,282074,282075,282189,282325,282612,282795,282827,282900,282901,282950,283078,283190,283200,283205,283269,283305,283338,283439,283448,283457,283603,283706,283773,283843,283964,284032,284033,284053,284088,284131,284158,284159,284159,284295,284330,284464,284515,284538,284539,284551,284552,284751,284776,284799,284801,284905,284919,285050,285051,285054,285098,285099,285115,285117,285269,285270,285272,285273,285277,285293,285294,285295,285297,285358,285385,285462,285464,285573,285601,285636,285670,285673,285699,285777,285939,285958,285965,285973,285976,286010,286143,286309,286336,286357,286514,286592,286594,286611,286725,286767,286799,286800,286853,286877,286966,286975,286978,287019,287022,287296,287363,287671,287697,287731,287744,287800,287980,288066,288085,288093,288094,288095,288096,288097,288225,288227,288228,288317,288690,288698,288701,288818,288823,288832,288848,288947,288949,288950,288990,289054,289055,289407,289435,289443,289447,289447,289461,289536,289537,289626,289633,289644,289679,289735,289878,289892,289895,289897,289988,290016,290021,290152,290267,290419,290714,290736,290763,290869,291135,291173,291357,291411,291412,291522,291882,291888,291919,292044,292056,292532,292537,292573,292678,292720,292841,292849,292851,292855,292857,292858,293012,293019,293033,293034,293223,293271,293330,293360,293449,293605,293606,294322,294326,294327,294351,294352,294354,294377,294418,294495,294501,294613,294629,294632,294712,294752,294824,294825,294870,294877,294916,294933,295023,295028,295047,295110,295112,295116,295149,295150,295151,295152,295153,295305,295784,295803,296577,296822,297370,297898,297901,298439,298495,298831,500073,500165,500376,500765,501583,501888,501916,502246,502856,503205,503210,504156,504270,504271,504308,504882,505442,506155,507121,507704,508278,508279,508444,508665,508671,508691,509065,509097,509260,509280,509338,509611,509618,510310,510496,510804,511328,511422,511682,512442,513466,513469,513471,513473,513474,513593,513660,513821,513823,513890,513913,513924,514904,516065,516287,516907,517115,517177,517480,518655,518700,519253,519350,519408,520509,521209,522020,522232,522296,522623,522776,523190,523394,523428,524159,524803,525433,525434,525631,525926,527887,527986,529068,529640,529836,530125,530564,531081,531223,531247,531892,532462,532463,532465,532740,532977,533030,533168,533992,534104,534108,534391,534442,534819,534858,534863,534908,535136,536614,536711,536713,536874,537165,537237,537500,537611,537988,538390,538393,538504,538743,539358,539403,539416,540856,541063,541510,541514,541516,541892,542126,542127,543255,543385,543390,543561,543962,544249,544273,544445,544507,544550,544555,544589,544596,544597,544604,544608,544619,544735,544737,544926,545456,545826,545857,546780,546980,547428,547436,548338,548468,548515,548920,549065,549784,551286,552566,552627,552910,554921,554957,557132,557134,557842,558274,558365,558964,559043,559182,559471,560788,181935,203133,203153,205181,205199,206915,206916,207198,207244,207715,208596,209246,209574,209590,209637,209671,209684,211103,211907,212467,212614,213399,213521,214099,214346,214348,214651,214769,215164,215303,215484,217967,220293,222313,226154,229334,236732,238154,245558,246052,260713,261177,270114,271337,272076,272444,275224,275225,275578,280730,281835,288130,294184,294848,298476,502076,508708,553136,165760,167232,196385,196551,196589,196824,198881,201612,202358,202381,202662,202712,202835,203266,203878,204361,204803,205255,205491,205866,205887,205924,206197,206322,208123,208183,208868,210015,210143,210434,210525,210526,210527,210557,212811,213088,213159,213781,213962,213997,214376,214598,214886,215160,215165,215684,216560,216819,218985,220245,220246,220701,222302,226406,231024,237283,241338,243275,248904,254537,268473,273388,286147,286612,286624,287393,292324,535703,536859,546399,190802,196208,196372,201743,202566,202567,203131,203209,203941,204489,204535,205408,205489,205922,208710,209582,210985,211089,211176,211580,212627,213506,213797,214005,216292,275497,504227,553941,204005,205201,206206,212015,263726,295607,548918,200968,203960,277493,144966,182370,225780) ) ranked_results WHERE ranked_results.rn = 1 ORDER BY ranked_results.post_date DESC"