pdup-slow.sql

http://pdup.allplayers.com/g/group-86938/node/86938/edit

this took 26 seconds:


/* admin : execute */ SELECT DISTINCT node.nid AS nid, node.title AS node_title, og.og_description AS og_og_description, users.name AS users_name, users.uid AS users_uid, (SELECT COUNT(*) FROM og_uid ou INNER JOIN users u ON ou.uid = u.uid WHERE ou.nid = og.nid AND u.status > 0 AND ou.is_active >= 1 AND ou.is_admin >= 0 ) AS member_count, node_data_field_nodeorder.field_nodeorder_value AS node_data_field_nodeorder_field_nodeorder_value, node.type AS node_type, node.vid AS node_vid, node_data_field_group.field_group_nid AS node_data_field_group_field_group_nid FROM node node LEFT JOIN og og ON node.nid = og.nid INNER JOIN users users ON node.uid = users.uid LEFT JOIN content_field_nodeorder node_data_field_nodeorder ON node.vid = node_data_field_nodeorder.vid LEFT JOIN content_field_group node_data_field_group ON node.vid = node_data_field_group.vid WHERE (node.status <> 0) AND (node.type IN ('group','association','league','team')) AND (node.type in ('group')) AND (node.nid IN (109538, 109548, 109558, 109568, 109578, 109588, 109598, 109608, 109618, 109918, 109928, 109938, 109948, 109958, 109978, 110328, 110338, 110458, 110468, 110498, 110508, 110518, 110528, 110768, 110808, 86818, 86828, 86838, 86848, 86858, 86868, 86878, 86888, 86898, 86908, 86918, 86928, 86938, 86948, 86958, 86968, 86978, 86988, 86998, 87008, 87018, 87028, 87038, 87048, 87058, 87068, 87078, 87088, 87098, 87108, 87118, 87128, 87138, 87148, 87158, 87168, 87178, 87188, 87198, 87968, 88518, 88528, 88538, 88558, 88568, 88578, 88588, 88598, 88608, 88628, 88638, 88658, 88678, 88688, 88698, 88708, 88718, 88738, 88748, 88758, 88768, 88788, 88808, 88818, 88828, 88838, 88848, 88858, 88868, 88878, 88888, 88898, 88908, 88918, 88928, 88938, 88948, 88958, 88968, 88978, 88988, 88998, 89008, 89018, 89028, 89038, 89048, 89058, 89068, 89078, 89088, 89098, 89108, 89118, 89128, 89138, 89148, 89158, 89168, 89178, 89188, 89198, 89208, 89218, 89228, 89238, 89248, 89258, 89268, 89278, 89288, 89298, 89308, 89318, 89328, 89338, 89348, 89358, 89368, 89378, 89388, 89398, 89408, 89418, 89428, 89438, 89448, 89458, 89468, 89478, 89488, 89498, 89508, 89518, 89528, 89538, 89548, 89558, 89568, 89578, 89588, 89598, 89608, 89618, 89628, 89638, 89648, 89658, 89668, 89678, 89688, 89698, 89708, 89718, 89728, 89738, 89748, 89758, 89768, 89778, 89788, 89798, 89808, 89818, 89828, 89838, 89848, 89858, 89868, 89878, 89888, 89898, 89908, 89918, 89928, 89938, 89948, 89958, 89968, 89978, 89988, 89998, 90008, 90018, 90028, 90038, 90048, 90058, 90068, 90078, 90088, 90098, 90108, 90118, 90128, 90138, 90148, 90158, 90168, 90178, 90188, 90198, 90208, 90218, 90228, 90238, 90248, 90258, 90268, 90278, 90288, 90298, 90308, 90318, 90328, 90338, 90348, 90358, 90368, 90378, 90388, 90398, 90408, 90418, 90428, 90438, 90448, 90458, 90468, 90478, 90488, 90498, 90508, 90518, 90528, 90538, 90548, 90558, 90568, 90578, 90588, 90598, 90608, 90618, 90628, 90638, 90648, 90658, 90668, 90678, 90688, 90698, 90708, 90718, 90728, 90738, 90748, 90758, 90768, 90778, 90788, 90798, 90808, 90818, 90828, 90838, 90848, 90858, 90868, 90878, 90888, 90898, 90918, 90928, 90948, 90958, 90968, 90978, 90988, 90998, 91008, 91018, 91028, 91038, 91048, 91058, 91068, 91078, 91088, 91098, 91108, 91118, 91128, 91138, 91148, 91158, 91168, 91178, 91188, 91198, 91208, 91218, 91228, 91238, 91248, 91258, 91268, 91278, 91288, 91298, 91308, 91318, 91328, 91338, 91348, 91358, 91368, 91378, 91388, 91398, 91408, 91418, 91428, 91438, 91448, 91458, 91468, 91478, 91488, 91498, 91508, 91518, 91528, 91538, 91548, 91558, 91568, 91578, 91588, 91598, 91608, 91618, 91628, 91638, 91648, 91658, 91668, 91678, 91688, 91698, 91708, 91718, 91728, 91738, 91748, 91758, 91768, 91778, 91788, 91798, 91808, 91818, 91828, 91838, 91848, 91858, 91868, 91878, 91888, 91898, 91908, 91918, 91928, 91938, 91948, 91958, 91968, 91978, 91988, 91998, 92008, 92018, 92028, 92038, 92048, 92058, 92068, 92078, 92088, 92098, 92108, 92118, 92128, 92138, 92148, 92158, 92168, 92178, 92188, 92198, 92208, 92218, 92228, 92238, 92248, 92258, 92268, 92278, 92288, 92298, 92308, 92318, 92328, 92338, 92348, 92358, 92368, 92378, 92388, 92398, 92408, 92418, 92428, 92438, 92448, 92458, 92468, 92478, 92488, 92498, 92508, 92518, 92528, 92538, 92548, 92558, 92568, 92578, 92588, 92598, 92608, 92618, 92628, 92638, 92648, 92658, 92668, 92678, 92688, 92698, 92708, 92718, 92728, 92738, 92748, 92758, 92768, 92778, 92788, 92798, 92808, 92818, 92828, 92838, 92848, 92858, 92868, 92878, 92888, 92898, 92908, 92918, 92928, 92938, 92948, 92958, 92968, 92978, 92988, 92998, 93008, 93018, 93028, 93038, 93048, 93058, 93068, 93078, 93088, 93098, 93108, 93118, 93128, 93138, 93148, 93158, 93168, 93178, 93188, 93198, 93208, 93218, 93228, 93238, 93248, 93258, 93268, 93278, 93288, 93298, 93308, 93318, 93328, 93338, 93348, 93358, 93368, 93378, 93388, 93398, 93408, 93418, 93428, 93438, 93448, 93458, 93468, 93478, 93488, 93498, 93508, 93518, 93528, 93538, 93548, 93558, 93568, 93578, 93588, 93598, 93608, 93618, 93628, 93638, 93648, 93658, 93668, 93678, 93688, 93698, 93708, 93718, 93728, 93738, 93748, 93758, 93768, 93778, 93788, 93798, 93808, 93818, 93828, 93838, 93848, 93858, 93868, 93878, 93888, 93898, 93908, 93918, 93928, 93938, 93948, 93958, 93968, 93978, 93988, 93998, 94008, 94018, 94028, 94038, 94048, 94058, 94068, 94078, 94088, 94098, 94108, 94118, 94128, 94138, 94148, 94158, 94168, 94178, 94188, 94198, 94208, 94218, 94228, 94238, 94248, 94258, 94268, 94278, 94288, 94298, 94308, 94318, 94328, 94338, 94348, 94358, 94368, 94378, 94388, 94398, 94408, 94418, 94428, 94438, 94448, 94458, 94468, 94478, 94488, 94498, 94508, 94518, 94528, 94538, 94548, 94558, 94568, 94578, 94588, 94598, 94608, 94618, 94628, 94638, 94648, 94658, 94668, 94678, 94688, 94698, 94708, 94718, 94728, 94738, 94748, 94758, 94768, 94778, 94788, 94798, 94808, 94818, 94828, 94838, 94848, 94858, 94868, 94878, 94888, 94898, 94908, 94918, 94928, 94938, 94948, 94958, 94968, 94978, 94988, 94998, 95008, 95018, 95028, 95038, 95048, 95058, 95068, 95078, 95088, 95098, 95108, 95118, 95128, 95138, 95148, 95158, 95168, 95178, 95188, 95198, 95208, 95218, 95228, 95238, 95248, 95258, 95268, 95278, 95288, 95298, 95308, 95318, 95328, 95338, 95348, 95358, 95368, 95378, 95388, 95398, 95408, 95418, 95428, 95438, 95448, 95458, 95468, 95478, 95488, 95498, 95508, 95518, 95528, 95538, 95548, 95558, 95568, 95578, 95588, 95598, 95608, 95618, 95628, 95638, 95648, 95658, 95668, 95678, 95688, 95698, 95708, 95718, 95728, 95738, 95748, 95758, 95768, 95778, 95788, 95798, 95808, 95818, 95828, 95838, 95848, 95858, 95868, 95878, 95888, 95898, 95908, 95918, 95928, 95938, 95948, 95958, 95968, 95978, 95988, 95998, 96008, 96018, 96028, 96038, 96048, 96058, 96068, 96078, 96088, 96098, 96108, 96118, 96128, 96138, 96148, 96158, 96168, 96178, 96188, 96198, 96208, 96218, 96228, 96238, 96248, 96258, 96268, 96278, 96288, 96298, 96308, 96318, 96328, 96338, 96348, 96358, 96368, 96378, 96388, 96398, 96408, 96418, 96428, 96438, 96448, 96458, 96468, 96478, 96488, 96498, 96508, 96518, 96528, 96538, 96548, 96558, 96568, 96578, 96588, 96598, 96608, 96618, 96628, 96638, 96648, 96658, 96668, 96678, 96688, 96698, 96708, 96718, 96728, 96738, 96748, 96758, 96768, 96778, 96788, 96798, 96808, 96818, 96828, 96838, 96848, 96858, 96868, 96878, 96888, 96898, 96908, 96918, 96928, 96938, 96948, 96958, 96968, 96978, 96988, 96998, 97008, 97018, 97028, 97038, 97048, 97058, 97068, 97078, 97088, 97098, 97108, 97118, 97128, 97138, 97148, 97158, 97168, 97178, 97188, 97198, 97208, 97218, 97228, 97238, 97248, 97258, 97268, 97278, 97288, 97298, 97308, 97318, 97328, 97338, 97348, 97358, 97368, 97378, 97388, 97398, 97408, 97418, 97428, 97438, 97448, 97458, 97468, 97478, 97488, 97498, 97508, 97518, 97528, 97538, 97548, 97558, 97568, 97578, 97588, 97598, 97608, 97618, 97628, 97638, 97648, 97658, 97668, 97678, 97688, 97698, 97708, 97718, 97728, 97738, 97748, 97758, 97768, 97778, 97788, 97798, 97808, 97818, 97828, 97838, 97848, 97858, 97868, 97878, 97888, 97898, 97908, 97918, 97928, 97938, 97948, 97958, 97968, 97978, 97988, 97998, 98008, 98018, 98028, 98038, 98048, 98058, 98068, 98078, 98088, 98098, 98108, 98118, 98128, 98138, 98148, 98158, 98168, 98178, 98188, 98198, 98208, 98218, 98228, 98238, 98248, 98258, 98268, 98278, 98288, 98298, 98308, 98318, 98328, 98338, 98348, 98358, 98368, 98378, 98388, 98398, 98408, 98418, 98428, 98438, 98448, 98458, 98468, 98478, 98488, 98498, 98508, 98518, 98528, 98538, 98548, 98558, 98568, 98578, 98588, 98598, 98608, 98618, 98628, 98638, 98648, 98658, 98668, 98678, 98688, 98698, 98708, 98718, 98728, 98738, 98748, 98758, 98768, 98778, 98788, 98798, 98808, 98818, 98828, 98838, 98848, 98858, 98868, 98878, 98888, 98898, 98908, 98918, 98928, 98938, 98948, 98958, 98968, 98978, 98988, 98998, 99008, 99018, 99028, 99038, 99048, 99058, 99068, 99078, 99088, 99098, 99108, 99118, 99128, 99138, 99148, 99158, 99168, 99178, 99188, 99198, 99208, 99218, 99228, 99238, 99248, 99258, 99268, 99278, 99288, 99298, 99308, 99318, 99328, 99338, 99348, 99358, 99368, 99378, 99388, 99398, 99408, 99418, 99428, 99438, 99448, 99458, 99468, 99478, 99488, 99498, 99508, 99518, 99528, 99538, 99548, 99558, 99568, 99578, 99588, 99598, 99608, 99618, 99628, 99638, 99648, 99658, 99668, 99678, 99688, 99698, 99708, 99718, 99728, 99738, 99748, 99758, 99768, 99778, 99788, 99798, 99808, 99818, 99828, 99838, 99848, 99858, 99868, 99878, 99888, 99898, 99908, 99918, 99928, 99938, 99948, 99958, 99968, 99978, 99988, 99998, 100008, 100018, 100028, 100038, 100048, 100058, 100068, 100078, 100088, 100098, 100108, 100118, 100128, 100138, 100148, 100158, 100168, 100178, 100188, 100198, 100208, 100218, 100228, 100238, 100248, 100258, 100268, 100278, 100288, 100298, 100308, 100318, 100328, 100338, 100348, 100358, 100368, 100378, 100388, 100398, 100408, 100418, 100428, 100438, 100448, 100458, 100468, 100478, 100488, 100498, 100508, 100518, 100528, 100538, 100548, 100558, 100568, 100578, 100588, 100598, 100608, 100618, 100628, 100638, 100648, 100658, 100668, 100678, 100688, 100698, 100708, 100718, 100728, 100738, 100748, 100758, 100768, 100778, 100788, 100798, 100808, 100818, 100828, 100838, 100848, 100858, 100868, 100878, 100888, 100898, 100908, 100918, 100928, 100938, 100948, 100958, 100968, 100978, 100988, 100998, 101008, 101018, 101028, 101038, 101048, 101058, 101068, 101078, 101088, 101098, 101108, 101118, 101128, 101138, 101148, 101158, 101168, 101178, 101188, 101198, 101208, 101218, 101228, 101238, 101248, 101258, 101268, 101278, 101288, 101298, 101308, 101318, 101328, 101338, 101348, 101358, 101368, 101378, 101388, 101398, 101408, 101418, 101428, 101438, 101448, 101458, 101468, 101478, 101488, 101498, 101508, 101518, 101528, 101538, 101548, 101558, 101568, 101578, 101588, 101598, 101608, 101618, 101628, 101638, 101648, 101658, 101668, 101678, 101688, 101698, 101708, 101718, 101728, 101738, 101748, 101758, 101768, 101778, 101788, 101798, 101808, 101818, 101828, 101838, 101848, 101858, 101868, 101878, 101888, 101898, 101908, 101918, 101928, 101938, 101948, 101958, 101968, 101978, 101988, 101998, 102008, 102018, 102028, 102038, 102048, 102058, 102068, 102078, 102088, 102098, 102108, 102118, 102128, 102138, 102148, 102158, 102168, 102178, 102188, 102198, 102208, 102218, 102228, 102238, 102248, 102258, 102268, 102278, 102288, 102298, 102308, 102318, 102328, 102338, 102348, 102358, 102368, 102378, 102388, 102398, 102408, 102418, 102428, 102438, 102448, 102458, 102468, 102478, 102488, 102498, 102508, 102518, 102528, 102538, 102548, 102558, 102568, 102578, 102588, 102598, 102608, 102618, 102628, 102638, 102648, 102658, 102668, 102678, 102688, 102698, 102708, 102718, 102728, 102738, 102748, 102758, 102768, 102778, 102788, 102798, 102808, 102818, 102828, 102838, 102848, 102858, 102868, 102878, 102888, 102898, 102908, 102918, 102928, 102938, 102948, 102958, 102968, 102978, 102988, 102998, 103008, 103018, 103028, 103038, 103048, 103058, 103068, 103078, 103088, 103098, 103108, 103118, 103128, 103138, 103148, 103158, 103168, 103178, 103188, 103198, 103208, 103218, 103228, 103238, 103248, 103258, 103268, 103278, 103288, 103298, 103308, 103318, 103328, 103338, 103348, 103358, 103368, 103378, 103388, 103398, 103408, 103418, 103428, 103438, 103448, 103458, 103468, 103478, 103488, 103498, 103508, 103518, 103528, 103538, 103548, 103558, 103568, 103578, 103588, 103598, 103608, 103618, 103628, 103638, 103648, 103658, 103668, 103678, 103688, 103698, 103708, 103718, 103728, 103738, 103748, 103758, 103768, 103778, 103788, 103798, 103808, 103818, 103828, 103838, 103848, 103858, 103868, 103878, 103888, 103898, 103908, 103918, 103928, 103938, 103948, 103958, 103968, 103978, 103988, 103998, 104008, 104018, 104028, 104038, 104048, 104058, 104068, 104078, 104088, 104098, 104108, 104118, 104128, 104138, 104148, 104158, 104168, 104178, 104188, 104198, 104208, 104218, 104228, 104238, 104248, 104258, 104268, 104278, 104288, 104298, 104308, 104318, 104328, 104338, 104348, 104358, 104368, 104378, 104388, 104398, 104408, 104418, 104428, 104438, 104448, 104458, 104468, 104478, 104488, 104498, 104508, 104518, 104528, 104538, 104548, 104558, 104568, 104578, 104588, 104598, 104608, 104618, 104628, 104638, 104648, 104658, 104668, 104678, 104688, 104698, 104708, 104718, 104728, 104738, 104748, 104758, 104768, 104778, 104788, 104798, 104808, 104818, 104828, 104838, 104848, 104858, 104868, 104878, 104888, 104898, 104908, 104918, 104928, 104938, 104948, 104958, 104968, 104978, 104988, 104998, 105008, 105018, 105028, 105038, 105048, 105058, 105068, 105078, 105088, 105098, 105108, 105118, 105128, 105138, 105148, 105158, 105168, 105178, 105188, 105198, 105208, 105218, 105228, 105238, 105248, 105258, 105268, 105278, 105288, 105298, 105308, 105318, 105328, 105338, 105348, 105358, 105368, 105378, 105388, 105398, 105408, 105418, 105428, 105438, 105448, 105458, 105468, 105478, 105488, 105498, 105508, 105518, 105528, 105538, 105548, 105558, 105568, 105578, 105588, 105598, 105608, 105618, 105628, 105638, 105648, 105658, 105668, 105678, 105688, 105698, 105708, 105718, 105728, 105738, 105748, 105758, 105768, 105778, 105788, 105798, 105808, 105818, 105828, 105838, 105848, 105858, 105868, 105878, 105888, 105898, 105908, 105918, 105928, 105938, 105948, 105958, 105968, 105978, 105988, 105998, 106008, 106018, 106028, 106038, 106048, 106058, 106068, 106078, 106088, 106098, 106108, 106118, 106128, 106138, 106148, 106158, 106168, 106178, 106188, 106198, 106208, 106218, 106228, 106238, 106248, 106258, 106268, 106278, 106288, 106298, 106308, 106318, 106328, 106338, 106348, 106358, 106368, 106378, 106388, 106398, 106408, 106418, 106428, 106438, 106448, 106458, 106468, 106478, 106488, 106498, 106508, 106518, 106528, 106538, 106548, 106558, 106568, 106578, 106588, 106598, 106608, 106618, 106628, 106638, 106648, 106658, 106668, 106678, 106688, 106698, 106708, 106718, 106728, 106738, 106748, 106758, 106768, 106778, 106788, 106798, 106808, 106818, 106828, 106838, 106848, 106858, 106868, 106878, 106888, 106898, 106908, 106918, 106928, 106938, 106948, 106958, 106968, 106978, 106988, 106998, 107008, 107018, 107028, 107038, 107048, 107058, 107068, 107078, 107088, 107098, 107108, 107118, 107128, 107138, 107148, 107158, 107168, 107178, 107188, 107198, 107208, 107218, 107228, 107238, 107248, 107258, 107268, 107278, 107288, 107298, 107308, 107318, 107328, 107338, 107348, 107358, 107368, 107378, 107388, 107398, 107408, 107418, 107428, 107438, 107448, 107458, 107468, 107478, 107488, 107498, 107508, 107518, 107528, 107538, 107548, 107558, 107568, 107578, 107588, 107598, 107608, 107618, 107628, 107638, 107648, 107658, 107668, 107678, 107688, 107698, 107708, 107718, 107728, 107738, 107748, 107758, 107768, 107778, 107788, 107798, 107808, 107818, 107828, 107838, 107848, 107858, 107868, 107878, 107888, 107898, 107908, 107918, 107928, 107938, 107948, 107958, 107968, 107978, 107988, 107998, 108008, 108018, 108028, 108038, 108048, 108058, 108068, 108078, 108088, 108098, 108108, 108118, 108128, 108138, 108148, 108158, 108168, 108178, 108188, 108198, 108208, 108218, 108228, 108238, 108248, 108258, 108268, 108278, 108288, 108298, 108308, 108318, 108328, 108338, 108348, 108358, 108368, 108378, 108388, 108398, 108408, 108418, 108428, 108438, 108448, 108458, 108468, 108478, 108488, 108498, 108508, 108518, 108528, 108538, 108548, 108558, 108568, 108578, 108588, 108598, 108608, 108618, 108628, 108638, 108648, 108658, 108668, 108678, 108688, 108698, 108708, 108718, 108728, 108738, 108748, 108758, 108768, 108778, 108788, 108798, 108808, 108818, 108828, 108838, 108848, 108858, 108868, 108878, 108888, 108898, 108908, 108918, 108928, 108938, 108948, 108958, 108968, 108978, 108988, 108998, 109008, 109018, 109028, 109038, 109048, 109058, 109068, 109078, 109088, 109098, 109108, 109118, 109128, 109138, 109148, 109158, 109168, 109178, 109188, 109198, 109208, 109218, 109228, 109238, 109248, 109258, 109268, 109278, 109288, 109298, 109308, 109318, 109328, 109338, 109348, 109358, 109368, 109378, 109388, 109398, 109408, 109418, 109428, 109438, 109448, 109458, 109468, 109478, 109488, 109498, 109508, 109518, 109528, 109538, 109548, 109558, 109568, 109578, 109588, 109598, 109608, 109618, 109628, 109638, 109648, 109658, 109668, 109678, 109688, 109698, 109708, 109718, 109728, 109738, 109748, 109758, 109768, 109778, 109788, 109798, 109808, 109818, 109828, 109838, 109848, 109858, 109868, 109878, 109888, 109898, 109908, 109918, 109928, 109938, 109948, 109958, 109968, 109978, 109988, 109998, 110008, 110018, 110028, 110038, 110048, 110058, 110068, 110078, 110088, 110098, 110108, 110118, 110128, 110138, 110148, 110158, 110168, 110178, 110188, 110198, 110208, 110218, 110228, 110238, 110248, 110258, 110268, 110278, 110288, 110298, 110308, 110318, 110328, 110338, 110348, 110358, 110368, 110378, 110388, 110398, 110408, 110418, 110428, 110438, 110448, 110458, 110468, 110478, 110488, 110498, 110508, 110518, 110528, 110538, 110548, 110558, 110568, 110578, 110588, 110598, 110608, 110618, 110628, 110638, 110648, 110658, 110668, 110678, 110688, 110698, 110708, 110718, 110728, 110738, 110748, 110758, 110768, 110778, 110788, 110798, 110808, 110818)) ORDER BY node_data_field_nodeorder_field_nodeorder_value ASC

