msProducts и where

Други, подскажите, отчего &where=`{«Data.popular»:«1»}` не фильтрует результаты вывода msProducts? Я что-то упустил или оно и не должно работать?

В результатах совсем ничего не выводится.
Wassi Wassinen
12 апреля 2014, 20:38
modx.pro
1
2 014
-1

Комментарии: 5

Василий Наумкин
13 апреля 2014, 07:52
+1
Используй &showLog=`1`, Люк!

Проверил, у меня работает.
    Wassi Wassinen
    13 апреля 2014, 18:05
    0
    0.0000930: xPDO query object created
    0.0003080: leftJoined msProductData as Data
    0.0002382: leftJoined msVendor as Vendor
    0.0009320: leftJoined msProductFile as 120x90
    0.0000060: Grouped by msProduct.id
    0.0001321: Added selection of msProduct: 
    SQL_CALC_FOUND_ROWS `id`, `type`, `contentType`, `pagetitle`, `longtitle`, `description`, `alias`, `link_attributes`, `published`, `pub_date`, `unpub_date`, `parent`, `isfolder`, `introtext`, `richtext`, `template`, `menuindex`, `searchable`, `cacheable`, `createdby`, `createdon`, `editedby`, `editedon`, `deleted`, `deletedon`, `deletedby`, `publishedon`, `publishedby`, `menutitle`, `donthit`, `privateweb`, `privatemgr`, `content_dispo`, `hidemenu`, `class_key`, `context_key`, `content_type`, `uri`, `uri_override`, `hide_children_in_tree`, `show_in_tree`, `properties`
    
    0.0000570: Added selection of msProductData: 
    `article`, `price`, `old_price`, `weight`, `image`, `thumb`, `vendor`, `made_in`, `new`, `popular`, `favorite`, `tags`, `color`, `size`, `source`
    
    0.0000498: Added selection of msVendor: 
    `name` AS `vendor.name`, `resource` AS `vendor.resource`, `country` AS `vendor.country`, `logo` AS `vendor.logo`, `address` AS `vendor.address`, `phone` AS `vendor.phone`, `fax` AS `vendor.fax`, `email` AS `vendor.email`, `description` AS `vendor.description`, `properties` AS `vendor.properties`
    
    0.0000348: Added selection of msProductFile: 
    `url` as `120x90`
    
    0.0953250: Processed additional conditions
    0.1008649: Added where condition: class_key=msProduct, Data.favorite=1, msProduct.parent:IN(9557,10550,11544,11549,12827,12594,11545,12591,11643,13231,13230,9558,9662,9663,9668,9669,9670,9671,9672,12816,9569,9570,9572,9575,9576,9577,9578,9579,9580,9581,9582,9583,9584,9585,9586,9587,9588,9589,9590,9591,9592,9593,9594,9595,9596,9597,9598,9599,9602,9604,9605,9606,9607,9608,9609,9610,9612,9613,9614,9615,9616,9617,9618,9619,9620,9621,9622,9623,9625,9626,9627,9628,9629,9630,9631,9632,9633,9634,9635,9636,9637,9638,9639,9640,9641,9642,9643,9644,9645,9646,9647,9648,9649,9650,9651,9652,9653,9654,9655,9656,9657,9658,9659,9660,9661,9673,9674,9675,9677,9678,9679,9680,9681,9682,9683,9684,9685,9686,9687,9688,9689,9690,9691,9692,9693,9694,9695,9696,9697,9698,9699,9700,9701,9702,9703,9704,9706,9707,9708,9709,9711,9712,9714,9715,9717,9718,9719,9720,9721,9722,9723,9724,9725,9726,9727,9729,9730,9731,9732,9733,9734,9735,9736,9737,9738,9739,9740,9741,9742,9743,9744,9745,9746,9747,9748,9749,9750,9751,9753,9756,9759,9761,9765,9766,9768,9770,9772,9774,9775,9777,9778,9780,9993,9994,9995,9997,9998,9999,10000,10003,10004,10005,10006,10007,10008,10009,10010,10011,10013,10014,10015,10016,10017,10018,10019,10020,10021,10022,10023,10025,10027,10028,10029,10030,10031,10032,10033,10034,10035,10036,10037,10038,10039,10040,10041,10042,10043,10044,10045,10046,10047,10048,10049,10050,10051,9784,9785,9786,9787,9788,9789,9791,9793,9795,9797,9799,9801,9803,9805,9807,9809,10385,10387,10389,10391,10393,10395,10397,10399,10401,10403,10405,10407,10408,10409,10410,10411,10413,10414,10415,10416,10417,10418,10420,10421,10422,10423,10424,10425,10426,10427,10428,10430,10432,10433,10434,10435,10437,10438,10439,10440,10441,10442,10443,10444,10445,10446,10447,10448,10449,10450,10451,10452,10454,10455,10456,10457,10458,10459,10460,10461,10462,10463,10464,10465,10466,10467,10468,10469,10470,10471,10472,10473,10475,10476,10477,10478,10479,10480,10481,10482,10483,10484,10485,10486,10487,10488,10489,10490,10491,10492,10493,10494,10495,10496,10497,10499,10500,10501,10502,10504,10505,10506,10507,10508,10509,10510,10511,10512,10513,10514,10515,10517,10518,10519,10520,10521,10522,10523,10524,10525,10526,10527,10528,10529,10530,10531,10535,10537,10541,10544,10547,10549,10516,9664,9665,9666,9667,9810,9811,9812,9813,9814,9815,9816,9817,9818,9819,9820,9821,9822,9823,9824,9825,9826,9827,9828,9829,9830,10052,10053,10054,10055,10056,10057,10058,10059,10060,10061,10062,10063,10064,9831,9832,9833,9834,9835,9836,9837,9838,9839,9840,9841,9842,9843,9844,9845,9846,9847,9848,9849,9850,9851,9852,9853,9854,9855,9856,9857,9858,9859,9860,9861,9862,9863,9864,9865,9866,9867,9868,9869,9870,9871,9872,9873,10187,10188,10189,10190,10191,10192,10193,10194,10195,10196,10197,10198,10199,10200,10201,10202,10203,10204,10205,10206,10207,10208,10209,10210,10211,10212,10213,10214,10215,10216,10217,10218,10219,10220,10221,9930,9932,9935,9937,9938,9942,9945,9946,9949,10101,10103,10107,10111,10113,10115,10117,10121,10123,10125,10126,10129,10130,10131,10133,10134,10135,10136,10137,10138,10139,10140,10141,10143,10144,10145,10146,10147,10148,10149,10150,10151,10152,10153,10154,10156,10157,10158,10159,10160,10161,10162,10163,10164,10165,10166,10167,10168,10169,10170,10171,10172,9950,9953,9954,9955,9957,9962,9965,9966,9968,9969,9970,10353,10354,10355,10356,10357,10359,10360,10361,10362,10363,10364,10365,10366,10367,10368,9910,9911,9917,9919,9921,9927,9928,10065,10066,10069,10070,10075,10076,10081,10083,10090,10091,10096,10097,10098,10099,9877,9880,9881,9882,9883,9884,9885,9886,9887,9888,9889,9890,9891,9892,9893,9894,9895,9896,9897,9898,9899,9900,9901,9902,9903,9904,9905,9906,10254,10255,10256,10257,10258,10259,10260,10261,10262,10263,10264,10265,10266,10267,10268,10269,10270,10271,10272,10273,10274,10275,10276,10277,10278,10279,10280,10281,10282,10283,10284,10285,10286,10287,10288,10289,10290,10291,10292,10293,10294,10295,10296,10297,10298,10299,10300,10301,10302,10303,10304,10305,10306,10307,10308,10309,10310,10311,10312,10313,10314,10315,10316,10317,10318,10319,10320,10321,10322,10323,10324,10325,10326,10327,10328,10329,10330,10331,10332,10333,10334,10335,10336,10337,10338,10339,10340,10341,10342,10343,10344,10345,10346,10347,10348,10349,10350,10351,10352,12818,12819,12820,12821,12825,12826,12838,12839,12840,12841,12842,12843,12844,12845,12846,12847,12848,12849,12850,12851,12852,12853,12854,12855,12856,12857,12858,12859,12860,12861,12862,12863,12864,12869,12870,12871,12872,12873,12874,12875,12876,12877,12878,12879,12880,12881,12882,12883,12884,12885,12886,12887,12888,12889,12890,12891,12892,12893,12894,12895,12896,12897,12898,12899,12900,12901,12822,12823,12918,12919,12920,12921,10551,10552,10553,10554,10910,10911,10912,11217,11218,11224,11219,11220,11221,11222,11223,10555,10556,10557,10558,10559,10560,10561,10562,10563,10564,10565,10566,10567,10568,10569,10570,10571,10572,10573,10574,10575,10576,10577,10578,10579,10580,10581,10582,10583,10584,10585,10586,10587,10588,10589,10590,10591,10592,10593,10594,10595,10596,10597,10598,10599,10600,10601,10602,10603,10604,10605,10606,10607,10608,10609,10610,10611,10612,10613,10614,10615,10616,10617,10618,10619,10620,10621,10622,10623,10624,10625,10626,10627,10628,10629,10630,10631,10632,10633,10634,10635,10636,10637,10638,10639,10640,10641,10642,10643,10644,10645,10646,10647,10648,10649,10650,10651,10652,10653,10654,10655,10656,10657,10658,10659,10660,10661,10662,10663,10664,10665,10666,10667,10668,10669,10670,10671,10672,10673,10674,10675,10676,10677,10678,10679,10680,10681,10682,10683,10684,10685,10686,10687,10688,10689,10690,10691,10692,10693,10694,10695,10696,10697,10698,10699,10700,10701,10702,10703,10704,10705,10706,10707,10708,10709,10710,10711,10712,10713,10714,10715,10716,10717,10718,10719,10720,10721,10722,10723,10724,10725,10726,10727,10728,10729,10730,10731,10732,10733,10734,10735,10736,10737,10738,10739,10740,10741,10742,10743,10744,10745,10746,10747,10748,10749,10750,10751,10752,10753,10754,10755,10756,10757,10758,10759,10760,10761,10762,10763,10764,10765,10766,10767,10768,10769,10770,10771,10772,10773,10774,10775,10776,10777,10778,10779,10780,10781,10782,10783,10784,10785,10786,10787,10788,10789,10790,10791,10792,10793,10794,10795,10796,10797,10798,10799,10800,10801,10802,10803,10804,10805,10806,10807,10808,10809,10810,10814,10815,10816,10817,10818,10819,10820,10821,10822,10823,10824,10825,10826,10827,10828,10829,10830,10831,10835,10836,10837,10838,10839,10845,10846,10847,10848,10849,10850,10851,10852,10853,10854,10855,10856,10857,10860,10861,10862,10863,10866,10867,10868,10869,10870,10871,10872,10874,10875,10876,10877,10882,10883,10892,10895,10897,10898,10899,10900,10903,10909,10919,10920,10921,10922,10923,10924,10925,10926,10927,10928,10929,10930,10931,10932,10933,10934,10935,10936,10937,10938,10939,10941,10944,10945,10946,10947,10948,10949,10951,10952,10953,10957,10958,10959,10960,10963,10964,10965,10966,10968,10970,10975,10976,10978,10979,10980,10981,10982,10983,10993,10994,10995,10996,10997,10998,10999,11000,11004,11009,11010,11011,11012,11013,11014,11015,11016,11017,11019,10913,10914,10915,10916,10917,10918,11053,11054,11055,11056,11057,11058,11059,11060,11061,11062,11063,11064,11065,11066,11067,11068,11069,11070,11071,11072,11073,11074,11075,11076,11077,11078,11079,11080,11081,11082,11083,11084,11085,11086,11087,11088,11089,11090,11091,11092,11093,11094,11095,11096,11097,11098,11099,11100,11104,11105,11106,11107,11108,11109,11110,11111,11112,11113,11114,11115,11116,11117,11118,11119,11120,11121,11122,11123,11124,11125,11126,11127,11128,11129,11130,11131,11132,11133,11134,11135,11136,11137,11138,11139,11140,11141,11142,11143,11144,11145,11146,11147,11148,11149,11150,11151,11152,11153,11154,11155,11156,11157,11158,11159,11160,11161,11162,11163,11164,11165,11166,11167,11168,11169,11172,11176,11178,11180,11182,11183,11184,11185,11186,11187,11188,11189,11190,11191,11192,11193,11194,11195,11196,11197,11198,11199,11200,11201,11202,11203,11204,11205,11206,11207,11208,11209,11210,11211,11212,11213,11214,11215,11216,11225,11226,11227,11228,11229,11230,11233,11234,11235,11236,11237,11238,11239,11240,11241,11242,11243,11244,11245,11246,11247,11248,11249,11250,11251,11270,11271,11272,11273,11274,11275,11276,11277,11278,11279,11280,11281,11282,11283,11284,11285,11286,11354,11355,11356,11357,11358,11359,11360,11361,11362,11363,11364,11365,11366,11367,11368,11369,11370,11371,11372,11373,11374,11375,11376,11377,11378,11379,11380,11381,11382,11414,11415,11416,11417,11418,11419,11420,11421,11422,11423,11424,11425,11426,11427,11428,11429,11430,11431,11432,11433,11434,11435,11436,11437,11438,11439,11288,11289,11290,11291,11292,11293,11294,11295,11296,11297,11298,11299,11300,11301,11302,11303,11304,11305,11306,11307,11308,11309,11310,11311,11312,11313,11314,11315,11316,11317,11318,11319,11320,11321,11322,11323,11324,11325,11326,11327,11328,11329,11331,11332,11333,11334,11336,11338,11339,11340,11341,11342,11343,11344,11345,11346,11347,11348,11349,11350,11351,11352,11353,11444,11446,11447,11449,11451,11452,11464,11465,11466,11467,11468,11469,11470,11471,11472,11473,11474,11475,11476,11477,11478,11479,11480,11481,11482,11483,11484,11485,11486,11487,11488,11489,11490,11491,11492,11494,11495,11496,11497,11498,11499,11501,11502,11509,11510,11511,11512,11513,11514,11515,11516,11517,11518,11519,11520,11521,11522,11523,11524,11525,11526,11527,11528,11529,11530,11531,11532,11533,11534,11535,11536,11537,11538,11539,11540,11541,11542,11543,11561,11562,11563,11564,11565,11566,11567,11568,11569,11570,11571,11572,11573,11574,11575,11576,11577,11578,11579,11580,11587,11588,11592,11594,11595,11596,11597,11598,11599,11600,11601,11602,11603,11604,11605,11606,11607,11608,11609,11610,11611,11612,11613,11614,11615,11616,11617,11618,11619,11620,11621,11622,11623,11624,11625,11627,11628,11629,11630,11631,11632,11633,11634,11635,11636,11637,11638,11639,11640,11641,11642,11651,11655,11656,11657,11658,11659,11660,11667,11668,11669,11670,11671,11672,11673,11674,11675,11676,11677,11678,11679,11680,11681,11682,11683,11684,11685,11686,11687,11688,11689,11691,11692,11693,11694,11695,11699,11700,11701,11705,11707,11708,11716,11546,11547,11548,11734,11735,11736,11737,11738,11739,11740,11741,11742,11743,11744,11745,11746,11747,11748,11749,11750,11751,11752,11753,11754,11755,11756,11757,11758,11759,11760,11761,11762,11763,11764,11765,11766,11767,11768,11769,11770,11771,11772,11773,11774,11775,11776,11777,11778,11779,11780,11781,11782,11783,11784,11785,11786,11787,11788,11789,11790,11791,11792,11793,11794,11795,11796,11797,11798,11799,11800,11801,11802,11803,11804,11805,11806,11807,11808,11809,11810,11811,11812,11813,11814,11815,11816,11817,11818,11819,11820,11821,11822,11823,11824,11825,11826,11827,11828,11829,11830,11831,11832,11833,11836,11837,11838,11839,11840,11841,11842,11843,11844,11845,11846,11847,11848,11849,11850,11851,11852,11853,11854,11855,11856,11857,11858,11859,11550,11551,11552,11553,11554,11555,11556,11557,11558,11559,11560,11861,11863,11866,11869,11873,11877,11878,11879,11880,11886,11887,11888,11892,11894,11895,11898,11899,11900,11901,11905,11906,11907,11908,11909,11910,11912,11913,11914,11915,11916,11917,11919,11920,11921,11922,11923,11924,11925,11926,11927,11929,11930,11931,11932,11933,11934,11935,11936,11940,11941,11942,11945,11946,11947,11949,11950,11951,11952,11953,11954,11955,11957,11958,11959,11963,11965,11966,11967,11968,11969,12016,12017,12018,12020,12024,12027,12028,12031,12035,12038,12043,12045,12047,12051,12065,12067,12071,12075,12079,12082,12083,12084,12085,12086,12089,12090,12091,12093,12095,12096,12099,12100,12101,12102,12103,12104,12107,12108,12109,12110,12111,12112,12113,12115,12116,12117,12118,12120,12121,12122,12123,12124,12125,12126,12127,12128,12129,12130,12133,12134,12135,12137,12140,12141,12142,12144,12145,12146,12147,12149,12151,12153,12155,12156,12157,12158,12159,12160,12161,12162,12163,12164,12165,12168,12173,12176,12178,12183,12185,12188,12192,12197,12198,12199,12200,12202,12205,12206,12207,12208,12209,12210,12211,12212,12213,12214,12216,12219,12221,12222,12229,12230,12231,12232,12233,12234,12235,12236,12238,12239,12241,12242,12243,12244,12245,12246,12247,12248,12249,12250,12251,12252,12253,12254,12255,12256,12257,12258,12259,12260,12261,12262,12263,12264,12265,12266,12267,12268,12269,12270,12271,12272,12273,12274,12275,12276,12277,12278,12279,12280,12288,12289,12290,12293,12294,12297,12298,12300,12307,12312,12317,12322,12328,12335,12340,12350,12352,12353,12354,12356,12357,12358,12360,12361,12362,12363,12364,12366,12367,12368,12370,12374,12375,12376,12378,12380,12381,12382,12384,12386,12387,12389,12391,12392,12393,12394,12396,12397,12399,12401,12403,12404,12405,12406,12407,12408,12409,12410,12411,12414,12415,12416,12418,12419,12420,12422,12424,12425,11644,11645,11646,11647,11648,11649,12426,12429,12430,12431,12432,12436,12439,12443,12444,12445,12446,12447,12451,12452,12455,12456,12457,12458,12464,12465,12466,12467,12473,12474,12475,12476,12478,12480,12482,12483,12484,12489,12490,12491,12493,12494,12495,12496,12498,12499,12500,12503,12504,12505,12507,12508,12509,12510,12512,12513,12514,12515,12516,12517,12518,12519,12520,12521,12522,12523,12524,12525,12526,12527,12528,12529,12530,12531,12532,12533,12534,12535,12536,12537,12538,12539,12540,12541,12542,12543,12544,12545,12546,12547,12548,12549,12550,12551,12553,12554,12555,12556,12557,12558,12559,12560,12561,12562,12563,12564,12565,12566,12567,12568,12569,12570,12571,12572,12573,12574,12575,12576,12577,12578,12579,12580,12581,12582,12583,12584,12585,12586,12587,12588,12589,12611,12612,12613,12614,12615,12616,12617,12618,12620,12621,12622,12623,12624,12625,12626,12627,12628,12629,12630,12631,12632,12633,12634,12635,12636,12637,12638,12639,12640,12641,12642,12643,12644,12645,12646,12647,12648,12649,12650,12651,12652,12653,12654,12655,12656,12657,12658,12659,12660,12661,12662,12663,13733,12664,12665,12666,12667,12668,12669,12670,12671,12672,12673,12674,12675,12676,12678,12680,12681,12682,12683,12684,12685,12687,12688,12689,12690,12592,12593,12691,12692,12693,12694,12695,12696,12697,12698,12699,12700,12701,12702,12703,12704,12705,12706,12707,12708,12709,12710,12711,12595,12596,12597,12598,12599,12600,12601,12610,12712,12713,12714,12715,12716,12717,12718,12719,12720,12721,12722,12723,12724,13700,13701,12725,12726,12727,12728,12729,12730,12731,12732,12733,12734,12735,12736,13702,13703,13704,12737,12738,12739,12740,12741,12742,12743,12744,13705,13706,13707,13708,13709,13710,13711,12745,12746,12747,12748,12750,12751,12752,13712,13713,13714,13715,13716,13717,13718,12753,15454,12754,12755,15457,12756,12760,12761,12763,12765,12766,12767,12768,12769,12770,12771,12772,12773,12774,12775,12776,12777,13719,13720,13721,13722,12778,12779,12780,12781,12782,13723,13724,13725,13727,13728,13729,13730,13731,13732,12783,12784,12785,12786,12787,12788,12789,12790,12791,12792,12793,12794,12795,12796,12797,12798,12799,12800,12801,12802,12803,12804,12805,12806,12807,12808,12809,12810,12811,12812,12813,12814,12815,12828,12829,12830,12831,12832,12833,12834,12835,12836,12837,12902,12903,12904,12905,12906,12907,12908,12909,12910,12911,12912,12922,12923,12924,12925,12926,12927,12928,12929,12930,12931,12932,12933,12934,12935,12936,12937,12938,12939,12940,12941,12942,12943,12944,12945,12946,12947,12948,12949,12950,12951,12952,12953,12954,12955,12956,12957,12958,12959,12960,12961,12962,12963,12964,12965,12966,12967,12968,12969,12970,12971,12972,12973,12974,12975,12976,12977,13001,13002,13003,13004,13005,13006,13007,13008,13009,13010,13011,13012,13013,13014,13015,13016,13017,13018,13019,13020,13021,13022,13023,13024,13025,13026,13027,13028,13029,13030,13031,13032,13033,13034,13035,13036,13037,13040,13041,13042,13043,13044,13045,13046,13047,13048,13049,13050,13051,13052,13053,13054,13055,13056,13057,13058,13059,13060,13061,13062,13063,13064,13065,13066,13067,13068,13069,13070,13071,13072,13073,13074,13075,13076,13077,13078,13079,13080,13081,13082,13083,13088,13089,13090,13091,13092,13093,13094,13095,13096,13097,13098,13099,13100,13101,13103,13104,13105,13106,13107,13108,13109,13110,13111,13112,13113,13114,13115,13116,13117,13118,13119,13120,13121,13122,13123,13124,13125,13126,13127,13128,13131,13132,13133,13134,13135,13136,13137,13138,13139,13140,13141,13142,13143,13145,13146,13147,13148,13149,13150,13151,13152,13153,13154,13155,13156,13157,13158,13159,13160,13161,13162,13163,13164,13165,13166,13167,13168,13169,13170,13171,13172,13173,13174,13175,13176,13177,13178,13179,13180,13181,13182,13183,13184,13185,13186,13187,13188,13189,13190,13191,13192,13193,13194,13195,13196,13197,13198,13199,13200,13201,13202,13203,13204,13205,13206,13207,13208,13209,13210,13211,13212,13213,13214,13215,13216,13217,13218,13220,13222,13224,13225,13226,13227,13228,13229,13235,13236,13237,13238,13239,13240,13241,13242,13243,13232,13233,13234,13244,13245,13246,13247,13248,13249,13250,13251,13252,13253,13254,13255,13256,13257,13258,13259,13260,13261,13262,13263,13264,13265,13266,13267,13268,13269,13270,13271,13272,13273,13274,13275,13276,13277,13278,13279,13280,13281,13282,13283,13284,13285,13286,13287,13288,13289,13290,13291,13292,13293,13294,13295,13296,13297,13298,13299,13300,13301,13302,13303,13304,13305,13306,13307,13308,13309,13310,13311,13312,13313,13314,13315,13316,13317,13318,13319,13320,13321,13322,13323,13324,13325,13326,13327,13328,13329,13330,13331,13332,13333,13334,13335,13336,13337,13338,13339,13340,13341,13342,13343,13344,13345,13346,13347,13348,13349,13350,13351,13352,13353,13354,13355,13356,13357,13358,13359,13360,13361,13362,13363,13364,13365,13366,13367,13368,13369,13370,13371,13372,13373,13374,13375,13376,13377,13378,13379,13380,13381,13382,13383,13384,13385,13386,13387,13388,13389,13390,13391,13392,13393,13394,13395,13396,13397,13398,13399,13400,13401,13402,13403,13404,13405,13406,13407,13408,13409,13410,13411,13412,13413,13414,13415,13416,13417,13418,13419,13420,13421,13422,13423,13424,13425,13426,13427,13428,13429,13430,13431,13432,13433,13434,13435,13436,13437,13438,13439,13440,13441,13442,13443,13444,13445,13446,13447,13448,13449,13450,13451,13452,13453,13454,13455,13456,13457,13458,13459,13460,13461,13462,13463,13464,13465,13466,13467,13468,13469,13470,13471,13472,13473,13474,13475,13476,13477,13478,13479,13480,13481,13482,13483,13484,13485,13486,13487,13488,13489,13490,13491,13492,13493,13494,13495,13496,13497,13498,13499,13500,13501,13502,13503,13504,13505,13506,13507,13508,13509,13510,13511,13512,13513,13514,13515,13516,13517,13518,13519,13520,13521,13522,13523,13524,13525,13526,13527,13528,13529,13530,13531,13532,13533,13534,13535,13536,13537,13538,13539,13540,13541,13542,13543,13544,13545,13546,13547,13548,13549,13550,13551,13552,13553,13554,13555,13556,13557,13558,13559,13560,13561,13562,13563,13564,13565,13566,13567,13568,13569,13570,13571,13572,13573,13574,13575,13576,13577,13578,13579,13580,13581,13582,13583,13584,13585,13586,13587,13588,13589,13590,13591,13592,13593,13594,13595,13596,13597,13598,13599,13600,13601,13602,13603,13604,13605,13606,13607,13608,13609,13610,13611,13612,13613,13614,13615,13616,13617,13618,13619,13620,13621,13622,13623,13624,13625,13626,13627,13628,13629,13630,13631,13632,13633,13634,13635,13636,13637,13638,13639,13640,13641,13642,13643,13644,13645,13646,13647,13648,13649,13650,13651,13652,13653,13654,13655,13656,13657,13658,13659,13660,13661,13662,13663,13664,13665,13666,13667,13668,13669,13670,13671,13672,13673,13674,13675,13676,13677,13678,13679,13680,13681,13682,13683,13684,13685,13686,13687,13688,13689,13690,13691,13692,13693,13694,13695,13696,13697,13698), OR:msProduct.id:IN(9569,9570,9572,9575,9576,9578,9579,9580,9581,9582,9583,9584,9585,9586,9587,9588,9589,9590,9591,9592,9593,9594,9595,9596,9597,9598,9599,9602,9604,9605,9606,9607,9608,9609,9610,9612,9613,9614,9615,9616,9617,9618,9619,9620,9621,9622,9623,9625,9626,9627,9628,9629,9630,9631,9632,9633,9634,9635,9637,9638,9639,9640,9641,9642,9643,9644,9645,9646,9647,9648,9649,9650,9651,9652,9653,9654,9655,9656,9657,9658,9659,9660,9661,9673,9674,9675,9677,9678,9679,9680,9681,9682,9683,9684,9685,9686,9687,9688,9689,9690,9691,9692,9693,9694,9695,9696,9697,9698,9699,9700,9701,9702,9703,9704,9706,9707,9708,9709,9711,9712,9714,9715,9717,9718,9719,9720,9721,9722,9723,9724,9725,9726,9727,9729,9730,9731,9732,9733,9734,9735,9736,9737,9738,9739,9740,9741,9742,9743,9744,9745,9746,9747,9748,9749,9750,9751,9753,9756,9759,9761,9765,9766,9768,9770,9772,9774,9775,9777,9778,9780,9782,9783,9784,9785,9786,9787,9788,9789,9791,9793,9795,9797,9799,9801,9803,9805,9807,9809,9810,9810,9811,9811,9812,9812,9813,9813,9814,9814,9815,9815,9816,9816,9817,9817,9818,9818,9819,9819,9820,9820,9821,9821,9822,9822,9823,9823,9824,9824,9825,9825,9826,9826,9827,9827,9828,9828,9829,9829,9830,9830,9831,9831,9832,9832,9833,9833,9834,9834,9835,9835,9836,9836,9837,9837,9838,9838,9839,9839,9840,9840,9841,9841,9842,9842,9843,9843,9844,9844,9845,9845,9846,9846,9847,9847,9848,9848,9849,9849,9850,9850,9851,9851,9852,9852,9853,9853,9854,9854,9855,9855,9856,9856,9857,9857,9858,9858,9859,9859,9860,9860,9861,9861,9862,9862,9863,9863,9864,9864,9865,9865,9866,9866,9867,9867,9868,9868,9869,9869,9870,9870,9871,9871,9872,9872,9873,9873,9877,9880,9881,9882,9883,9884,9885,9886,9887,9888,9889,9890,9891,9892,9893,9894,9895,9896,9897,9898,9899,9900,9901,9902,9903,9904,9905,9906,9910,9911,9917,9919,9921,9927,9930,9932,9935,9937,9938,9942,9945,9946,9949,9950,9953,9954,9955,9957,9962,9965,9966,9968,9969,9970,9993,9994,9995,9997,9998,9999,10000,10003,10004,10005,10006,10007,10008,10009,10010,10011,10013,10014,10015,10016,10017,10018,10019,10020,10021,10022,10023,10025,10027,10028,10029,10030,10031,10032,10033,10034,10035,10036,10037,10038,10039,10040,10041,10042,10043,10044,10045,10046,10047,10048,10049,10050,10051,10052,10052,10053,10053,10054,10054,10055,10055,10056,10056,10057,10057,10058,10058,10059,10059,10060,10060,10061,10061,10062,10062,10063,10063,10064,10064,10065,10066,10069,10070,10075,10076,10081,10083,10090,10091,10096,10097,10098,10099,10101,10103,10107,10111,10113,10115,10117,10121,10123,10125,10126,10129,10130,10131,10133,10134,10135,10136,10137,10138,10139,10140,10141,10143,10144,10145,10146,10147,10148,10149,10150,10151,10152,10153,10154,10156,10157,10158,10159,10160,10161,10162,10163,10164,10165,10166,10167,10168,10170,10171,10172,10187,10187,10188,10188,10189,10189,10190,10190,10191,10191,10192,10192,10193,10193,10194,10194,10195,10195,10196,10196,10197,10197,10198,10198,10199,10199,10200,10200,10201,10201,10202,10202,10203,10203,10204,10204,10205,10205,10206,10206,10207,10207,10208,10208,10209,10209,10210,10210,10211,10211,10212,10212,10213,10213,10214,10214,10215,10215,10216,10216,10217,10217,10218,10218,10219,10219,10220,10220,10221,10221,10254,10255,10256,10257,10258,10259,10260,10261,10262,10263,10264,10265,10266,10267,10268,10269,10270,10271,10272,10273,10274,10275,10276,10277,10278,10279,10280,10281,10282,10283,10284,10285,10286,10287,10288,10289,10290,10291,10292,10293,10294,10295,10296,10297,10298,10299,10300,10301,10302,10303,10304,10305,10306,10307,10308,10309,10310,10311,10312,10313,10314,10315,10316,10317,10318,10319,10320,10321,10322,10323,10324,10325,10326,10327,10328,10329,10330,10331,10332,10333,10334,10335,10336,10337,10338,10339,10340,10341,10342,10343,10344,10345,10346,10347,10348,10349,10350,10351,10352,10353,10354,10355,10356,10357,10359,10360,10361,10362,10363,10364,10365,10366,10367,10368,10385,10387,10389,10391,10393,10395,10397,10399,10401,10403,10405,10407,10408,10409,10410,10411,10413,10414,10415,10416,10417,10418,10420,10421,10422,10423,10424,10425,10426,10427,10428,10430,10433,10434,10435,10437,10438,10439,10440,10441,10442,10443,10444,10445,10446,10447,10448,10449,10450,10451,10452,10454,10455,10456,10457,10458,10459,10460,10461,10462,10463,10464,10465,10466,10467,10468,10469,10470,10471,10472,10473,10475,10476,10477,10478,10479,10480,10481,10482,10483,10484,10485,10486,10487,10488,10489,10490,10491,10492,10493,10494,10495,10496,10499,10500,10501,10502,10504,10505,10506,10507,10508,10509,10510,10511,10512,10513,10514,10515,10516,10517,10518,10519,10520,10521,10522,10523,10524,10525,10526,10527,10528,10529,10530,10531,10535,10537,10541,10544,10547,10549,10555,10556,10557,10558,10559,10560,10561,10562,10563,10564,10565,10566,10567,10568,10569,10570,10571,10572,10573,10574,10575,10576,10577,10578,10579,10580,10581,10582,10583,10584,10585,10586,10587,10588,10589,10590,10591,10592,10593,10594,10595,10596,10597,10598,10599,10600,10601,10602,10603,10604,10605,10606,10607,10608,10609,10610,10611,10612,10613,10614,10615,10616,10617,10618,10619,10620,10621,10622,10623,10624,10625,10626,10627,10628,10629,10630,10631,10632,10633,10634,10635,10636,10637,10638,10639,10640,10641,10642,10643,10644,10645,10646,10647,10648,10649,10650,10651,10652,10653,10654,10655,10656,10657,10658,10659,10660,10661,10662,10663,10664,10665,10666,10667,10668,10669,10670,10671,10672,10673,10674,10675,10676,10677,10678,10679,10680,10681,10682,10683,10684,10685,10686,10687,10688,10689,10690,10691,10692,10693,10694,10695,10696,10697,10698,10699,10700,10701,10702,10703,10704,10705,10706,10707,10708,10709,10710,10711,10712,10713,10714,10715,10716,10717,10718,10719,10720,10721,10722,10723,10724,10725,10726,10727,10728,10729,10730,10731,10732,10733,10734,10735,10736,10737,10738,10739,10740,10741,10742,10743,10744,10745,10746,10747,10748,10749,10750,10751,10752,10753,10754,10755,10756,10757,10758,10759,10760,10761,10762,10763,10764,10765,10766,10767,10768,10769,10770,10771,10772,10773,10774,10775,10776,10777,10778,10779,10780,10781,10782,10783,10784,10785,10786,10787,10788,10789,10790,10791,10792,10793,10794,10795,10796,10797,10798,10799,10800,10801,10802,10803,10804,10805,10806,10807,10808,10809,10810,10814,10815,10816,10817,10818,10819,10820,10821,10822,10823,10824,10825,10826,10827,10828,10829,10830,10831,10835,10836,10837,10838,10839,10845,10846,10847,10848,10849,10850,10851,10852,10853,10854,10855,10856,10857,10860,10861,10862,10863,10866,10867,10868,10869,10870,10871,10872,10874,10875,10876,10877,10882,10883,10892,10895,10897,10898,10899,10900,10903,10909,10919,10920,10921,10922,10923,10924,10925,10926,10927,10928,10929,10930,10931,10932,10933,10934,10935,10936,10937,10938,10939,10941,10944,10945,10946,10947,10948,10949,10951,10952,10953,10957,10958,10959,10960,10963,10964,10965,10966,10968,10970,10975,10976,10978,10979,10980,10981,10982,10983,10993,10994,10995,10996,10997,10998,10999,11000,11004,11009,11010,11011,11012,11013,11014,11015,11016,11017,11019,11053,11053,11054,11054,11055,11055,11056,11056,11057,11057,11058,11058,11059,11059,11060,11060,11061,11061,11062,11062,11063,11064,11064,11065,11065,11066,11066,11067,11067,11068,11068,11069,11069,11070,11070,11071,11071,11072,11072,11073,11073,11074,11074,11075,11075,11076,11076,11077,11077,11078,11078,11079,11079,11080,11080,11081,11081,11082,11082,11083,11083,11084,11084,11085,11085,11086,11086,11087,11087,11088,11088,11089,11089,11090,11090,11091,11091,11092,11092,11093,11093,11094,11094,11095,11095,11096,11096,11097,11097,11098,11098,11099,11099,11100,11100,11104,11104,11105,11105,11106,11106,11107,11107,11108,11108,11109,11109,11110,11110,11111,11111,11112,11112,11113,11113,11114,11114,11115,11115,11116,11116,11117,11117,11118,11118,11119,11119,11120,11120,11121,11121,11122,11122,11123,11123,11124,11124,11125,11125,11126,11126,11127,11127,11128,11128,11129,11129,11130,11130,11131,11131,11132,11132,11133,11133,11134,11134,11135,11135,11136,11136,11137,11137,11138,11138,11139,11139,11140,11140,11141,11141,11142,11142,11143,11143,11144,11144,11145,11145,11146,11146,11147,11147,11148,11148,11149,11149,11150,11150,11151,11151,11152,11152,11153,11153,11154,11154,11155,11155,11156,11156,11157,11157,11158,11158,11159,11159,11160,11160,11161,11161,11162,11162,11163,11163,11164,11164,11165,11165,11166,11166,11167,11167,11168,11168,11169,11169,11172,11172,11176,11176,11178,11178,11180,11180,11182,11182,11183,11183,11184,11184,11185,11185,11186,11186,11187,11187,11188,11188,11189,11189,11190,11190,11191,11191,11192,11192,11193,11193,11194,11194,11195,11195,11196,11196,11197,11197,11198,11198,11199,11199,11200,11200,11201,11201,11202,11202,11203,11203,11204,11204,11205,11205,11206,11206,11207,11207,11208,11208,11209,11209,11210,11210,11211,11211,11212,11212,11213,11213,11214,11214,11215,11215,11216,11216,11225,11226,11227,11228,11229,11230,11233,11234,11235,11236,11237,11238,11239,11240,11241,11242,11243,11244,11245,11246,11247,11248,11249,11250,11251,11270,11271,11272,11273,11274,11275,11276,11277,11278,11279,11280,11281,11282,11283,11284,11285,11286,11288,11289,11290,11291,11292,11293,11294,11295,11296,11297,11298,11299,11300,11301,11302,11303,11304,11305,11306,11307,11308,11309,11310,11311,11312,11313,11314,11315,11316,11317,11318,11319,11320,11321,11322,11323,11324,11325,11326,11327,11328,11329,11331,11332,11333,11334,11336,11338,11339,11340,11341,11342,11343,11344,11345,11346,11347,11348,11349,11350,11351,11352,11353,11354,11355,11356,11357,11358,11359,11360,11361,11362,11363,11364,11365,11366,11367,11368,11369,11370,11371,11372,11373,11374,11375,11376,11377,11378,11379,11380,11381,11382,11414,11415,11416,11417,11418,11419,11420,11421,11422,11423,11424,11425,11426,11427,11428,11429,11430,11431,11432,11433,11434,11435,11436,11437,11438,11439,11444,11446,11447,11449,11451,11452,11464,11465,11466,11467,11468,11469,11470,11471,11472,11473,11474,11475,11476,11477,11478,11479,11480,11481,11482,11483,11484,11485,11486,11487,11488,11489,11490,11491,11492,11494,11495,11496,11497,11498,11499,11501,11502,11509,11510,11511,11512,11513,11514,11515,11516,11517,11518,11519,11520,11521,11522,11523,11524,11525,11526,11527,11528,11529,11530,11531,11532,11533,11534,11535,11536,11537,11538,11539,11540,11561,11562,11563,11564,11565,11566,11567,11568,11569,11570,11571,11572,11573,11574,11575,11576,11577,11578,11579,11580,11587,11588,11592,11594,11595,11596,11597,11598,11599,11600,11601,11602,11603,11604,11605,11606,11607,11608,11609,11610,11611,11612,11613,11614,11615,11616,11617,11618,11619,11620,11621,11622,11623,11624,11625,11627,11628,11629,11630,11631,11632,11633,11634,11635,11636,11637,11638,11639,11640,11641,11642,11651,11655,11656,11657,11658,11659,11660,11667,11668,11669,11670,11671,11672,11673,11674,11675,11676,11677,11678,11679,11680,11681,11682,11683,11684,11685,11686,11687,11688,11689,11691,11692,11693,11694,11695,11699,11700,11701,11705,11707,11708,11716,11734,11735,11736,11737,11738,11739,11740,11741,11742,11743,11744,11745,11746,11747,11748,11749,11750,11751,11752,11753,11754,11755,11756,11757,11758,11759,11760,11761,11762,11763,11764,11765,11766,11767,11768,11769,11770,11771,11772,11773,11774,11775,11776,11777,11778,11779,11780,11781,11782,11783,11784,11785,11786,11787,11788,11789,11790,11791,11792,11793,11794,11795,11796,11797,11798,11799,11800,11801,11802,11803,11804,11805,11806,11807,11808,11809,11810,11811,11812,11813,11814,11815,11816,11817,11818,11819,11820,11821,11822,11823,11824,11825,11826,11827,11828,11829,11830,11831,11832,11833,11836,11837,11838,11839,11840,11841,11842,11843,11844,11845,11846,11847,11848,11849,11850,11851,11852,11853,11854,11855,11856,11857,11858,11859,11861,11863,11866,11869,11873,11877,11878,11879,11880,11886,11887,11888,11892,11894,11895,11898,11899,11900,11901,11905,11906,11907,11908,11909,11910,11912,11913,11914,11915,11916,11917,11919,11920,11921,11922,11923,11924,11925,11926,11927,11929,11930,11931,11932,11933,11934,11935,11936,11940,11941,11942,11945,11946,11947,11949,11950,11951,11952,11953,11954,11955,11957,11958,11959,11963,11965,11966,11967,11968,11969,12016,12017,12018,12020,12024,12027,12028,12031,12035,12038,12043,12045,12047,12051,12065,12067,12071,12075,12079,12082,12083,12084,12085,12086,12089,12090,12091,12093,12095,12096,12099,12100,12101,12102,12103,12104,12107,12108,12109,12110,12111,12112,12113,12115,12116,12117,12118,12120,12121,12122,12123,12124,12125,12126,12127,12128,12129,12130,12133,12134,12135,12137,12140,12141,12142,12144,12145,12146,12147,12149,12151,12153,12155,12156,12157,12158,12159,12160,12161,12162,12163,12164,12165,12168,12173,12176,12178,12183,12185,12188,12192,12197,12198,12199,12200,12202,12205,12206,12207,12208,12209,12210,12211,12212,12213,12214,12216,12219,12221,12222,12229,12230,12231,12232,12233,12234,12235,12236,12238,12239,12241,12242,12243,12244,12245,12246,12247,12248,12249,12250,12251,12252,12253,12254,12255,12256,12257,12258,12259,12260,12261,12262,12263,12264,12265,12266,12267,12268,12269,12270,12271,12272,12273,12274,12275,12276,12277,12278,12279,12280,12288,12289,12290,12293,12294,12297,12298,12300,12307,12312,12317,12322,12328,12335,12340,12350,12352,12353,12354,12356,12357,12358,12360,12361,12362,12363,12364,12366,12367,12368,12370,12374,12375,12376,12378,12380,12381,12382,12384,12386,12387,12389,12391,12392,12393,12394,12396,12397,12399,12401,12403,12404,12405,12406,12407,12408,12409,12410,12411,12414,12415,12416,12418,12419,12420,12422,12424,12425,12426,12429,12430,12431,12432,12436,12439,12443,12445,12446,12447,12451,12452,12455,12456,12457,12458,12464,12465,12466,12467,12473,12474,12475,12476,12478,12480,12482,12483,12484,12489,12490,12491,12493,12494,12495,12496,12498,12499,12500,12503,12504,12505,12507,12508,12509,12510,12512,12513,12514,12515,12516,12517,12518,12519,12520,12521,12522,12523,12524,12525,12526,12527,12528,12529,12530,12531,12532,12533,12534,12535,12536,12537,12538,12539,12540,12541,12542,12543,12544,12545,12546,12547,12548,12549,12550,12551,12553,12554,12555,12556,12557,12558,12559,12560,12561,12562,12563,12564,12565,12566,12567,12568,12569,12570,12571,12572,12573,12574,12575,12576,12577,12578,12579,12580,12581,12582,12583,12584,12585,12586,12587,12588,12589,12611,12612,12613,12614,12615,12616,12617,12618,12620,12621,12622,12623,12624,12625,12626,12627,12628,12629,12630,12631,12632,12633,12634,12635,12636,12637,12638,12639,12640,12641,12642,12643,12644,12645,12646,12647,12648,12649,12650,12651,12652,12653,12654,12655,12656,12657,12658,12659,12660,12661,12662,12663,12664,12665,12666,12667,12668,12669,12670,12671,12672,12673,12674,12675,12676,12678,12680,12681,12682,12683,12684,12685,12687,12688,12689,12690,12691,12692,12693,12694,12695,12696,12697,12698,12699,12700,12701,12702,12703,12704,12705,12706,12707,12708,12709,12710,12711,12712,12713,12714,12715,12716,12717,12718,12719,12720,12721,12722,12723,12724,12725,12726,12727,12728,12729,12730,12731,12732,12733,12734,12735,12736,12737,12738,12739,12740,12741,12742,12743,12744,12745,12746,12747,12748,12750,12751,12752,12753,12754,12755,12756,12760,12761,12763,12765,12766,12767,12768,12769,12770,12771,12772,12773,12774,12775,12776,12777,12778,12779,12780,12781,12782,12783,12784,12785,12786,12787,12788,12789,12790,12791,12792,12793,12794,12795,12796,12797,12798,12799,12800,12801,12802,12803,12804,12805,12806,12807,12808,12809,12810,12811,12812,12813,12814,12815,12825,12825,12826,12826,12838,12838,12839,12839,12840,12840,12841,12841,12842,12842,12843,12843,12844,12844,12845,12845,12846,12846,12847,12847,12848,12849,12849,12850,12850,12851,12851,12852,12852,12853,12853,12854,12854,12855,12855,12856,12856,12857,12857,12858,12858,12859,12859,12860,12860,12861,12861,12862,12862,12863,12863,12864,12864,12869,12869,12870,12870,12871,12871,12872,12872,12873,12873,12874,12874,12875,12875,12876,12876,12877,12877,12878,12878,12879,12879,12880,12880,12881,12881,12882,12882,12883,12883,12884,12884,12885,12885,12886,12886,12887,12887,12888,12888,12889,12889,12890,12890,12891,12891,12892,12892,12893,12893,12894,12894,12895,12895,12896,12896,12897,12897,12898,12898,12899,12899,12900,12900,12901,12901,12902,12903,12904,12905,12906,12907,12908,12909,12910,12911,12912,12918,12918,12918,12919,12919,12919,12920,12920,12920,12921,12921,12921,12922,12923,12924,12925,12926,12927,12928,12929,12930,12931,12932,12933,12934,12935,12936,12937,12938,12939,12940,12941,12942,12943,12944,12945,12946,12947,12948,12949,12950,12951,12952,12953,12954,12955,12956,12957,12958,12959,12960,12961,12962,12963,12964,12965,12966,12967,12968,12969,12970,12971,12972,12973,12974,12975,12976,12977,13001,13002,13003,13004,13006,13007,13008,13009,13010,13011,13012,13013,13014,13015,13016,13017,13018,13019,13020,13021,13022,13023,13024,13025,13026,13027,13028,13029,13030,13031,13032,13033,13034,13035,13036,13037,13040,13041,13042,13043,13044,13045,13046,13047,13048,13049,13050,13051,13052,13053,13054,13055,13056,13057,13058,13059,13060,13061,13062,13063,13064,13065,13066,13067,13068,13069,13070,13071,13072,13073,13074,13075,13076,13077,13078,13079,13080,13081,13082,13083,13088,13089,13090,13091,13092,13093,13094,13095,13096,13097,13098,13099,13100,13101,13103,13104,13105,13106,13107,13108,13109,13110,13111,13112,13113,13114,13115,13116,13117,13118,13119,13120,13121,13122,13123,13124,13125,13126,13127,13128,13131,13132,13133,13134,13135,13136,13137,13138,13139,13140,13141,13142,13143,13145,13146,13147,13148,13149,13150,13151,13152,13153,13154,13155,13156,13157,13158,13159,13160,13161,13162,13163,13164,13165,13166,13167,13168,13169,13170,13171,13172,13173,13174,13175,13176,13177,13178,13179,13180,13181,13182,13183,13184,13185,13186,13187,13188,13189,13190,13191,13192,13193,13194,13195,13196,13197,13198,13199,13200,13201,13202,13203,13204,13205,13206,13207,13208,13209,13210,13211,13212,13213,13214,13215,13216,13217,13218,13220,13222,13224,13225,13226,13227,13228,13229,13244,13245,13246,13247,13248,13249,13250,13251,13252,13253,13254,13255,13256,13257,13258,13259,13260,13261,13262,13263,13264,13265,13266,13267,13268,13269,13270,13271,13272,13273,13274,13275,13276,13277,13278,13279,13280,13281,13282,13283,13284,13285,13286,13287,13288,13289,13290,13291,13292,13293,13294,13295,13296,13297,13298,13299,13300,13301,13302,13303,13304,13305,13306,13307,13308,13309,13310,13311,13312,13313,13314,13315,13316,13317,13318,13319,13320,13321,13322,13323,13324,13325,13326,13327,13328,13329,13330,13331,13332,13333,13334,13335,13336,13337,13338,13339,13340,13341,13342,13343,13344,13345,13346,13347,13348,13349,13350,13351,13352,13353,13354,13355,13356,13357,13358,13359,13360,13361,13362,13363,13364,13365,13366,13367,13368,13369,13370,13371,13372,13373,13374,13375,13376,13377,13378,13379,13380,13381,13382,13383,13384,13385,13386,13387,13388,13389,13390,13391,13392,13393,13394,13395,13396,13397,13398,13399,13400,13401,13402,13403,13404,13405,13406,13407,13408,13409,13410,13411,13412,13413,13414,13415,13416,13417,13418,13419,13420,13421,13422,13423,13424,13425,13426,13427,13428,13429,13430,13431,13432,13433,13434,13435,13436,13437,13438,13439,13440,13441,13442,13443,13444,13445,13446,13447,13448,13449,13450,13451,13452,13453,13454,13455,13456,13457,13458,13459,13460,13461,13462,13463,13464,13465,13466,13467,13468,13469,13470,13471,13472,13473,13474,13475,13476,13477,13478,13479,13480,13481,13482,13483,13484,13485,13486,13487,13488,13489,13490,13491,13492,13493,13494,13495,13496,13497,13498,13499,13500,13501,13502,13503,13504,13505,13506,13507,13508,13509,13510,13511,13512,13513,13514,13515,13516,13517,13518,13519,13520,13521,13522,13523,13524,13525,13526,13527,13528,13529,13530,13531,13532,13533,13534,13535,13536,13537,13538,13539,13540,13541,13542,13543,13544,13545,13546,13547,13548,13549,13550,13551,13552,13553,13554,13555,13556,13557,13558,13559,13560,13561,13562,13563,13564,13565,13566,13567,13568,13569,13570,13571,13572,13573,13574,13575,13576,13577,13578,13579,13580,13581,13582,13583,13584,13585,13586,13587,13588,13589,13590,13591,13592,13593,13594,13595,13596,13597,13598,13599,13600,13601,13602,13603,13604,13605,13606,13607,13608,13609,13610,13611,13612,13613,13614,13615,13616,13617,13618,13619,13620,13621,13622,13623,13624,13625,13626,13627,13628,13629,13630,13631,13632,13633,13634,13635,13636,13637,13638,13639,13640,13641,13642,13643,13644,13645,13646,13647,13648,13649,13650,13651,13652,13653,13654,13655,13656,13657,13658,13659,13660,13661,13662,13663,13664,13665,13666,13667,13668,13669,13670,13671,13672,13673,13674,13675,13676,13677,13678,13679,13680,13681,13682,13683,13684,13685,13686,13687,13688,13689,13690,13691,13692,13693,13694,13695,13696,13697,13698,13701,13702,13707,13712,13713,13714,13715,13716,13717,13718,13719,13720,13721,13722,13723,13724,13725,13727,13728,13729,13730,13731,13732,14223,14223,15060), msProduct.published=1, msProduct.deleted=0
    0.0001011: Sorted by RAND(), ASC
    0.0000060: Limited to 4, offset 0
    0.0010271: SQL prepared 
    "SELECT SQL_CALC_FOUND_ROWS `msProduct`.`id`, `msProduct`.`type`, `msProduct`.`contentType`, `msProduct`.`pagetitle`, `msProduct`.`longtitle`, `msProduct`.`description`, `msProduct`.`alias`, `msProduct`.`link_attributes`, `msProduct`.`published`, `msProduct`.`pub_date`, `msProduct`.`unpub_date`, `msProduct`.`parent`, `msProduct`.`isfolder`, `msProduct`.`introtext`, `msProduct`.`richtext`, `msProduct`.`template`, `msProduct`.`menuindex`, `msProduct`.`searchable`, `msProduct`.`cacheable`, `msProduct`.`createdby`, `msProduct`.`createdon`, `msProduct`.`editedby`, `msProduct`.`editedon`, `msProduct`.`deleted`, `msProduct`.`deletedon`, `msProduct`.`deletedby`, `msProduct`.`publishedon`, `msProduct`.`publishedby`, `msProduct`.`menutitle`, `msProduct`.`donthit`, `msProduct`.`privateweb`, `msProduct`.`privatemgr`, `msProduct`.`content_dispo`, `msProduct`.`hidemenu`, `msProduct`.`class_key`, `msProduct`.`context_key`, `msProduct`.`content_type`, `msProduct`.`uri`, `msProduct`.`uri_override`, `msProduct`.`hide_children_in_tree`, `msProduct`.`show_in_tree`, `msProduct`.`properties`, `Data`.`article`, `Data`.`price`, `Data`.`old_price`, `Data`.`weight`, `Data`.`image`, `Data`.`thumb`, `Data`.`vendor`, `Data`.`made_in`, `Data`.`new`, `Data`.`popular`, `Data`.`favorite`, `Data`.`tags`, `Data`.`color`, `Data`.`size`, `Data`.`source`, `Vendor`.`name` AS `vendor.name`, `Vendor`.`resource` AS `vendor.resource`, `Vendor`.`country` AS `vendor.country`, `Vendor`.`logo` AS `vendor.logo`, `Vendor`.`address` AS `vendor.address`, `Vendor`.`phone` AS `vendor.phone`, `Vendor`.`fax` AS `vendor.fax`, `Vendor`.`email` AS `vendor.email`, `Vendor`.`description` AS `vendor.description`, `Vendor`.`properties` AS `vendor.properties`, `120x90`.`url` as `120x90` FROM `modx_site_content` AS `msProduct` LEFT JOIN `modx_ms2_products` `Data` ON `msProduct`.`id`=`Data`.`id` LEFT JOIN `modx_ms2_vendors` `Vendor` ON `Data`.`vendor`=`Vendor`.`id` LEFT JOIN `modx_ms2_product_files` `120x90` ON `120x90`.`product_id` = `msProduct`.`id` AND `120x90`.`parent` != 0 AND `120x90`.`path` LIKE '%/120x90/' WHERE  ( `msProduct`.`class_key` = 'msProduct' AND `Data`.`favorite` = '1' AND  ( `msProduct`.`parent` IN (9557,10550,11544,11549,12827,12594,11545,12591,11643,13231,13230,9558,9662,9663,9668,9669,9670,9671,9672,12816,9569,9570,9572,9575,9576,9577,9578,9579,9580,9581,9582,9583,9584,9585,9586,9587,9588,9589,9590,9591,9592,9593,9594,9595,9596,9597,9598,9599,9602,9604,9605,9606,9607,9608,9609,9610,9612,9613,9614,9615,9616,9617,9618,9619,9620,9621,9622,9623,9625,9626,9627,9628,9629,9630,9631,9632,9633,9634,9635,9636,9637,9638,9639,9640,9641,9642,9643,9644,9645,9646,9647,9648,9649,9650,9651,9652,9653,9654,9655,9656,9657,9658,9659,9660,9661,9673,9674,9675,9677,9678,9679,9680,9681,9682,9683,9684,9685,9686,9687,9688,9689,9690,9691,9692,9693,9694,9695,9696,9697,9698,9699,9700,9701,9702,9703,9704,9706,9707,9708,9709,9711,9712,9714,9715,9717,9718,9719,9720,9721,9722,9723,9724,9725,9726,9727,9729,9730,9731,9732,9733,9734,9735,9736,9737,9738,9739,9740,9741,9742,9743,9744,9745,9746,9747,9748,9749,9750,9751,9753,9756,9759,9761,9765,9766,9768,9770,9772,9774,9775,9777,9778,9780,9993,9994,9995,9997,9998,9999,10000,10003,10004,10005,10006,10007,10008,10009,10010,10011,10013,10014,10015,10016,10017,10018,10019,10020,10021,10022,10023,10025,10027,10028,10029,10030,10031,10032,10033,10034,10035,10036,10037,10038,10039,10040,10041,10042,10043,10044,10045,10046,10047,10048,10049,10050,10051,9784,9785,9786,9787,9788,9789,9791,9793,9795,9797,9799,9801,9803,9805,9807,9809,10385,10387,10389,10391,10393,10395,10397,10399,10401,10403,10405,10407,10408,10409,10410,10411,10413,10414,10415,10416,10417,10418,10420,10421,10422,10423,10424,10425,10426,10427,10428,10430,10432,10433,10434,10435,10437,10438,10439,10440,10441,10442,10443,10444,10445,10446,10447,10448,10449,10450,10451,10452,10454,10455,10456,10457,10458,10459,10460,10461,10462,10463,10464,10465,10466,10467,10468,10469,10470,10471,10472,10473,10475,10476,10477,10478,10479,10480,10481,10482,10483,10484,10485,10486,10487,10488,10489,10490,10491,10492,10493,10494,10495,10496,10497,10499,10500,10501,10502,10504,10505,10506,10507,10508,10509,10510,10511,10512,10513,10514,10515,10517,10518,10519,10520,10521,10522,10523,10524,10525,10526,10527,10528,10529,10530,10531,10535,10537,10541,10544,10547,10549,10516,9664,9665,9666,9667,9810,9811,9812,9813,9814,9815,9816,9817,9818,9819,9820,9821,9822,9823,9824,9825,9826,9827,9828,9829,9830,10052,10053,10054,10055,10056,10057,10058,10059,10060,10061,10062,10063,10064,9831,9832,9833,9834,9835,9836,9837,9838,9839,9840,9841,9842,9843,9844,9845,9846,9847,9848,9849,9850,9851,9852,9853,9854,9855,9856,9857,9858,9859,9860,9861,9862,9863,9864,9865,9866,9867,9868,9869,9870,9871,9872,9873,10187,10188,10189,10190,10191,10192,10193,10194,10195,10196,10197,10198,10199,10200,10201,10202,10203,10204,10205,10206,10207,10208,10209,10210,10211,10212,10213,10214,10215,10216,10217,10218,10219,10220,10221,9930,9932,9935,9937,9938,9942,9945,9946,9949,10101,10103,10107,10111,10113,10115,10117,10121,10123,10125,10126,10129,10130,10131,10133,10134,10135,10136,10137,10138,10139,10140,10141,10143,10144,10145,10146,10147,10148,10149,10150,10151,10152,10153,10154,10156,10157,10158,10159,10160,10161,10162,10163,10164,10165,10166,10167,10168,10169,10170,10171,10172,9950,9953,9954,9955,9957,9962,9965,9966,9968,9969,9970,10353,10354,10355,10356,10357,10359,10360,10361,10362,10363,10364,10365,10366,10367,10368,9910,9911,9917,9919,9921,9927,9928,10065,10066,10069,10070,10075,10076,10081,10083,10090,10091,10096,10097,10098,10099,9877,9880,9881,9882,9883,9884,9885,9886,9887,9888,9889,9890,9891,9892,9893,9894,9895,9896,9897,9898,9899,9900,9901,9902,9903,9904,9905,9906,10254,10255,10256,10257,10258,10259,10260,10261,10262,10263,10264,10265,10266,10267,10268,10269,10270,10271,10272,10273,10274,10275,10276,10277,10278,10279,10280,10281,10282,10283,10284,10285,10286,10287,10288,10289,10290,10291,10292,10293,10294,10295,10296,10297,10298,10299,10300,10301,10302,10303,10304,10305,10306,10307,10308,10309,10310,10311,10312,10313,10314,10315,10316,10317,10318,10319,10320,10321,10322,10323,10324,10325,10326,10327,10328,10329,10330,10331,10332,10333,10334,10335,10336,10337,10338,10339,10340,10341,10342,10343,10344,10345,10346,10347,10348,10349,10350,10351,10352,12818,12819,12820,12821,12825,12826,12838,12839,12840,12841,12842,12843,12844,12845,12846,12847,12848,12849,12850,12851,12852,12853,12854,12855,12856,12857,12858,12859,12860,12861,12862,12863,12864,12869,12870,12871,12872,12873,12874,12875,12876,12877,12878,12879,12880,12881,12882,12883,12884,12885,12886,12887,12888,12889,12890,12891,12892,12893,12894,12895,12896,12897,12898,12899,12900,12901,12822,12823,12918,12919,12920,12921,10551,10552,10553,10554,10910,10911,10912,11217,11218,11224,11219,11220,11221,11222,11223,10555,10556,10557,10558,10559,10560,10561,10562,10563,10564,10565,10566,10567,10568,10569,10570,10571,10572,10573,10574,10575,10576,10577,10578,10579,10580,10581,10582,10583,10584,10585,10586,10587,10588,10589,10590,10591,10592,10593,10594,10595,10596,10597,10598,10599,10600,10601,10602,10603,10604,10605,10606,10607,10608,10609,10610,10611,10612,10613,10614,10615,10616,10617,10618,10619,10620,10621,10622,10623,10624,10625,10626,10627,10628,10629,10630,10631,10632,10633,10634,10635,10636,10637,10638,10639,10640,10641,10642,10643,10644,10645,10646,10647,10648,10649,10650,10651,10652,10653,10654,10655,10656,10657,10658,10659,10660,10661,10662,10663,10664,10665,10666,10667,10668,10669,10670,10671,10672,10673,10674,10675,10676,10677,10678,10679,10680,10681,10682,10683,10684,10685,10686,10687,10688,10689,10690,10691,10692,10693,10694,10695,10696,10697,10698,10699,10700,10701,10702,10703,10704,10705,10706,10707,10708,10709,10710,10711,10712,10713,10714,10715,10716,10717,10718,10719,10720,10721,10722,10723,10724,10725,10726,10727,10728,10729,10730,10731,10732,10733,10734,10735,10736,10737,10738,10739,10740,10741,10742,10743,10744,10745,10746,10747,10748,10749,10750,10751,10752,10753,10754,10755,10756,10757,10758,10759,10760,10761,10762,10763,10764,10765,10766,10767,10768,10769,10770,10771,10772,10773,10774,10775,10776,10777,10778,10779,10780,10781,10782,10783,10784,10785,10786,10787,10788,10789,10790,10791,10792,10793,10794,10795,10796,10797,10798,10799,10800,10801,10802,10803,10804,10805,10806,10807,10808,10809,10810,10814,10815,10816,10817,10818,10819,10820,10821,10822,10823,10824,10825,10826,10827,10828,10829,10830,10831,10835,10836,10837,10838,10839,10845,10846,10847,10848,10849,10850,10851,10852,10853,10854,10855,10856,10857,10860,10861,10862,10863,10866,10867,10868,10869,10870,10871,10872,10874,10875,10876,10877,10882,10883,10892,10895,10897,10898,10899,10900,10903,10909,10919,10920,10921,10922,10923,10924,10925,10926,10927,10928,10929,10930,10931,10932,10933,10934,10935,10936,10937,10938,10939,10941,10944,10945,10946,10947,10948,10949,10951,10952,10953,10957,10958,10959,10960,10963,10964,10965,10966,10968,10970,10975,10976,10978,10979,10980,10981,10982,10983,10993,10994,10995,10996,10997,10998,10999,11000,11004,11009,11010,11011,11012,11013,11014,11015,11016,11017,11019,10913,10914,10915,10916,10917,10918,11053,11054,11055,11056,11057,11058,11059,11060,11061,11062,11063,11064,11065,11066,11067,11068,11069,11070,11071,11072,11073,11074,11075,11076,11077,11078,11079,11080,11081,11082,11083,11084,11085,11086,11087,11088,11089,11090,11091,11092,11093,11094,11095,11096,11097,11098,11099,11100,11104,11105,11106,11107,11108,11109,11110,11111,11112,11113,11114,11115,11116,11117,11118,11119,11120,11121,11122,11123,11124,11125,11126,11127,11128,11129,11130,11131,11132,11133,11134,11135,11136,11137,11138,11139,11140,11141,11142,11143,11144,11145,11146,11147,11148,11149,11150,11151,11152,11153,11154,11155,11156,11157,11158,11159,11160,11161,11162,11163,11164,11165,11166,11167,11168,11169,11172,11176,11178,11180,11182,11183,11184,11185,11186,11187,11188,11189,11190,11191,11192,11193,11194,11195,11196,11197,11198,11199,11200,11201,11202,11203,11204,11205,11206,11207,11208,11209,11210,11211,11212,11213,11214,11215,11216,11225,11226,11227,11228,11229,11230,11233,11234,11235,11236,11237,11238,11239,11240,11241,11242,11243,11244,11245,11246,11247,11248,11249,11250,11251,11270,11271,11272,11273,11274,11275,11276,11277,11278,11279,11280,11281,11282,11283,11284,11285,11286,11354,11355,11356,11357,11358,11359,11360,11361,11362,11363,11364,11365,11366,11367,11368,11369,11370,11371,11372,11373,11374,11375,11376,11377,11378,11379,11380,11381,11382,11414,11415,11416,11417,11418,11419,11420,11421,11422,11423,11424,11425,11426,11427,11428,11429,11430,11431,11432,11433,11434,11435,11436,11437,11438,11439,11288,11289,11290,11291,11292,11293,11294,11295,11296,11297,11298,11299,11300,11301,11302,11303,11304,11305,11306,11307,11308,11309,11310,11311,11312,11313,11314,11315,11316,11317,11318,11319,11320,11321,11322,11323,11324,11325,11326,11327,11328,11329,11331,11332,11333,11334,11336,11338,11339,11340,11341,11342,11343,11344,11345,11346,11347,11348,11349,11350,11351,11352,11353,11444,11446,11447,11449,11451,11452,11464,11465,11466,11467,11468,11469,11470,11471,11472,11473,11474,11475,11476,11477,11478,11479,11480,11481,11482,11483,11484,11485,11486,11487,11488,11489,11490,11491,11492,11494,11495,11496,11497,11498,11499,11501,11502,11509,11510,11511,11512,11513,11514,11515,11516,11517,11518,11519,11520,11521,11522,11523,11524,11525,11526,11527,11528,11529,11530,11531,11532,11533,11534,11535,11536,11537,11538,11539,11540,11541,11542,11543,11561,11562,11563,11564,11565,11566,11567,11568,11569,11570,11571,11572,11573,11574,11575,11576,11577,11578,11579,11580,11587,11588,11592,11594,11595,11596,11597,11598,11599,11600,11601,11602,11603,11604,11605,11606,11607,11608,11609,11610,11611,11612,11613,11614,11615,11616,11617,11618,11619,11620,11621,11622,11623,11624,11625,11627,11628,11629,11630,11631,11632,11633,11634,11635,11636,11637,11638,11639,11640,11641,11642,11651,11655,11656,11657,11658,11659,11660,11667,11668,11669,11670,11671,11672,11673,11674,11675,11676,11677,11678,11679,11680,11681,11682,11683,11684,11685,11686,11687,11688,11689,11691,11692,11693,11694,11695,11699,11700,11701,11705,11707,11708,11716,11546,11547,11548,11734,11735,11736,11737,11738,11739,11740,11741,11742,11743,11744,11745,11746,11747,11748,11749,11750,11751,11752,11753,11754,11755,11756,11757,11758,11759,11760,11761,11762,11763,11764,11765,11766,11767,11768,11769,11770,11771,11772,11773,11774,11775,11776,11777,11778,11779,11780,11781,11782,11783,11784,11785,11786,11787,11788,11789,11790,11791,11792,11793,11794,11795,11796,11797,11798,11799,11800,11801,11802,11803,11804,11805,11806,11807,11808,11809,11810,11811,11812,11813,11814,11815,11816,11817,11818,11819,11820,11821,11822,11823,11824,11825,11826,11827,11828,11829,11830,11831,11832,11833,11836,11837,11838,11839,11840,11841,11842,11843,11844,11845,11846,11847,11848,11849,11850,11851,11852,11853,11854,11855,11856,11857,11858,11859,11550,11551,11552,11553,11554,11555,11556,11557,11558,11559,11560,11861,11863,11866,11869,11873,11877,11878,11879,11880,11886,11887,11888,11892,11894,11895,11898,11899,11900,11901,11905,11906,11907,11908,11909,11910,11912,11913,11914,11915,11916,11917,11919,11920,11921,11922,11923,11924,11925,11926,11927,11929,11930,11931,11932,11933,11934,11935,11936,11940,11941,11942,11945,11946,11947,11949,11950,11951,11952,11953,11954,11955,11957,11958,11959,11963,11965,11966,11967,11968,11969,12016,12017,12018,12020,12024,12027,12028,12031,12035,12038,12043,12045,12047,12051,12065,12067,12071,12075,12079,12082,12083,12084,12085,12086,12089,12090,12091,12093,12095,12096,12099,12100,12101,12102,12103,12104,12107,12108,12109,12110,12111,12112,12113,12115,12116,12117,12118,12120,12121,12122,12123,12124,12125,12126,12127,12128,12129,12130,12133,12134,12135,12137,12140,12141,12142,12144,12145,12146,12147,12149,12151,12153,12155,12156,12157,12158,12159,12160,12161,12162,12163,12164,12165,12168,12173,12176,12178,12183,12185,12188,12192,12197,12198,12199,12200,12202,12205,12206,12207,12208,12209,12210,12211,12212,12213,12214,12216,12219,12221,12222,12229,12230,12231,12232,12233,12234,12235,12236,12238,12239,12241,12242,12243,12244,12245,12246,12247,12248,12249,12250,12251,12252,12253,12254,12255,12256,12257,12258,12259,12260,12261,12262,12263,12264,12265,12266,12267,12268,12269,12270,12271,12272,12273,12274,12275,12276,12277,12278,12279,12280,12288,12289,12290,12293,12294,12297,12298,12300,12307,12312,12317,12322,12328,12335,12340,12350,12352,12353,12354,12356,12357,12358,12360,12361,12362,12363,12364,12366,12367,12368,12370,12374,12375,12376,12378,12380,12381,12382,12384,12386,12387,12389,12391,12392,12393,12394,12396,12397,12399,12401,12403,12404,12405,12406,12407,12408,12409,12410,12411,12414,12415,12416,12418,12419,12420,12422,12424,12425,11644,11645,11646,11647,11648,11649,12426,12429,12430,12431,12432,12436,12439,12443,12444,12445,12446,12447,12451,12452,12455,12456,12457,12458,12464,12465,12466,12467,12473,12474,12475,12476,12478,12480,12482,12483,12484,12489,12490,12491,12493,12494,12495,12496,12498,12499,12500,12503,12504,12505,12507,12508,12509,12510,12512,12513,12514,12515,12516,12517,12518,12519,12520,12521,12522,12523,12524,12525,12526,12527,12528,12529,12530,12531,12532,12533,12534,12535,12536,12537,12538,12539,12540,12541,12542,12543,12544,12545,12546,12547,12548,12549,12550,12551,12553,12554,12555,12556,12557,12558,12559,12560,12561,12562,12563,12564,12565,12566,12567,12568,12569,12570,12571,12572,12573,12574,12575,12576,12577,12578,12579,12580,12581,12582,12583,12584,12585,12586,12587,12588,12589,12611,12612,12613,12614,12615,12616,12617,12618,12620,12621,12622,12623,12624,12625,12626,12627,12628,12629,12630,12631,12632,12633,12634,12635,12636,12637,12638,12639,12640,12641,12642,12643,12644,12645,12646,12647,12648,12649,12650,12651,12652,12653,12654,12655,12656,12657,12658,12659,12660,12661,12662,12663,13733,12664,12665,12666,12667,12668,12669,12670,12671,12672,12673,12674,12675,12676,12678,12680,12681,12682,12683,12684,12685,12687,12688,12689,12690,12592,12593,12691,12692,12693,12694,12695,12696,12697,12698,12699,12700,12701,12702,12703,12704,12705,12706,12707,12708,12709,12710,12711,12595,12596,12597,12598,12599,12600,12601,12610,12712,12713,12714,12715,12716,12717,12718,12719,12720,12721,12722,12723,12724,13700,13701,12725,12726,12727,12728,12729,12730,12731,12732,12733,12734,12735,12736,13702,13703,13704,12737,12738,12739,12740,12741,12742,12743,12744,13705,13706,13707,13708,13709,13710,13711,12745,12746,12747,12748,12750,12751,12752,13712,13713,13714,13715,13716,13717,13718,12753,15454,12754,12755,15457,12756,12760,12761,12763,12765,12766,12767,12768,12769,12770,12771,12772,12773,12774,12775,12776,12777,13719,13720,13721,13722,12778,12779,12780,12781,12782,13723,13724,13725,13727,13728,13729,13730,13731,13732,12783,12784,12785,12786,12787,12788,12789,12790,12791,12792,12793,12794,12795,12796,12797,12798,12799,12800,12801,12802,12803,12804,12805,12806,12807,12808,12809,12810,12811,12812,12813,12814,12815,12828,12829,12830,12831,12832,12833,12834,12835,12836,12837,12902,12903,12904,12905,12906,12907,12908,12909,12910,12911,12912,12922,12923,12924,12925,12926,12927,12928,12929,12930,12931,12932,12933,12934,12935,12936,12937,12938,12939,12940,12941,12942,12943,12944,12945,12946,12947,12948,12949,12950,12951,12952,12953,12954,12955,12956,12957,12958,12959,12960,12961,12962,12963,12964,12965,12966,12967,12968,12969,12970,12971,12972,12973,12974,12975,12976,12977,13001,13002,13003,13004,13005,13006,13007,13008,13009,13010,13011,13012,13013,13014,13015,13016,13017,13018,13019,13020,13021,13022,13023,13024,13025,13026,13027,13028,13029,13030,13031,13032,13033,13034,13035,13036,13037,13040,13041,13042,13043,13044,13045,13046,13047,13048,13049,13050,13051,13052,13053,13054,13055,13056,13057,13058,13059,13060,13061,13062,13063,13064,13065,13066,13067,13068,13069,13070,13071,13072,13073,13074,13075,13076,13077,13078,13079,13080,13081,13082,13083,13088,13089,13090,13091,13092,13093,13094,13095,13096,13097,13098,13099,13100,13101,13103,13104,13105,13106,13107,13108,13109,13110,13111,13112,13113,13114,13115,13116,13117,13118,13119,13120,13121,13122,13123,13124,13125,13126,13127,13128,13131,13132,13133,13134,13135,13136,13137,13138,13139,13140,13141,13142,13143,13145,13146,13147,13148,13149,13150,13151,13152,13153,13154,13155,13156,13157,13158,13159,13160,13161,13162,13163,13164,13165,13166,13167,13168,13169,13170,13171,13172,13173,13174,13175,13176,13177,13178,13179,13180,13181,13182,13183,13184,13185,13186,13187,13188,13189,13190,13191,13192,13193,13194,13195,13196,13197,13198,13199,13200,13201,13202,13203,13204,13205,13206,13207,13208,13209,13210,13211,13212,13213,13214,13215,13216,13217,13218,13220,13222,13224,13225,13226,13227,13228,13229,13235,13236,13237,13238,13239,13240,13241,13242,13243,13232,13233,13234,13244,13245,13246,13247,13248,13249,13250,13251,13252,13253,13254,13255,13256,13257,13258,13259,13260,13261,13262,13263,13264,13265,13266,13267,13268,13269,13270,13271,13272,13273,13274,13275,13276,13277,13278,13279,13280,13281,13282,13283,13284,13285,13286,13287,13288,13289,13290,13291,13292,13293,13294,13295,13296,13297,13298,13299,13300,13301,13302,13303,13304,13305,13306,13307,13308,13309,13310,13311,13312,13313,13314,13315,13316,13317,13318,13319,13320,13321,13322,13323,13324,13325,13326,13327,13328,13329,13330,13331,13332,13333,13334,13335,13336,13337,13338,13339,13340,13341,13342,13343,13344,13345,13346,13347,13348,13349,13350,13351,13352,13353,13354,13355,13356,13357,13358,13359,13360,13361,13362,13363,13364,13365,13366,13367,13368,13369,13370,13371,13372,13373,13374,13375,13376,13377,13378,13379,13380,13381,13382,13383,13384,13385,13386,13387,13388,13389,13390,13391,13392,13393,13394,13395,13396,13397,13398,13399,13400,13401,13402,13403,13404,13405,13406,13407,13408,13409,13410,13411,13412,13413,13414,13415,13416,13417,13418,13419,13420,13421,13422,13423,13424,13425,13426,13427,13428,13429,13430,13431,13432,13433,13434,13435,13436,13437,13438,13439,13440,13441,13442,13443,13444,13445,13446,13447,13448,13449,13450,13451,13452,13453,13454,13455,13456,13457,13458,13459,13460,13461,13462,13463,13464,13465,13466,13467,13468,13469,13470,13471,13472,13473,13474,13475,13476,13477,13478,13479,13480,13481,13482,13483,13484,13485,13486,13487,13488,13489,13490,13491,13492,13493,13494,13495,13496,13497,13498,13499,13500,13501,13502,13503,13504,13505,13506,13507,13508,13509,13510,13511,13512,13513,13514,13515,13516,13517,13518,13519,13520,13521,13522,13523,13524,13525,13526,13527,13528,13529,13530,13531,13532,13533,13534,13535,13536,13537,13538,13539,13540,13541,13542,13543,13544,13545,13546,13547,13548,13549,13550,13551,13552,13553,13554,13555,13556,13557,13558,13559,13560,13561,13562,13563,13564,13565,13566,13567,13568,13569,13570,13571,13572,13573,13574,13575,13576,13577,13578,13579,13580,13581,13582,13583,13584,13585,13586,13587,13588,13589,13590,13591,13592,13593,13594,13595,13596,13597,13598,13599,13600,13601,13602,13603,13604,13605,13606,13607,13608,13609,13610,13611,13612,13613,13614,13615,13616,13617,13618,13619,13620,13621,13622,13623,13624,13625,13626,13627,13628,13629,13630,13631,13632,13633,13634,13635,13636,13637,13638,13639,13640,13641,13642,13643,13644,13645,13646,13647,13648,13649,13650,13651,13652,13653,13654,13655,13656,13657,13658,13659,13660,13661,13662,13663,13664,13665,13666,13667,13668,13669,13670,13671,13672,13673,13674,13675,13676,13677,13678,13679,13680,13681,13682,13683,13684,13685,13686,13687,13688,13689,13690,13691,13692,13693,13694,13695,13696,13697,13698) OR `msProduct`.`id`            
      Wassi Wassinen
      13 апреля 2014, 18:06
      -1
      Что-то я тут ничего не понял. :) Мой статус падавана силу блокирует, тёмная сторона меня манит.
        Василий Наумкин
        13 апреля 2014, 18:10
        0
        1. Используй тег code или pre.
        2. Выдишь в логе слово «error»? Вот и я не вижу, значит сниппет работает без ошибок.
        3. Чтобы все подряд ресурсы не попадали в родителей и выборка не тормозила, есть параметр depth.

        Ну наконец, в заметке спрашиваешь про popular, а в логе у тебя
        0.1008649: Added where condition: class_key=msProduct, Data.favorite=1
        
        Popular и favorite — разные поля. Скорее всего, у тебя просто нет товаров с favorite=1.
          Wassi Wassinen
          13 апреля 2014, 18:24
          0
          Василий, ты уж прости. :)) Видимо глаз до того «замылился», что без джедайского вмешательства не обойтись. :)) Не знаю, как я так проморгал. У приятеля, действительно, проставлены favorite. Многого тебе терпения и выдержки. :))
    Авторизуйтесь или зарегистрируйтесь, чтобы оставлять комментарии.
    5