SELECT * FROM indexTop WHERE 1 AND ( ((book = '01' OR book = '02') AND eventId IN ('78601','605621','33870988','33871019','33876258','33876609','33884745','33885054','33885057','33885067','33885068','33885070','33886480','33886486','33886494','33886497','33886499','33887604','33892686','33892687','33892690','33892695','33892698','33892703','33892773','33892774','33892783','33892787','33892788','33892789','33892790','33892793','33892794','33892795','33892796','33892797','33892801','33892804','33892805','33892806','33892807','33892808','33892809','33892810','33892812','33892813','33892819','33892821','33892836','33892837','33892838','33892840','33892841','33892843','33892846','33892847','33892848','33892849','33892850','33892852','33897403','33897413','33899484','33900091','33903620','33903630','33903633','33905195','50850329','51093611','51093613','51093615','51093617','51093619','51093623','51093625','51093627','51093629','51093633','51095929','51095933','51095937','51095941','51095945','51095951','51095955','51095959','51095963','51095967','51095971','51095975','51099283','51099285','51099287','51099289','51099291','51099293','51099295','51099297','51099299','51099301','51099303','51099305','51115815','51115817','51115819','51115821','51115823','51115825','51448059','51448061','51448067','51448069','51448071','51448073','51448075','51448079','51448081','51448549','51449205','51449207','51449209','51449211','51449215','51449217','51449219','51449221','51449223','51449225','51449227','52130559','52130561')) OR ( book = '03' AND eventId IN ('166426721','166426722','166428293','166428294','166435008','166435010','166435011','166435012','166589384','166589385','166589390','166589392','166589393','166589394','166589398','166589399','166589404','166589405','166589411','166589412','166589420','166589421','166589423','166589424','166589425','166589426','166589428','166589429','166589430','166589431','166589432','166589434','166589483','166589484','166589485','166589486','166589487','166589488','166589489','166589490','166589491','166589492','166589493','166589494','166589495','166589496','166589497','166589498','166589503','166589504','166589505','166589506','166589508','166589509','166589510','166589511','166589555','166589556','166589559','166589560','166589563','166589564','166589567','166589568','166589571','166589573','166589575','166589577','166589583','166589584','166589590','166589592','166589596','166589597','166589599','166589600','166589601','166589602','166589604','166589605','166604803','166604805','166604828','166604829','166794810','166794811','166794812','166794813','166795014','166795015','166795017','166795018','166795023','166795024','166795025','166795026','166795030','166795031','166795035','166795036','166795589','166795590','166795591','166795593','166795596','166795597','167252779','167252784','167493140','167493141','167493143','167493144','167493149','167493150','167554758')) OR ( book = '04' AND eventId IN ('100918','100919','100922','100934','100935','100936','100942','100948','100949','100950','100954','100983','1400787','1500788','1500790','1500792','1500794','1500795','1502548','5401360','5401366','6007982','6007985','6007990','6800993','6800995','6800996','6800997','6801000','6801001','7907857','8600282','9304561','9304562','9311271','10900915','10900923','10900924','10900927','10900930','10900932','10900933','10900939','10900944','10900951','10900952','10900979','11000956','11000958','11000959','11000960','11000961','11000962','11000969','11000971','11000972','11000973','11000975','11000978','12101567','12101568','16002725','16002728','16002731','16002732','16007715','20304519')) OR ( book = '05' AND eventId IN ('108898513','112998235','112998236','116646258','116646643','117150957','117193985','117194185','117194190','117194204','117194225','117277586','117277590','117277598','117277599','117277653','117341497','117482226','117482228','117482229','117482234','117482235','117482236','117486123','117486124','117486128','117486129','117486130','117486131','117486132','117486136','117486138','117486139','117486150','117486182','117486184','117486185','117486196','117486215','117486220','117486222','117486230','117486255','117486256','117486278','117486298','117487004','117488639','117488643','117488651','117489015','117489016','117489021','117489023','117489030','117489032','117489101','117489102','117489205','117558992','117558994','117558995','117558996','117558997','117558998','117558999','117559000','117559001','117559002','117559003','117559004','117559005','117559006','117559007','117559008','117559009','117559010','117559011','117559012','117559013','117559014','117559015','117559016','117559017','117559018','117559019','117559020','117559021','117559022','117559023','117559024','117559025','117559026','117559027','117559028','117559029','117559030','117559031','117559032','117559033','117559034','117559035','117559036','117559037','117614229','117615091','117709160','117753034','117774377','117774378','117774379','117774380','117774381','117774382','117774383','117774384','117774385','117774386','117774387','117774389','117774390','117774391','117774392','117774393','117774394','117774395','117774396','117774397','117774398','117774399','117774400','117774401','117774402','117774403','117774404','117774405','117774406','117774407','117774408','117774409','117774410','117774411','117774412','117774413','117774414','117774415','117774416','117774417','117774418','117774419','117774420','117774421','117774422','117774423','117774424','117774425','117774426','117774427','117774428','117774429','117774430','117774431','117774432','117774485','117774486','117774487','117774488','117774489','117774490','117774491','117774493','117774494','117774495','117774496','117774497','117774498','117774499','117774500','117774501','117774502','117774503','117774504','117774505','117774506','117774507','117774508','117774509','117774510','117774511','117774512','117774513','117774514','117774515','117774516','117774517','117774518','117774519','117774520','117774521','117774522','117774523','117774524','117774525','117774526','117774527','117774756','117774757','117774758','117774759','117774760','117774761','117774762','117774763','117774764','117774765','117774766','117774767','117774769','117774770','117774771','117774772','117774773','117774774','117774775','117774776','117774777','117774778','117774779','117774780','117774781','117774782','117774783','117774784','117774785','117774786','117774787','117774788','117774789','117774790','117774791','117774792','117774793','117774794','117774795','117774796','117774797','117774798','117774799','117774800','117774801','117774802','117774803','117774804','117774805','117774806','117774807','117774808','117774809','117774936','117774937','117774938','117774939','117774940','117774941','117774943','117774944','117774945','117774946','117774947','117774948','117774949','117774950','117774951','117774952','117774953','117774954','117774955','117774956','117774957','117774958','117774959','117774960','117774961','117774962','117774963','117774964','117774965','117774966','117774967','117774968','117774969','117774970','117774971','117774972','117774973','117774974','117774975','117774976','117774977','117774978','117774979','117774980','117774981','117774982','117774983','117774984','117774985','117774986','117774987','117774988','117774989','117774990','117774991','117775061','117775062','117775063','117775064','117775065','117775066','117775067','117775068','117775069','117775070','117775071','117775072','117775073','117775074','117775075','117775076','117775078','117775079','117775080','117775081','117775082','117775083','117775084','117775085','117775086','117775087','117775088','117775089','117775090','117775091','117775092','117775093','117775094','117775095','117775096','117775097','117775098','117775099','117775100','117775101','117775102','117775103','117775104','117775105','117775106','117775107','117775108','117775109','117775110','117775111','117775245','117775246','117775247','117775248','117775249','117775250','117775251','117775252','117775253','117775254','117775255','117775256','117775257','117775258','117775260','117775261','117775262','117775263','117775264','117775265','117775266','117775267','117775268','117775269','117775270','117775271','117775272','117775273','117775274','117775275','117775276','117775277','117775278','117775279','117775280','117775281','117775282','117775283','117775284','117775285','117775286','117775287','117775288','117775289','117775290','117775291','117775292','117775293','117775382','117775383','117775384','117775385','117775386','117775387','117775388','117775389','117775390','117775392','117775393','117775394','117775395','117775396','117775397','117775398','117775399','117775400','117775401','117775402','117775403','117775404','117775405','117775406','117775407','117775408','117775409','117775410','117775411','117775412','117775413','117775414','117775415','117775416','117775417','117775418','117775419','117775420','117775421','117775422','117775423','117775424','117775425','117775426','117775427','117775428','117775429','117775430','117775431','117775432','117775433','117775434','117775435','117775436','117775437','117775499','117775500','117775501','117775502','117775503','117775504','117775505','117775506','117775507','117775508','117775510','117775511','117775512','117775513','117775514','117775515','117775516','117775517','117775518','117775519','117775520','117775521','117775522','117775523','117775524','117775525','117775526','117775527','117775528','117775529','117775530','117775531','117775532','117775533','117775534','117775535','117775536','117775537','117775538','117775539','117775540','117775541','117775542','117775543','117775544','117775545','117775546','117775547','117775548','117775549','117775550','117775551','117775552','117775592','117775593','117775594','117775595','117775596','117775597','117775598','117775599','117775600','117775601','117775602','117775604','117775605','117775606','117775607','117775608','117775609','117775610','117775611','117775612','117775613','117775614','117775615','117775616','117775617','117775618','117775619','117775620','117775621','117775622','117775623','117775624','117775625','117775626','117775627','117775628','117775629','117775630','117775631','117775632','117775633','117775634','117775635','117775636','117775637','117775638','117775639','117775640','117775641','117775642','117775643','117775770','117775771','117775772','117775773','117775774','117775775','117775776','117775777','117775778','117775779','117775780','117775782','117775783','117775784','117775785','117775786','117775787','117775788','117775789','117775790','117775791','117775792','117775793','117775794','117775795','117775796','117775797','117775798','117775799','117775800','117775801','117775802','117775803','117775804','117775805','117775806','117775807','117775808','117775809','117775810','117775811','117775812','117775813','117775814','117775815','117775816','117775834','117775835','117775836','117775837','117775838','117775839','117775840','117775841','117775842','117775843','117775844','117775846','117775847','117775848','117775849','117775850','117775851','117775852','117775853','117775854','117775855','117775856','117775857','117775858','117775859','117775860','117775861','117775862','117775863','117775864','117775865','117775866','117775867','117775868','117775869','117775870','117775871','117775872','117775873','117775874','117775875','117775876','117775877','117775878','117775879','117775880','117775881','117775882','117775883','117775884','117775885','117775886','117775921','117775922','117775923','117775924','117775925','117775926','117775927','117775928','117775929','117775930','117775932','117775933','117775934','117775935','117775936','117775937','117775938','117775939','117775940','117775941','117775942','117775943','117775944','117775945','117775946','117775947','117775948','117775949','117775950','117775951','117775952','117775953','117775954','117775955','117775956','117775957','117775958','117775959','117775960','117775961','117775962','117775963','117775964','117775965','117775966','117775967','117775968','117775969','117775970','117775971','117775972','117775973','117776153','117776154','117776155','117776156','117776157','117776158','117776159','117776160','117776161','117776162','117776163','117776164','117776165','117776167','117776168','117776169','117776170','117776171','117776172','117776173','117776174','117776175','117776176','117776177','117776178','117776179','117776180','117776181','117776182','117776183','117776184','117776185','117776186','117776187','117776188','117776189','117776190','117776191','117776192','117776193','117776194','117776195','117776196','117776197','117794495','117794496','117794497','117794498','117794499','117794500','117794502','117794503','117794504','117794505','117794506','117794507','117794508','117794509','117794510','117794511','117794512','117794513','117794514','117794515','117794516','117794517','117794518','117794519','117794520','117794521','117794522','117794523','117794524','117794525','117794526','117794527','117794528','117794529','117794530','117794531','117794532','117794533','117794534','117794535','117794536','117794537','117794538','117794539','117794540','117794541','117794542','117794543','117794795','117794796','117794797','117794798','117794799','117794800','117794801','117794802','117794803','117794804','117794805','117794806','117794807','117794808','117794809','117794810','117794811','117794812','117794813','117794814','117794815','117794816','117794817','117794818','117794819','117794820','117794821','117794822','117794823','117794824','117794825','117794826','117794827','117794828','117794829','117794830','117794831','117794832','117794833','117794834','117794835','117794836','117794837','117794838','117794839','117794971','117794972','117794973','117794974','117794975','117794976','117794977','117794978','117794979','117794980','117794981','117794983','117794984','117794985','117794986','117794987','117794988','117794989','117794990','117794991','117794992','117794993','117794994','117794995','117794996','117794997','117794998','117794999','117795000','117795001','117795002','117795003','117795004','117795005','117795006','117795007','117795008','117795009','117795010','117795011','117795012','117795013','117795014','117795015','117795016','117795017','117795018','117795019','117795020','117795021','117795022','117795023','117795024','117795025','117795026','117900037','117900038','117900039','117900040','117900041','117900042','117900043','117900044','117900045','117900046','117900047','117900049','117900050','117900051','117900052','117900053','117900054','117900055','117900056','117900057','117900058','117900059','117900060','117900061','117900062','117900063','117900064','117900065','117900066','117900067','117900068','117900069','117900070','117900071','117900072','117900073','117900074','117900075','117900076','117900077','117900078','117900079','117900080','117900081','117900082','117900083','117900084','117900085','117900086','117900087','117900088','117900089','117900090','117900091','117903523','117903524','117903539','117923419','117923553','117931335','117931346','117931363','117931456','117955220','117955221','118000874','118004937')) OR ( book = '07' AND eventId IN ('50955627','50956591','50956595','50956597','50956601','50956605','51388997','51389005','51472113','51472119','51967067','56187691','56294339','56294345','56294351')) OR ( book = '08' AND eventId IN ('12127329','12127330','12344127','12365173','12377025','12377026','12377030','12377031','12377034','12377039','12382232','12383767','12383768','12383772','12383773','12383775','12383776','12383777','12383780','12383781','12383815','12383816','12384619','12386848','12386991','12387085','12387182','12387275','12387317','12387487','12387612','12387718','12387771','12387795','12387984','12388099','12388828','12388831','12388835','12388836','12388854','12388855','12388860','12388912','12388913','12388917','12388918','12388921','12390752','12393930','12393973','12393974','12395792','12395793','12395794','12395795','12396083','12396084','12398129','12398130','12398746','12398748','12403886','12404555','12404557','12407042')) OR ( book = '10' AND eventId IN ('1021042856','1021067635','1021067993','1021067995','1021068006','1021068014','1021068018','1021096666','1021096667','1021096668','1021096669','1021096670','1021096671','1021096673','1021096674','1021097122','1021097124','1021097125','1021097126','1021097156','1021097157','1021097158','1021097159','1021097160','1021097161','1021097162','1021097163','1021097164','1021097165','1021097166','1021097664','1021098045','1021098046','1021098047','1021098048','1021098049','1021098050','1021098051','1021098052','1021098053','1021098054','1021098055','1021098056','1021103720','1021103724','1021103727','1021103730','1021103734','1021103737','1021176448','1021176470','1021202260','1021202261','1021317727','1021350211','1021350212','1021350219','1021350221','1021464657','1021807574','1021817255','1022022839','1022269256','1022298577','1022298579','1022298585')) ) AND mapped = 1 ORDER BY blabAbsPerc DESC LIMIT 30,10 ;