# Query_time: 11 Lock_time: 0 Rows_sent: 2 Rows_examined: 13
SELECT
g2_ChildEntity.g_id , g2_ItemAttributesMap.g_orderWeight
FROM
g2_ChildEntity, g2_Item, g2_AccessSubscriberMap, g2_ItemAttributesMap
WHERE
g2_ChildEntity.g_parentId = 7
AND
g2_ChildEntity.g_id = g2_Item.g_id
AND
g2_AccessSubscriberMap.g_itemId = g2_ChildEntity.g_id
AND
g2_AccessSubscriberMap.g_accessListId IN (282599,282600,282601,282603,282604,282605,282606,282607,282608,282609,282610,282611,282612,282613,282614,282615,282616,282617,282618,282619,282620,282621,282622,282623,282624,282625,282626,282627,282628,282629,282630,282631,282632,282633,282634,282635,282636,282637,282638,282639,282640,282641,282642,282643,282644,282645,282646,282647,282648,282649,282650,282651,282652,282653,282654,282655,282656,282657,282658,282659,282660,282661,282662,282663,282664,282665,282666,282667,282668,282669,282670,282671,282672,282673,282674,282675,282676,282677,282678,282679,282680,282681,282682,282683,282684,282685,282686,282687,282688,282689,282690,282691,282692,282693,282694,282695,282696,282697,282698,282699,282700,282701,282702,282703,282704,282705,282706,282707,282708,282709,282710,282711,282712,282713,282714,282715,282716,282717,282718,282719,282720,282721,282722,282723,282724,282725,282726,282727,282728,282729,282730,282731,282732,282733,282734,282735,282736,282737,282738,282739,282740,282741,282742,282743,282744,282745,282746,282747,282748,282749,282750,282751,282752,282753,282754,282755,282756,282757,282758,282759,282760,282761,282762,282763,282764,282765,282766,282767,282768,282769,282770,282771,282772,282773,282774,282775,282776,282777,282778,282779,282780,282781,282782,282783,282784,282785,282786,282787,282788,282789,282790,282791,282792,282793,282794,282795,282796,282797,282798,282799,282800,282801,282802,282803,282804,282805,282806,282807,282808,282809,282810,282811,282812,282813,282814,282815,282816,282817,282818,282819,282820,282821,282822,282823,282824,282825,282826,282827,282828,282829,282830,282831,282832,282833,282834,282835,282836,282837,282838,282839,282840,282841,282842,282843,282844,282845,282846,282847,282848,282849,282850,282851,282852,282853,282854,282855,282856,282857,282858,282859,282860,282861,282862,282863,282864,282865,282866,282867,282868,282869,282870,282871,282872,282873,282874,282875,282876,282877,282878,282879,282880,282881,282882,282883,282884,282885,282886,282887,282888,282889,282890,282891,282892,282893,282894,282895,282896,282897,282898,282899,282900,282901,282902,282903,282904,282905,282906,282907,282908,282909,282910,282911,282912,282913,282914,282915,282916,282917,282918,282919,282920,282921,282922,282923,282924,282925,282926,282927,282928,282929,282930,282931,282932,282933,282934,282935,282936,282937,282938,282939,282940,282941,282942,282943,282944,282945,282946,282947,282948,282949,282950,282951,282952,282953,282954,282955,282956,282957,282958,282959,282960,282961,282962,282963,282964,282965,282966,282967,282968,282969,282970,282971,282972,282973,282974,282975,282976,282977,282978,282979,282980,282981,282982,282983,282984,282985,282986,282987,282988,282989,282990,282991,282992,282993,282994,282995,282996,282997,282998,282999,283000,283001,283002,283003,283004,283005,283006,283007,283008,283009,283010,283011,283012,283013,283014,283015,283016,283017,283018,283019,283020,283021,283022,283023,283024,283025,283026,283027,283028,283029,283030,283031,283032,283033,283034,283035,283036,283037,283038,283039,283040,283041,283042,283043,283044,283045,283046,283047,283048,283049,283050,283051,283052,283053,283054,283055,283056,283057,283058,283059,283060,283061,283062,283063,283064,283065,283066,283067,283068,283069,283070,283071,283072,283073,283074,283075,283076,283077,283078,283079,283080,283081,283082,283083,283084,283085,283086,283087,283088,283089,283090,283091,283092,283093,283094,283095,283096,283097,283098,283099,283100,283101,283102,283103,283104,283105,283106,283107,283108,283109,283110,283111,283112,283113,283114,283115,283116,283117,283118,283119,283120,283121,283122,283123,283124,283125,283126,283127,283128,283129,283130,283131,283132,283133,283134,283135,283136,283137,283138,283139,283140,283141,283142,283143,283144,283145,283146,283147,283148,283149,283150,283151,283152,283153,283154,283155,283156,283157,283158,283159,283160,283161,283162,283163,283164,283165,283166,283167,283168,283169,283170,283171,283172,283173,283174,283175,283176,283177,283178,283179,283180,283181,283182,283183,283184,283185,283186,283187,283188,283189,283190,283191,283192,283193,283194,283195,283196,283197,283198,283199,283200,283201,283202,283203,283204,283205,283206,283207,283208,283209,283210,283211,283212,283213,283214,283215,283216,283217,283218,283219,283220,283221,283222,283223,283224,283225,283226,283227,283228,283229,283230,283231,283232,283233,283234,283235,283236,283237,283238,283239,283240,283241,283242,283243,283244,283245,283246,283247,283248,283249,283250,283251,283252,283253,283254,283255,283256,283257,283258,283259,283260,283261,283262,283263,283264,283265,283266,283267,283268,283269,283270,283271,283272,283273,283274,283275,283276,283277,283278,283279,283280,283281,283282,283283,283284,283285,283286,283287,283288,283289,283290,283291,283292,283293,283294,283295,283296,283297,283298,283299,283300,283301,283302,283303,283304,283305,283306,283307,283308,283309,283310,283311,283312,283313,283314,283315,283316,283317,283318,283319,283320,283321,283322,283323,283324,283325,283326,283327,283328,283329,283330,283331,283332,283333,283334,283335,283336,283337,283338,283339,283340,283341,283342,283343,283344,283345,283346,283347,283348,283349,283350,283351,283352,283353,283354,283355,283356,283357,283358,283359,283360,283361,283362,283363,283364,283365,283366,283367,283368,283369,283370,283371,283372,283373,283374,283375,283376,283377,283378,283379,283380,283381,283382,283383,283384,283385,283386,283387,283388,283389,283390,283391,283392,283393,283394,283395,283396,283397,283398,283399,283400,283401,283402,283403,283404,283405,283406,283407,283408,283409,283410,283411,283412,283413,283414,283415,283416,283417,283418,283419,283420,283421,283422,283423,283424,283425,283426,283427,283428,283429,283430,283431,283432,283433,283434,283435,283436,283437,283438,283439,283440,283441,283442,283443,283444,283445,283446,283447,283448,283449,283450,283451,283452,283453,283454,283455,283456,283457,283458,283459,283460,283461,283462,283463,283464,283465,283466,283467,283468,283469,283470,283471,283472,283473,283474,283475,283476,283477,283478,283479,283480,283481,283482,283483,283484,283485,283486,283487,283488,283489,283490,283491,283492,283493,283494,283495,283496,283497,283498,283499,283500,283501,283502,283503,283504,283505,283506,283507,283508,283509,283510,283511,283512,283513,283514,283515,283516,283517,283518,283519,283520,283521,283522,283523,283524,283525,283526,283527,283528,283529,283530,283531,283532,283533,283534,283535,283536,283537,283538,283539,283540,283541,283542,283543,283544,283545,283546,283547,283548,283549,283550,283551,283552,283553,283554,283555,283556,283557,283558,283559,283560,283561,283562,283563,283564,283565,283566,283567,283568,283569,283570,283571,283572,283573,283574,283575,283576,283577,283578,283579,283580,283581,283582,283583,283584,283585,283586,283587,283588,283589,283590,283591,283592,283593,283594,283595,283596,283597,283598,283599,283600,283601,283602,283603,283604,283605,283606,283607,283608,283609,283611,283612,283613,283614,283615,283616,283617,283618,283619,283620,283621,283622,283623,283624,283625,283626,283627,283628,283629,283630,283631,283632,283633,283634,283635,283636,283637,283638,283639,283640,283641,283642,283643,283644,283645,283646,283647,283648,283649,283650,283651,283652,283653,283654,283655,283656,283657,283658,283659,283660,283661,283662,283663,283664,283665,283666,283667,283668,283669,283670,283671,283672,283673,283674,283675,283676,283677,283678,283679,283680,283681,283682,283683,283684,283685,283686,283687,283688,283689,283690,283691,283692,283693,283694,283695,283696,283697,283698,283700,283701,283703,283704,283705,283706,283707,283708,283709,283710,283711,283712,283713,283714,283715,283716,283717,283718,283719,283720,283721,283722,283723,283724,283725,283726,283727,283728,283729,283730,283731,283732,283733,283734,283735,283736,283737,283738,283739,283740,283741,283742,283743,283744,283745,283746,283747,283748,283749,283750,283751,283752,283753,283754,283755,283756,283757,283758,283759,283760,283761,283762,283763,283764,283765,283766,283767,283768,283769,283770,283771,283772,283773,283774,283775,283776,283777,283778,283779,283780,283781,283782,283783,283784,283785,283786,283787,283788,283789,283790,283791,283792,283793,283794,283795,283796,283797,283798,283799,283800,283801,283802,283803,283804,283805,283806,283807,283808,283809,283810,283811,283812,283813,283814,283815,283816,283817,283818,283819,283820,283821,283822,283823,283824,283825,283826,283827,283828,283829,283830,283831,283832,283833,283834,283835,283836,283837,283838,283839,283952,283954,283955,283956,283957,283958,283959,283960,283961,283962,283963,283964,283965,283966,283967,283968,283969,283970,283971,283972,283973,283975,283976,283977,283978,283979,283983,283984,283986,283987,283988,283989,283990,283991,283992,283993,283994,283995,283996,283997,283998,283999,284000,284001,284002,284003,284004,284010,284011,284012,284013,284014,284015,284016,284017,284018,284019,284020,284021,284022,284023,284024,284025,284026,284027,284028,284029,284030,284031,284032,284033,284034,284035,284036,284037,284038,284039,284040,284041,284042,284043,284044,284045,284046,284047,284048,284049,284050,284051,284052,284053,284054,284055,284056,284057,284058,284060,284061,284066,284067,284068,284069,284070,284071,284072,284073,284074,284075,284076,284077,284078,284079,284080,284081,284082,284083,284084,284085,284086,284087,284088,284090,284091,284092,284093,284094,284095,284096,284097,284098,284099,284100,284110,284111,284112,284113,284114,284115,284116,284117,284118,284119,284120,284121,284122,284123,284124,284125,284126,284127,284128,284129,284130,284131,284132,284133,284134,284136,284137,284138,284139,284140,284141,284142,284146,284148,284151,284152,284153,284154,284155,284156,284160,284162,284163,284167,284194,284216,284219,284226,284227,284228,284239,284240,284241,284242,284243,284247,284248,284251,284252,284258,284259,284260,284261,284262,284263,284264,284280,284285,284305,284306,284307,284308,284313,284315,284322,284332,284334,284341,284348,284349,284353,284366,284367,284368,284380,284383,284387,284405,284407,284408,284416,284417,284419,284420,284423,284424,284425,284426,284427,284428,284429,284436,284437,284438,284440,284441,284442,284444,284445,284446,284447,284448,284449,284450,284451,284453,284474,284476,284477,284478,284480,284483,284484,284485,284486,284487,284489,284490,284494,284509,284510,284511,284512,284513,284514,284515,284518,284519,284520,284521,284522,284523,284526,284527,284528,284529,284530,284531,284532,284533,284534,284535,284536,284537,284538,284539,284540,284541,284542,284543,284544,284545,284546,284547,284550,284551,284552,284553,284556,284557,284558,284559,284560,284561,284562,284563,284564,284567,284568,284569,284570,284571,284588,284591,284592,284593,284594,284595,284596,284597,284598,284599,284600,284601,284602,284603,284604,284605,284606,284607,284608,284609,284610,284612,284613,284614,284620,284623,284624,284625,284626,284627,284628,284629,284631,284633,284634,284636,284639,284644,284648,284649,284650,284652,284653,284654,284655,284656,284657,284658,284659,284660,284664,284665,284666,284667,284669,284671,284672,284673,284674,284676,284677,284678,284679,284682,284683,284685,284687,284691,284692,284693,284695,284696,284697,284700,284701,284704,284709,284711,284712,284713,284714,284715,284716,284717,284718,284719,284720,284721,284722,284723,284724,284725,284727,284729,284730,284731,284732,284734,284735,284736,284737,284742,284743,284744,284746,284747,284748,284749,284750,284751,284752,284753,284754,284755,284756,284757,284758,284759,284760,284761,284762,284763,284764,284765,284766,284767,284773,284774,284775,284776,284783,284784,284785,284786,284787,284788,284789,284790,284791,284792,284793,284794,284798,284799,284800,284801,284802,284803,284804,284805,284806,284807,284808,284809,284810,284811,284812,284813,284814,284815,284816,284817,284818,284819,284820,284821,284822,284823,284824,284825,284826,284827,284828,284829,284830,284831,284832,284833,284834,284835,284836,284837,284838,284839,284840,284841,284842,284845,284849,284850,284851,284852,284853,284854,284855,284856,284857,284858,284859,284860,284861,284862,284863,284864,284865,284866,284867,284868,284869,284870,284871,284872,284873,284874,284875,284876,284877,284878,284879,284880,284881,284882,284883,284884,284886,284887,284888,284889,284892,284893,284894,284895,284896,284897,284898,284899,284900,284901,284902,284903,284904,284905,284906,284907,284908,284909,284910,284911,284912,284913,284914,284915,284916,284917,284918,284919,284920,284921,284922,284923,284924,284925,284926,284927,284928,284929,284930,284932,284933,284934,284955,284956,284957,284959,284960,284961,284962,284963,284964,284965,284966,284967,284968,284969,284970,284971,284972,284973,285129,285152,285158,285159,285160,285161,285162,285163,285164,285165,285166,285167,285168,285169,285170,285171,285172,285173,285174,285175,285176,285177,285178,285179,285180,285181,285182,285183,285184,285185,285186,285187,285188,285189,285190,285192,285228,285233,285234,285235,285236,285242,285262,285280,285286,285294,285329,285464,285776,285833,285986,286520,286522,286546,286651,286792,286793,286794,286795,286796,286797,286801,286846)
AND g2_ItemAttributesMap.g_itemId = g2_ChildEntity.g_id ORDER BY g2_ItemAttributesMap.g_orderWeight, g2_ChildEntity.g_id LIMIT 9;