slow.txt

http://pdup.allplayers.com/g/group-86938/node/86938/edit

this took 26 seconds:


/* admin : execute */ SELECT DISTINCT node.nid AS nid, node.title AS node_title, og.og_description AS og_og_description, users.name AS users_name, users.uid AS users_uid, (SELECT COUNT(*) FROM og_uid ou INNER JOIN users u ON ou.uid = u.uid WHERE ou.nid = og.nid AND u.status > 0 AND ou.is_active >= 1 AND ou.is_admin >= 0 ) AS member_count, node_data_field_nodeorder.field_nodeorder_value AS node_data_field_nodeorder_field_nodeorder_value, node.type AS node_type, node.vid AS node_vid, node_data_field_group.field_group_nid AS node_data_field_group_field_group_nid FROM node node LEFT JOIN og og ON node.nid = og.nid INNER JOIN users users ON node.uid = users.uid LEFT JOIN content_field_nodeorder node_data_field_nodeorder ON node.vid = node_data_field_nodeorder.vid LEFT JOIN content_field_group node_data_field_group ON node.vid = node_data_field_group.vid WHERE (node.status <> 0) AND (node.type IN ('group','association','league','team')) AND (node.type in ('group')) AND (node.nid IN (109538, 109548, 109558, 109568, 109578, 109588, 109598, 109608, 109618, 109918, 109928, 109938, 109948, 109958, 109978, 110328, 110338, 110458, 110468, 110498, 110508, 110518, 110528, 110768, 110808, 86818, 86828, 86838, 86848, 86858, 86868, 86878, 86888, 86898, 86908, 86918, 86928, 86938, 86948, 86958, 86968, 86978, 86988, 86998, 87008, 87018, 87028, 87038, 87048, 87058, 87068, 87078, 87088, 87098, 87108, 87118, 87128, 87138, 87148, 87158, 87168, 87178, 87188, 87198, 87968, 88518, 88528, 88538, 88558, 88568, 88578, 88588, 88598, 88608, 88628, 88638, 88658, 88678, 88688, 88698, 88708, 88718, 88738, 88748, 88758, 88768, 88788, 88808, 88818, 88828, 88838, 88848, 88858, 88868, 88878, 88888, 88898, 88908, 88918, 88928, 88938, 88948, 88958, 88968, 88978, 88988, 88998, 89008, 89018, 89028, 89038, 89048, 89058, 89068, 89078, 89088, 89098, 89108, 89118, 89128, 89138, 89148, 89158, 89168, 89178, 89188, 89198, 89208, 89218, 89228, 89238, 89248, 89258, 89268, 89278, 89288, 89298, 89308, 89318, 89328, 89338, 89348, 89358, 89368, 89378, 89388, 89398, 89408, 89418, 89428, 89438, 89448, 89458, 89468, 89478, 89488, 89498, 89508, 89518, 89528, 89538, 89548, 89558, 89568, 89578, 89588, 89598, 89608, 89618, 89628, 89638, 89648, 89658, 89668, 89678, 89688, 89698, 89708, 89718, 89728, 89738, 89748, 89758, 89768, 89778, 89788, 89798, 89808, 89818, 89828, 89838, 89848, 89858, 89868, 89878, 89888, 89898, 89908, 89918, 89928, 89938, 89948, 89958, 89968, 89978, 89988, 89998, 90008, 90018, 90028, 90038, 90048, 90058, 90068, 90078, 90088, 90098, 90108, 90118, 90128, 90138, 90148, 90158, 90168, 90178, 90188, 90198, 90208, 90218, 90228, 90238, 90248, 90258, 90268, 90278, 90288, 90298, 90308, 90318, 90328, 90338, 90348, 90358, 90368, 90378, 90388, 90398, 90408, 90418, 90428, 90438, 90448, 90458, 90468, 90478, 90488, 90498, 90508, 90518, 90528, 90538, 90548, 90558, 90568, 90578, 90588, 90598, 90608, 90618, 90628, 90638, 90648, 90658, 90668, 90678, 90688, 90698, 90708, 90718, 90728, 90738, 90748, 90758, 90768, 90778, 90788, 90798, 90808, 90818, 90828, 90838, 90848, 90858, 90868, 90878, 90888, 90898, 90918, 90928, 90948, 90958, 90968, 90978, 90988, 90998, 91008, 91018, 91028, 91038, 91048, 91058, 91068, 91078, 91088, 91098, 91108, 91118, 91128, 91138, 91148, 91158, 91168, 91178, 91188, 91198, 91208, 91218, 91228, 91238, 91248, 91258, 91268, 91278, 91288, 91298, 91308, 91318, 91328, 91338, 91348, 91358, 91368, 91378, 91388, 91398, 91408, 91418, 91428, 91438, 91448, 91458, 91468, 91478, 91488, 91498, 91508, 91518, 91528, 91538, 91548, 91558, 91568, 91578, 91588, 91598, 91608, 91618, 91628, 91638, 91648, 91658, 91668, 91678, 91688, 91698, 91708, 91718, 91728, 91738, 91748, 91758, 91768, 91778, 91788, 91798, 91808, 91818, 91828, 91838, 91848, 91858, 91868, 91878, 91888, 91898, 91908, 91918, 91928, 91938, 91948, 91958, 91968, 91978, 91988, 91998, 92008, 92018, 92028, 92038, 92048, 92058, 92068, 92078, 92088, 92098, 92108, 92118, 92128, 92138, 92148, 92158, 92168, 92178, 92188, 92198, 92208, 92218, 92228, 92238, 92248, 92258, 92268, 92278, 92288, 92298, 92308, 92318, 92328, 92338, 92348, 92358, 92368, 92378, 92388, 92398, 92408, 92418, 92428, 92438, 92448, 92458, 92468, 92478, 92488, 92498, 92508, 92518, 92528, 92538, 92548, 92558, 92568, 92578, 92588, 92598, 92608, 92618, 92628, 92638, 92648, 92658, 92668, 92678, 92688, 92698, 92708, 92718, 92728, 92738, 92748, 92758, 92768, 92778, 92788, 92798, 92808, 92818, 92828, 92838, 92848, 92858, 92868, 92878, 92888, 92898, 92908, 92918, 92928, 92938, 92948, 92958, 92968, 92978, 92988, 92998, 93008, 93018, 93028, 93038, 93048, 93058, 93068, 93078, 93088, 93098, 93108, 93118, 93128, 93138, 93148, 93158, 93168, 93178, 93188, 93198, 93208, 93218, 93228, 93238, 93248, 93258, 93268, 93278, 93288, 93298, 93308, 93318, 93328, 93338, 93348, 93358, 93368, 93378, 93388, 93398, 93408, 93418, 93428, 93438, 93448, 93458, 93468, 93478, 93488, 93498, 93508, 93518, 93528, 93538, 93548, 93558, 93568, 93578, 93588, 93598, 93608, 93618, 93628, 93638, 93648, 93658, 93668, 93678, 93688, 93698, 93708, 93718, 93728, 93738, 93748, 93758, 93768, 93778, 93788, 93798, 93808, 93818, 93828, 93838, 93848, 93858, 93868, 93878, 93888, 93898, 93908, 93918, 93928, 93938, 93948, 93958, 93968, 93978, 93988, 93998, 94008, 94018, 94028, 94038, 94048, 94058, 94068, 94078, 94088, 94098, 94108, 94118, 94128, 94138, 94148, 94158, 94168, 94178, 94188, 94198, 94208, 94218, 94228, 94238, 94248, 94258, 94268, 94278, 94288, 94298, 94308, 94318, 94328, 94338, 94348, 94358, 94368, 94378, 94388, 94398, 94408, 94418, 94428, 94438, 94448, 94458, 94468, 94478, 94488, 94498, 94508, 94518, 94528, 94538, 94548, 94558, 94568, 94578, 94588, 94598, 94608, 94618, 94628, 94638, 94648, 94658, 94668, 94678, 94688, 94698, 94708, 94718, 94728, 94738, 94748, 94758, 94768, 94778, 94788, 94798, 94808, 94818, 94828, 94838, 94848, 94858, 94868, 94878, 94888, 94898, 94908, 94918, 94928, 94938, 94948, 94958, 94968, 94978, 94988, 94998, 95008, 95018, 95028, 95038, 95048, 95058, 95068, 95078, 95088, 95098, 95108, 95118, 95128, 95138, 95148, 95158, 95168, 95178, 95188, 95198, 95208, 95218, 95228, 95238, 95248, 95258, 95268, 95278, 95288, 95298, 95308, 95318, 95328, 95338, 95348, 95358, 95368, 95378, 95388, 95398, 95408, 95418, 95428, 95438, 95448, 95458, 95468, 95478, 95488, 95498, 95508, 95518, 95528, 95538, 95548, 95558, 95568, 95578, 95588, 95598, 95608, 95618, 95628, 95638, 95648, 95658, 95668, 95678, 95688, 95698, 95708, 95718, 95728, 95738, 95748, 95758, 95768, 95778, 95788, 95798, 95808, 95818, 95828, 95838, 95848, 95858, 95868, 95878, 95888, 95898, 95908, 95918, 95928, 95938, 95948, 95958, 95968, 95978, 95988, 95998, 96008, 96018, 96028, 96038, 96048, 96058, 96068, 96078, 96088, 96098, 96108, 96118, 96128, 96138, 96148, 96158, 96168, 96178, 96188, 96198, 96208, 96218, 96228, 96238, 96248, 96258, 96268, 96278, 96288, 96298, 96308, 96318, 96328, 96338, 96348, 96358, 96368, 96378, 96388, 96398, 96408, 96418, 96428, 96438, 96448, 96458, 96468, 96478, 96488, 96498, 96508, 96518, 96528, 96538, 96548, 96558, 96568, 96578, 96588, 96598, 96608, 96618, 96628, 96638, 96648, 96658, 96668, 96678, 96688, 96698, 96708, 96718, 96728, 96738, 96748, 96758, 96768, 96778, 96788, 96798, 96808, 96818, 96828, 96838, 96848, 96858, 96868, 96878, 96888, 96898, 96908, 96918, 96928, 96938, 96948, 96958, 96968, 96978, 96988, 96998, 97008, 97018, 97028, 97038, 97048, 97058, 97068, 97078, 97088, 97098, 97108, 97118, 97128, 97138, 97148, 97158, 97168, 97178, 97188, 97198, 97208, 97218, 97228, 97238, 97248, 97258, 97268, 97278, 97288, 97298, 97308, 97318, 97328, 97338, 97348, 97358, 97368, 97378, 97388, 97398, 97408, 97418, 97428, 97438, 97448, 97458, 97468, 97478, 97488, 97498, 97508, 97518, 97528, 97538, 97548, 97558, 97568, 97578, 97588, 97598, 97608, 97618, 97628, 97638, 97648, 97658, 97668, 97678, 97688, 97698, 97708, 97718, 97728, 97738, 97748, 97758, 97768, 97778, 97788, 97798, 97808, 97818, 97828, 97838, 97848, 97858, 97868, 97878, 97888, 97898, 97908, 97918, 97928, 97938, 97948, 97958, 97968, 97978, 97988, 97998, 98008, 98018, 98028, 98038, 98048, 98058, 98068, 98078, 98088, 98098, 98108, 98118, 98128, 98138, 98148, 98158, 98168, 98178, 98188, 98198, 98208, 98218, 98228, 98238, 98248, 98258, 98268, 98278, 98288, 98298, 98308, 98318, 98328, 98338, 98348, 98358, 98368, 98378, 98388, 98398, 98408, 98418, 98428, 98438, 98448, 98458, 98468, 98478, 98488, 98498, 98508, 98518, 98528, 98538, 98548, 98558, 98568, 98578, 98588, 98598, 98608, 98618, 98628, 98638, 98648, 98658, 98668, 98678, 98688, 98698, 98708, 98718, 98728, 98738, 98748, 98758, 98768, 98778, 98788, 98798, 98808, 98818, 98828, 98838, 98848, 98858, 98868, 98878, 98888, 98898, 98908, 98918, 98928, 98938, 98948, 98958, 98968, 98978, 98988, 98998, 99008, 99018, 99028, 99038, 99048, 99058, 99068, 99078, 99088, 99098, 99108, 99118, 99128, 99138, 99148, 99158, 99168, 99178, 99188, 99198, 99208, 99218, 99228, 99238, 99248, 99258, 99268, 99278, 99288, 99298, 99308, 99318, 99328, 99338, 99348, 99358, 99368, 99378, 99388, 99398, 99408, 99418, 99428, 99438, 99448, 99458, 99468, 99478, 99488, 99498, 99508, 99518, 99528, 99538, 99548, 99558, 99568, 99578, 99588, 99598, 99608, 99618, 99628, 99638, 99648, 99658, 99668, 99678, 99688, 99698, 99708, 99718, 99728, 99738, 99748, 99758, 99768, 99778, 99788, 99798, 99808, 99818, 99828, 99838, 99848, 99858, 99868, 99878, 99888, 99898, 99908, 99918, 99928, 99938, 99948, 99958, 99968, 99978, 99988, 99998, 100008, 100018, 100028, 100038, 100048, 100058, 100068, 100078, 100088, 100098, 100108, 100118, 100128, 100138, 100148, 100158, 100168, 100178, 100188, 100198, 100208, 100218, 100228, 100238, 100248, 100258, 100268, 100278, 100288, 100298, 100308, 100318, 100328, 100338, 100348, 100358, 100368, 100378, 100388, 100398, 100408, 100418, 100428, 100438, 100448, 100458, 100468, 100478, 100488, 100498, 100508, 100518, 100528, 100538, 100548, 100558, 100568, 100578, 100588, 100598, 100608, 100618, 100628, 100638, 100648, 100658, 100668, 100678, 100688, 100698, 100708, 100718, 100728, 100738, 100748, 100758, 100768, 100778, 100788, 100798, 100808, 100818, 100828, 100838, 100848, 100858, 100868, 100878, 100888, 100898, 100908, 100918, 100928, 100938, 100948, 100958, 100968, 100978, 100988, 100998, 101008, 101018, 101028, 101038, 101048, 101058, 101068, 101078, 101088, 101098, 101108, 101118, 101128, 101138, 101148, 101158, 101168, 101178, 101188, 101198, 101208, 101218, 101228, 101238, 101248, 101258, 101268, 101278, 101288, 101298, 101308, 101318, 101328, 101338, 101348, 101358, 101368, 101378, 101388, 101398, 101408, 101418, 101428, 101438, 101448, 101458, 101468, 101478, 101488, 101498, 101508, 101518, 101528, 101538, 101548, 101558, 101568, 101578, 101588, 101598, 101608, 101618, 101628, 101638, 101648, 101658, 101668, 101678, 101688, 101698, 101708, 101718, 101728, 101738, 101748, 101758, 101768, 101778, 101788, 101798, 101808, 101818, 101828, 101838, 101848, 101858, 101868, 101878, 101888, 101898, 101908, 101918, 101928, 101938, 101948, 101958, 101968, 101978, 101988, 101998, 102008, 102018, 102028, 102038, 102048, 102058, 102068, 102078, 102088, 102098, 102108, 102118, 102128, 102138, 102148, 102158, 102168, 102178, 102188, 102198, 102208, 102218, 102228, 102238, 102248, 102258, 102268, 102278, 102288, 102298, 102308, 102318, 102328, 102338, 102348, 102358, 102368, 102378, 102388, 102398, 102408, 102418, 102428, 102438, 102448, 102458, 102468, 102478, 102488, 102498, 102508, 102518, 102528, 102538, 102548, 102558, 102568, 102578, 102588, 102598, 102608, 102618, 102628, 102638, 102648, 102658, 102668, 102678, 102688, 102698, 102708, 102718, 102728, 102738, 102748, 102758, 102768, 102778, 102788, 102798, 102808, 102818, 102828, 102838, 102848, 102858, 102868, 102878, 102888, 102898, 102908, 102918, 102928, 102938, 102948, 102958, 102968, 102978, 102988, 102998, 103008, 103018, 103028, 103038, 103048, 103058, 103068, 103078, 103088, 103098, 103108, 103118, 103128, 103138, 103148, 103158, 103168, 103178, 103188, 103198, 103208, 103218, 103228, 103238, 103248, 103258, 103268, 103278, 103288, 103298, 103308, 103318, 103328, 103338, 103348, 103358, 103368, 103378, 103388, 103398, 103408, 103418, 103428, 103438, 103448, 103458, 103468, 103478, 103488, 103498, 103508, 103518, 103528, 103538, 103548, 103558, 103568, 103578, 103588, 103598, 103608, 103618, 103628, 103638, 103648, 103658, 103668, 103678, 103688, 103698, 103708, 103718, 103728, 103738, 103748, 103758, 103768, 103778, 103788, 103798, 103808, 103818, 103828, 103838, 103848, 103858, 103868, 103878, 103888, 103898, 103908, 103918, 103928, 103938, 103948, 103958, 103968, 103978, 103988, 103998, 104008, 104018, 104028, 104038, 104048, 104058, 104068, 104078, 104088, 104098, 104108, 104118, 104128, 104138, 104148, 104158, 104168, 104178, 104188, 104198, 104208, 104218, 104228, 104238, 104248, 104258, 104268, 104278, 104288, 104298, 104308, 104318, 104328, 104338, 104348, 104358, 104368, 104378, 104388, 104398, 104408, 104418, 104428, 104438, 104448, 104458, 104468, 104478, 104488, 104498, 104508, 104518, 104528, 104538, 104548, 104558, 104568, 104578, 104588, 104598, 104608, 104618, 104628, 104638, 104648, 104658, 104668, 104678, 104688, 104698, 104708, 104718, 104728, 104738, 104748, 104758, 104768, 104778, 104788, 104798, 104808, 104818, 104828, 104838, 104848, 104858, 104868, 104878, 104888, 104898, 104908, 104918, 104928, 104938, 104948, 104958, 104968, 104978, 104988, 104998, 105008, 105018, 105028, 105038, 105048, 105058, 105068, 105078, 105088, 105098, 105108, 105118, 105128, 105138, 105148, 105158, 105168, 105178, 105188, 105198, 105208, 105218, 105228, 105238, 105248, 105258, 105268, 105278, 105288, 105298, 105308, 105318, 105328, 105338, 105348, 105358, 105368, 105378, 105388, 105398, 105408, 105418, 105428, 105438, 105448, 105458, 105468, 105478, 105488, 105498, 105508, 105518, 105528, 105538, 105548, 105558, 105568, 105578, 105588, 105598, 105608, 105618, 105628, 105638, 105648, 105658, 105668, 105678, 105688, 105698, 105708, 105718, 105728, 105738, 105748, 105758, 105768, 105778, 105788, 105798, 105808, 105818, 105828, 105838, 105848, 105858, 105868, 105878, 105888, 105898, 105908, 105918, 105928, 105938, 105948, 105958, 105968, 105978, 105988, 105998, 106008, 106018, 106028, 106038, 106048, 106058, 106068, 106078, 106088, 106098, 106108, 106118, 106128, 106138, 106148, 106158, 106168, 106178, 106188, 106198, 106208, 106218, 106228, 106238, 106248, 106258, 106268, 106278, 106288, 106298, 106308, 106318, 106328, 106338, 106348, 106358, 106368, 106378, 106388, 106398, 106408, 106418, 106428, 106438, 106448, 106458, 106468, 106478, 106488, 106498, 106508, 106518, 106528, 106538, 106548, 106558, 106568, 106578, 106588, 106598, 106608, 106618, 106628, 106638, 106648, 106658, 106668, 106678, 106688, 106698, 106708, 106718, 106728, 106738, 106748, 106758, 106768, 106778, 106788, 106798, 106808, 106818, 106828, 106838, 106848, 106858, 106868, 106878, 106888, 106898, 106908, 106918, 106928, 106938, 106948, 106958, 106968, 106978, 106988, 106998, 107008, 107018, 107028, 107038, 107048, 107058, 107068, 107078, 107088, 107098, 107108, 107118, 107128, 107138, 107148, 107158, 107168, 107178, 107188, 107198, 107208, 107218, 107228, 107238, 107248, 107258, 107268, 107278, 107288, 107298, 107308, 107318, 107328, 107338, 107348, 107358, 107368, 107378, 107388, 107398, 107408, 107418, 107428, 107438, 107448, 107458, 107468, 107478, 107488, 107498, 107508, 107518, 107528, 107538, 107548, 107558, 107568, 107578, 107588, 107598, 107608, 107618, 107628, 107638, 107648, 107658, 107668, 107678, 107688, 107698, 107708, 107718, 107728, 107738, 107748, 107758, 107768, 107778, 107788, 107798, 107808, 107818, 107828, 107838, 107848, 107858, 107868, 107878, 107888, 107898, 107908, 107918, 107928, 107938, 107948, 107958, 107968, 107978, 107988, 107998, 108008, 108018, 108028, 108038, 108048, 108058, 108068, 108078, 108088, 108098, 108108, 108118, 108128, 108138, 108148, 108158, 108168, 108178, 108188, 108198, 108208, 108218, 108228, 108238, 108248, 108258, 108268, 108278, 108288, 108298, 108308, 108318, 108328, 108338, 108348, 108358, 108368, 108378, 108388, 108398, 108408, 108418, 108428, 108438, 108448, 108458, 108468, 108478, 108488, 108498, 108508, 108518, 108528, 108538, 108548, 108558, 108568, 108578, 108588, 108598, 108608, 108618, 108628, 108638, 108648, 108658, 108668, 108678, 108688, 108698, 108708, 108718, 108728, 108738, 108748, 108758, 108768, 108778, 108788, 108798, 108808, 108818, 108828, 108838, 108848, 108858, 108868, 108878, 108888, 108898, 108908, 108918, 108928, 108938, 108948, 108958, 108968, 108978, 108988, 108998, 109008, 109018, 109028, 109038, 109048, 109058, 109068, 109078, 109088, 109098, 109108, 109118, 109128, 109138, 109148, 109158, 109168, 109178, 109188, 109198, 109208, 109218, 109228, 109238, 109248, 109258, 109268, 109278, 109288, 109298, 109308, 109318, 109328, 109338, 109348, 109358, 109368, 109378, 109388, 109398, 109408, 109418, 109428, 109438, 109448, 109458, 109468, 109478, 109488, 109498, 109508, 109518, 109528, 109538, 109548, 109558, 109568, 109578, 109588, 109598, 109608, 109618, 109628, 109638, 109648, 109658, 109668, 109678, 109688, 109698, 109708, 109718, 109728, 109738, 109748, 109758, 109768, 109778, 109788, 109798, 109808, 109818, 109828, 109838, 109848, 109858, 109868, 109878, 109888, 109898, 109908, 109918, 109928, 109938, 109948, 109958, 109968, 109978, 109988, 109998, 110008, 110018, 110028, 110038, 110048, 110058, 110068, 110078, 110088, 110098, 110108, 110118, 110128, 110138, 110148, 110158, 110168, 110178, 110188, 110198, 110208, 110218, 110228, 110238, 110248, 110258, 110268, 110278, 110288, 110298, 110308, 110318, 110328, 110338, 110348, 110358, 110368, 110378, 110388, 110398, 110408, 110418, 110428, 110438, 110448, 110458, 110468, 110478, 110488, 110498, 110508, 110518, 110528, 110538, 110548, 110558, 110568, 110578, 110588, 110598, 110608, 110618, 110628, 110638, 110648, 110658, 110668, 110678, 110688, 110698, 110708, 110718, 110728, 110738, 110748, 110758, 110768, 110778, 110788, 110798, 110808, 110818)) ORDER BY node_data_field_nodeorder_field_nodeorder_value ASC