SELECT
SQL_CALC_FOUND_ROWS products.product_id,
IF(
shared_descr.product_id IS NOT NULL,
shared_descr.product, descr1.product
) as product,
companies.company as company_name,
products.product_type,
products.parent_product_id
FROM
cscart_products as products
LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id
AND descr1.lang_code = 'en'
LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id
AND prices.lower_limit = 1
LEFT JOIN cscart_companies AS companies ON companies.company_id = products.company_id
INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id
INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id
AND (
cscart_categories.usergroup_ids = ''
OR FIND_IN_SET(
0, cscart_categories.usergroup_ids
)
OR FIND_IN_SET(
1, cscart_categories.usergroup_ids
)
)
AND cscart_categories.status IN ('A', 'H')
AND cscart_categories.storefront_id IN (0, 1)
LEFT JOIN cscart_ult_product_descriptions shared_descr ON shared_descr.product_id = products.product_id
AND shared_descr.company_id = 1
AND shared_descr.lang_code = 'en'
LEFT JOIN cscart_product_restricted_countries AS prc ON prc.product_id = products.product_id
AND prc.country_code = 'US'
WHERE
1
AND companies.status IN ('A')
AND (
products.usergroup_ids = ''
OR FIND_IN_SET(0, products.usergroup_ids)
OR FIND_IN_SET(1, products.usergroup_ids)
)
AND products.status IN ('A')
AND prices.usergroup_id IN (0, 0, 1)
AND (
products.available_worldwide = 'Y'
OR prc.country_code IS NULL
)
AND products.product_id IN (
45389,
45391,
45392,
45393,
45394,
45395,
45397,
45399,
45400,
45401,
45402,
45403,
45404,
45405,
45406,
45407,
45408,
45409,
45410,
45412,
45413,
45414,
45415,
45416,
45417,
45418,
45419,
45456,
45457,
45458,
45459,
45461,
45462,
45463,
45464,
45465,
45466,
45467,
45468,
45469,
45470,
45472,
45474,
45475,
45476,
45477,
45478,
45479,
45480,
45481,
45482,
45483,
45484,
45485,
45849,
45816,
45817,
45818,
45819,
45820,
45821,
45822,
45824,
45825,
45826,
45827,
45828,
45829,
45830,
45831,
45832,
45834,
45835,
45836,
45837,
45838,
45840,
45841,
45842,
45843,
45844,
45845,
45846,
45847,
45848,
45893,
45895,
45896,
45897,
45898,
45899,
45900,
45901,
45902,
45903,
45904,
45905,
45906,
45907,
45908,
45909,
45910,
45911,
45912,
45913,
45915,
45916,
45918,
45919,
45920,
45921,
45922,
45923,
45390,
45396,
45398,
45411,
45931,
45932,
45934,
45935,
45936,
45939,
45940,
45941,
45942,
45943,
45944,
45945,
45947,
45948,
45949,
45950,
45951,
45975,
45976,
45977,
45978,
45979,
45980,
45982,
45983,
45984,
45985,
45986,
45987,
45988,
45989,
45990,
45991,
45992,
45993,
45994,
45995,
45998,
45999,
46000,
46001,
46002,
46003,
46004,
46005,
45455,
45460,
45471,
45473,
45937,
45938,
45946,
45933,
46220,
46190,
46191,
46192,
46193,
46194,
46195,
46196,
46197,
46198,
46199,
46201,
46202,
46203,
46204,
46205,
46206,
46207,
46208,
46209,
46210,
46211,
46212,
46213,
46215,
46216,
46217,
46218,
46219,
45823,
45833,
45839,
46479,
46480,
46482,
46483,
46484,
46485,
46486,
46487,
46488,
46489,
46490,
46491,
46492,
46493,
46494,
46495,
46496,
46497,
46498,
46499,
46500,
46501,
46502,
46503,
46504,
46505,
46507,
46508,
45917,
45914,
45894,
45981,
45997,
45996,
46709,
46710,
46712,
46713,
46714,
46715,
46716,
46718,
46719,
46720,
46721,
46722,
46723,
46724,
46725,
46727,
46728,
46730,
46731,
46732,
46733,
46734,
46735,
46736,
46737,
46738,
46739,
46823,
46824,
46825,
46827,
46828,
46829,
46830,
46831,
46832,
46833,
46834,
46835,
46836,
46838,
46840,
46841,
46842,
46845,
46846,
46847,
46848,
46849,
46851,
46852,
46853,
46854,
46855,
46856,
46214,
46200,
46481,
46506,
47146,
47147,
47148,
47149,
47150,
47151,
47152,
47153,
47154,
47155,
47156,
47157,
47158,
47159,
47160,
47163,
47164,
47165,
47166,
47167,
47168,
47169,
47170,
47172,
47173,
47174,
47175,
46711,
46726,
46729,
46717,
47348,
46839,
46844,
46843,
46837,
46826,
46850,
47171,
47162,
47161,
47145,
47311,
47315,
47314,
47316,
47317,
47318,
47319,
47320,
47321,
47322,
47323,
47324,
47325,
47326,
47327,
47328,
47329,
47330,
47331,
47332,
47333,
47336,
47337,
47338,
47339,
47340,
47341,
47342,
47343,
47344,
47346,
47347,
47312,
47335,
47334,
47313,
47651,
47652,
47653,
47654,
47655,
47656,
47657,
47658,
47659,
47660,
47663,
47664,
47665,
47666,
47667,
47669,
47670,
47672,
47673,
47674,
47676,
47677,
47678,
47679,
47680,
47661,
47650,
47662,
47668,
47893,
47894,
47896,
47897,
47898,
47899,
47901,
47902,
47903,
47904,
47906,
47907,
47908,
47909,
47910,
47911,
47912,
47913,
47914,
47915,
47916,
47917,
47918,
47919,
47920,
47921,
47922,
47923,
47895,
47900,
47905,
48202,
48203,
48204,
48205,
48206,
48207,
48208,
48210,
48211,
48212,
48213,
48214,
48215,
48216,
48217,
48218,
48220,
48221,
48222,
48223,
48225,
48226,
48227,
48228,
48230,
48232,
48466,
48231,
48229,
48224,
48219,
48209,
48437,
48438,
48440,
48443,
48444,
48445,
48446,
48447,
48448,
48449,
48451,
48452,
48454,
48457,
48458,
48459,
48460,
48461,
48462,
48463,
48464,
48465,
48436,
48441,
48453,
48455,
47675,
47671,
47345,
52171,
52172,
52173,
52174,
52175,
52176,
52177,
52178,
52179,
52180,
52182,
52183,
52184,
52185,
52186,
52187,
52188,
52190,
52191,
52192,
52193,
52194,
52195,
52196,
52198,
52199,
52200,
53813,
53814,
53815,
53816,
53817,
53818,
53819,
53821,
53823,
53824,
53825,
53826,
53827,
53828,
53829,
53830,
53831,
53832,
53833,
53834,
53835,
53837,
53838,
53839,
53840,
53841,
53842,
53843,
53844,
53847,
53848,
53849,
53850,
53851,
53852,
53853,
53854,
53855,
53856,
53857,
53858,
53859,
53860,
53861,
53862,
53863,
53864,
53866,
53868,
53869,
53870,
53871,
53872,
53873,
53874,
54288,
54289,
54290,
54291,
54293,
54296,
54297,
54298,
54299,
54300,
54301,
54303,
54304,
54305,
54306,
54307,
54308,
54309,
54310,
54311,
54312,
54313,
54314,
54315,
54316,
54317,
54334,
54335,
54336,
54337,
54338,
54340,
54342,
54343,
54344,
54345,
54346,
54348,
54349,
54350,
54351,
54352,
54353,
54354,
54355,
54356,
54357,
54358,
54359,
54360,
54361,
54362,
54363,
48456,
48442,
52181,
52189,
52197,
48439,
48450,
54479,
54480,
54481,
54483,
54484,
54485,
54486,
54487,
54488,
54489,
54490,
54491,
54492,
54493,
54494,
54495,
54496,
54497,
54499,
54500,
54501,
54502,
54503,
54504,
54506,
54508,
54294,
54673,
54674,
54675,
54677,
54678,
54679,
54680,
54681,
54682,
54683,
54684,
54685,
54686,
54687,
54688,
54689,
54690,
54691,
54692,
54693,
54694,
54695,
54696,
54697,
54698,
54699,
54701,
54702,
54703,
54704,
54705,
54796,
54797,
54799,
54801,
54802,
54803,
54804,
54805,
54807,
54808,
54809,
54811,
54812,
54813,
54814,
54815,
54816,
54817,
54819,
55003,
55004,
55005,
55006,
55007,
55008,
55009,
55010,
55011,
55012,
55013,
55014,
55015,
55016,
55017,
55018,
55019,
55020,
55021,
55022,
55023,
55024,
55025,
55026,
55027,
55028,
55029,
55030,
55031,
55032,
55033,
55066,
55067,
55068,
55069,
55070,
55071,
55072,
55073,
55074,
55075,
55076,
55077,
55078,
55079,
55080,
55081,
55082,
55083,
55084,
55085,
55086,
55087,
55088,
55089,
55090,
55091,
55092,
55093,
55094,
55095,
55096,
55097,
55098,
55099,
55100,
55101,
55102,
55103,
55104,
55105,
55106,
55107,
55108,
55109,
55110,
55111,
55112,
55113,
55114,
55115,
55116,
55117,
55118,
55119,
55120,
55121,
55122,
55124,
55125,
55126,
55127,
55128,
55129,
55130,
55131,
55132,
55133,
55134,
55135,
55136,
55137,
55138,
55139,
55140,
55141,
55142,
55143,
55144,
55145,
55146,
55147,
55148,
55149,
55150,
55151,
55152,
55153,
55154,
55155,
55156,
55157,
55158,
55159,
55160,
55161,
55162,
55163,
55164,
55165,
55166,
55167,
55168,
55169,
55170,
55171,
55172,
55173,
55174,
55175,
55176,
55177,
55178,
55179,
55180,
55181,
55182,
55183,
55184,
55185,
53820,
53822,
53836,
53846,
53865,
53867,
53875,
52201,
55321,
55322,
55324,
55326,
55330,
55331,
55334,
55335,
55336,
55337,
55338,
55339,
55340,
55341,
55342,
55344,
55345,
55346,
55348,
55349,
55350,
55351,
55352,
55353,
55354,
55383,
55384,
55386,
55387,
55388,
55390,
55391,
55394,
55395,
55397,
55398,
55399,
55400,
55401,
55402,
55403,
55404,
55405,
55406,
55407,
55471,
55472,
55473,
55474,
55475,
55476,
55477,
55478,
55479,
55480,
55481,
55482,
55483,
55485,
55486,
55487,
55488,
55489,
55490,
55491,
55492,
55493,
55494,
55495,
55497,
55498,
55499,
55500,
55533,
55534,
55536,
55537,
55539,
55540,
55541,
55542,
55543,
55544,
55545,
55546,
55547,
55385,
54339,
54341,
54347,
54482,
54498,
54507,
53845,
54505,
54795,
54810,
53876,
56282,
56283,
56284,
56285,
56287,
56288,
56289,
56290,
56291,
56292,
56293,
56294,
56296,
56297,
56298,
56299,
56300,
56301,
56302,
56303,
56305,
56306,
56307,
56308,
56309,
56310,
56311,
56381,
56382,
56383,
56384,
56386,
56387,
56388,
56389,
56390,
56391,
56392,
56393,
56394,
56395,
56396,
56397,
56398,
56399,
56400,
56401,
56402,
56403,
56404,
56405,
56406,
56407,
56408,
56409,
54292,
54295,
54302,
55549,
55550,
55551,
55552,
55554,
55555,
55557,
55558,
55559,
55560,
55561,
55562,
55389,
55392,
55393,
55396,
54318,
56669,
56670,
56672,
56673,
56674,
56675,
56676,
56678,
56679,
56680,
56681,
56682,
56683,
56684,
56685,
56686,
56688,
56690,
56691,
56692,
56693,
56694,
56695,
56696,
56697,
56698,
56699,
55329,
55332,
55343,
55347,
55484,
55496,
54672,
54676,
54700,
54706,
56943,
56945,
56946,
56947,
56948,
56951,
56952,
56953,
56954,
56956,
56957,
56958,
56960,
56961,
56962,
56963,
56965,
56966,
56968,
56969,
56970,
57058,
57059,
57060,
57061,
57062,
57065,
57066,
57067,
57068,
57069,
57070,
57071,
57072,
57073,
57074,
57075,
57076,
57077,
57078,
57079,
57080,
57081,
57082,
57083,
57084,
57085,
57086,
57087,
57184,
57185,
57186,
57188,
57189,
57190,
57191,
57192,
57194,
57196,
57197,
57198,
57199,
57200,
57201,
57202,
57203,
57204,
57205,
57206,
57207,
57208,
57209,
57210,
57211,
57212,
55548,
55553,
55556,
56286,
56295,
56304,
54806,
55327,
55328,
54798,
54800,
55323,
55325,
54509,
55408,
57257,
57258,
57259,
57260,
57261,
57262,
57265,
57266,
57267,
57268,
57269,
57270,
57271,
57272,
57273,
57274,
57275,
57276,
57277,
57278,
57279,
57281,
57282,
57283,
57284,
57285,
56671,
55535,
55538,
55355,
57552,
57553,
57554,
57555,
57556,
57557,
57558,
57560,
57561,
57562,
57563,
57564,
57565,
57566,
57568,
57569,
57570,
57571,
57573,
57574,
57576,
57577,
57578,
57579,
57580,
57581,
56677,
56687,
56689,
56955,
55501,
57761,
57762,
57763,
57764,
57765,
57766,
57767,
57768,
57769,
57770,
57772,
57773,
57774,
57775,
57777,
57778,
57779,
57780,
57781,
57782,
57784,
57785,
57786,
57787,
57788,
57789,
57790,
57819,
57821,
57823,
57824,
57826,
57827,
57828,
57829,
57830,
57831,
57832,
57833,
57834,
57835,
57836,
57837,
57838,
57839,
57840,
57841,
57842,
57843,
57844,
57845,
57846,
57847,
56959,
56964,
56967,
57256,
57263,
57264,
57280,
57559,
57567,
57572,
57771,
57776,
57783,
56380,
56385,
57183,
57187,
57193,
57195,
55563,
56312,
56700,
56942,
56944,
56949,
56950,
57575,
58860,
58861,
58863,
58864,
58866,
58869,
58871,
58872,
58873,
58875,
58878,
58880,
58881,
58882,
58884,
58885,
58886,
58887,
58888,
57820,
57822,
57848,
57825,
56410,
59192,
59193,
59194,
59195,
59196,
59197,
59198,
59199,
59201,
59202,
59203,
59204,
59205,
59206,
59207,
59208,
59210,
59211,
59212,
59213,
59214,
59215,
59216,
59217,
59218,
59220,
57063,
57064,
56971,
57213,
59412,
59413,
59414,
59415,
59416,
59417,
59418,
59419,
59421,
59422,
59423,
59424,
59425,
59426,
59427,
59428,
59429,
59431,
59432,
59433,
59435,
59436,
59437,
59438,
59439,
59440,
59441,
59553,
59554,
59555,
59556,
59557,
59558,
59559,
59561,
59562,
59563,
59564,
59565,
59566,
59567,
59568,
59569,
59570,
59571,
59573,
59574,
59575,
59576,
59577,
59578,
59579,
59580,
58859,
58862,
58868,
58870,
58874,
58876,
58879,
58865,
58867,
58877,
58883,
59200,
59209,
57286,
57582,
57088,
59219,
59221,
57791,
57849,
60453,
60454,
60455,
60456,
60457,
60458,
60459,
60460,
60461,
60463,
60464,
60465,
60466,
60467,
60468,
60469,
60470,
60471,
60472,
60473,
60475,
60476,
60477,
60478,
60479,
60480,
60481,
60618,
60619,
60620,
60621,
60622,
60623,
60625,
60626,
60627,
60628,
60629,
60631,
60632,
60633,
60634,
60635,
60636,
60637,
60638,
60639,
60640,
60641,
60642,
60643,
60644,
60646,
60647,
59560,
59572,
58889,
59222,
60932,
60933,
60934,
60935,
60936,
60937,
60938,
60939,
60940,
60941,
60942,
60943,
60944,
60945,
60946,
60947,
60948,
60949,
60950,
60951,
60952,
60953,
60954,
60955,
60956,
61236,
61237,
61238,
61239,
61240,
61241,
61242,
61243,
61244,
61245,
61246,
61247,
61248,
61249,
61250,
61251,
61252,
61253,
61254,
61255,
61256,
61257,
61258,
61259,
61260,
61261,
61262,
61263,
61264,
61265,
61529,
61530,
61531,
61532,
61533,
61534,
61535,
61536,
61537,
61538,
61539,
61540,
61541,
61542,
61543,
61544,
61545,
61547,
61548,
61549,
61550,
61552,
61553,
61554,
61555,
61556,
61557,
60452,
60462,
61844,
61845,
61846,
61847,
61848,
61849,
61850,
61851,
61852,
61853,
61854,
61855,
61856,
61857,
61858,
61859,
61860,
61862,
61863,
61864,
61865,
61867,
61868,
61869,
61870,
61871,
61872,
61873,
60474,
59442,
55333,
54818,
60624,
60630,
60645,
65669,
65670,
65671,
65673,
65674,
65676,
65677,
65678,
65679,
65680,
65681,
65682,
65683,
65684,
65686,
65687,
65688,
65689,
65690,
65691,
65692,
65693,
65694,
65695,
65696,
65697,
65698,
54364,
65898,
65899,
65900,
65901,
65902,
65903,
65904,
65905,
65906,
65907,
65908,
65909,
65910,
65912,
65913,
65914,
65915,
65916,
65917,
65918,
65919,
65920,
65921,
65922,
65923,
65925,
65926,
66063,
66064,
66065,
66066,
66067,
66068,
66069,
66070,
66071,
66072,
66073,
66074,
66075,
66076,
66077,
66078,
66079,
66080,
66081,
66082,
66083,
66084,
66085,
66086,
66087,
66088,
66089,
66090,
66091,
66092,
61861,
61866,
59420,
59430,
59434,
59581,
60482,
60648,
60957,
67925,
67926,
67927,
67928,
67929,
67930,
67931,
67932,
67933,
67934,
67935,
67936,
67937,
67938,
67939,
67940,
67941,
67942,
67943,
67944,
67945,
67946,
67947,
67948,
67949,
67950,
67951,
67952,
67953,
68078,
68079,
68080,
68081,
68082,
68083,
68084,
68085,
68086,
68088,
68089,
68090,
68091,
68092,
68093,
68094,
68095,
68096,
68097,
68098,
68099,
68100,
68101,
68102,
68103,
68104,
68105,
68106,
68107,
67954,
68205,
68206,
68207,
68208,
68209,
68210,
68211,
68212,
68213,
68214,
68215,
68216,
68217,
68218,
68219,
68220,
68221,
68222,
68223,
68224,
68226,
68227,
68228,
68229,
68230,
68232,
68233,
68234,
68225,
68497,
68498,
68499,
68500,
68501,
68502,
68503,
68504,
68505,
68506,
68507,
68508,
68509,
68510,
68511,
68512,
68513,
68514,
68515,
68516,
68517,
68518,
68519,
68520,
68521,
68522,
68523,
68524,
68525,
68526,
68527,
68613,
68614,
68615,
68616,
68617,
68618,
68619,
68620,
68621,
68622,
68623,
68624,
68625,
68626,
68627,
68628,
68629,
68630,
68631,
68632,
68633,
68634,
68635,
68636,
68637,
68638,
68639,
68640,
68641,
68642,
68786,
68787,
68788,
68789,
68790,
68791,
68792,
68793,
68794,
68795,
68796,
68797,
68798,
68799,
68800,
68801,
68802,
68803,
68804,
68805,
68806,
68807,
68808,
68809,
68810,
68811,
68812,
68813,
68814,
68815,
68643,
68816,
68945,
68946,
68947,
68948,
68949,
68950,
68951,
68952,
68953,
68954,
68955,
68956,
68957,
68958,
68959,
68960,
68961,
68962,
68963,
68964,
68965,
68966,
68967,
68968,
68969,
68970,
68971,
68972,
68973,
68974,
69038,
69039,
69040,
69041,
69042,
69043,
69044,
69045,
69046,
69047,
69048,
69049,
69050,
69051,
69052,
69053,
69054,
69055,
69056,
69057,
69058,
69059,
69060,
69061,
69062,
69063,
69064,
69065,
69066,
69067,
69068,
69258,
69259,
69260,
69261,
69262,
69263,
69264,
69265,
69266,
69267,
69268,
69269,
69270,
69271,
69272,
69273,
69274,
69275,
69276,
69277,
69278,
69279,
69280,
69281,
69282,
69283,
69284,
69285,
69286,
69643,
69644,
69645,
69646,
69647,
69648,
69649,
69650,
69651,
69652,
69653,
69654,
69655,
69656,
69657,
69658,
69659,
69660,
69661,
69662,
69663,
69664,
69665,
69666,
69667,
69668,
69669,
69670,
69671,
65672,
65675,
65685,
65897,
65911,
65924,
68087,
61546,
61551,
61558,
68231,
61266,
61559,
61874,
76525,
76526,
76527,
76528,
76529,
76530,
76531,
76532,
76533,
76534,
76535,
76536,
76537,
76538,
76539,
76540,
76541,
76542,
76543,
76544,
76545,
76546,
76547,
76548,
76549,
76550,
76551,
76552,
76553,
76554,
76555,
76556,
76557,
76558,
76559,
76560,
76561,
76562,
76563,
76564,
76565,
76566,
76567,
76568,
76569,
76570,
76571,
76572,
76573,
76574,
76575,
76576,
76577,
76578,
76579,
76580,
76581,
76582,
76583,
76584,
76585,
76586,
76587,
76588,
76589,
76590,
76591,
76592,
76593,
76594,
76595,
76596,
76597,
76598,
76599,
76600,
76601,
76602,
76603,
76604,
76605,
76606,
76607,
76608,
76609,
76610,
76611,
76612,
76613,
76614,
76615,
76616,
76617,
76618,
76619,
76623,
76624,
76625,
76626,
76627,
76628,
76629,
76630,
76631,
76632,
76633,
76634,
76635,
76636,
76637,
76638,
76639,
76640,
76641,
76642,
76643,
76644,
76645,
76646,
76647,
76648,
76649,
76650,
76651,
76652,
76653,
76654,
76655,
76657,
76658,
76659,
76660,
76661,
76662,
76663,
76664,
76665,
76666,
76667,
76668,
76669,
76670,
76671,
76672,
76673,
76674,
76675,
76676,
76677,
76678,
76679,
76680,
76681,
76682,
76683,
76684,
76685,
76686,
76687,
76688,
76689,
76690,
76691,
76692,
76693,
76694,
76695,
76696,
76697,
76698,
76699,
76700,
76701,
76702,
76703,
76704,
76705,
76706,
76707,
76708,
76709,
76710,
76711,
76712,
76713,
76714,
76715,
76716,
76717,
76718,
76719,
76720,
76721,
76722,
76723,
76724,
76725,
76726,
76727,
76728,
76729,
76730,
76731,
76732,
76733,
76734,
76735,
76736,
76737,
76738,
76739,
76740,
76741,
76742,
76743,
76744,
76745,
76746,
76747,
76748,
76749,
76750,
76751,
76752,
76753,
76754,
76755,
76756,
76757,
76758,
76759,
76760,
76761,
76762,
76763,
76764,
76765,
76766,
76767,
76768,
76780,
76781,
76782,
76783,
76784,
76785,
76786,
76787,
76788,
76789,
76790,
76791,
76792,
76793,
76794,
76795,
76796,
76797,
76798,
76799,
76800,
76801,
76802,
76803,
76804,
76805,
76806,
76807,
76808,
76809,
76810,
76811,
76812,
76813,
76814,
76815,
76816,
76817,
76818,
76819,
76820,
76821,
76822,
76823,
76824,
76825,
76826,
76827,
76828,
76829,
76830,
77247,
77248,
77249,
77250,
77251,
77252,
77253,
77254,
77255,
77256,
77257,
77258,
77259,
77260,
77261,
77262,
77263,
77264,
77265,
77266,
77267,
77268,
77269,
77270,
77271,
77272,
77273,
77274,
77275,
77276,
77277,
77278,
77280,
77281,
77282,
77283,
77284,
77285,
77286,
77287,
77288,
77289,
77290,
77291,
77292,
77293,
77294,
77295,
77296,
77297,
77298,
77299,
77300,
77301,
77302,
77303,
77304,
77305,
77306,
77325,
77326,
77327,
77328,
77329,
77330,
77331,
77332,
77333,
77334,
77335,
77336,
77337,
77338,
77339,
77340,
77341,
77342,
77343,
77344,
77345,
77346,
77347,
77348,
77349,
77350,
77552,
77553,
77554,
77555,
77556,
77557,
77558,
77559,
77560,
77561,
77562,
77563,
77564,
77565,
77566,
77567,
77568,
77569,
77570,
77571,
77572,
77573,
77574,
77575,
77576,
77577,
77580,
77581,
77582,
77583,
77584,
77585,
77586,
77587,
77588,
77589,
77590,
77591,
77592,
77593,
77594,
77595,
77596,
77597,
77598,
77599,
77600,
77601,
77602,
77603,
77604,
77605,
77606,
77607,
77608,
77609,
77610,
77611,
77612,
77613,
77614,
77615,
77616,
77617,
77618,
77619,
77620,
77621,
77622,
77623,
77624,
77625,
77626,
77627,
77628,
77629,
77630,
77631,
77632,
77633,
77634,
77637,
77638,
77639,
77640,
77641,
77642,
77643,
77644,
77645,
77646,
77647,
77648,
77649,
77650,
77651,
77652,
77653,
77654,
77655,
77656,
77657,
77658,
77659,
77660,
77661,
77662,
77663,
77664,
77665,
77666,
77667,
77668,
77669,
77670,
77671,
77672,
77673,
77674,
77675,
77676,
77677,
77678,
77679,
77680,
77681,
77682,
77683,
77684,
77685,
77686,
77687,
77688,
77689,
77690,
77691,
77692,
77693,
77694,
77695,
77696,
77697,
77698,
77699,
77700,
77701,
77702,
77703,
77704,
77705,
77706,
77707,
77708,
77709,
77710,
77711,
77712,
77713,
77714,
77715,
77716,
77717,
77718,
77719,
77720,
77721,
77722,
77723,
77724,
77725,
77726,
77727,
77728,
77729,
77730,
77731,
77732,
77733,
77734,
77735,
77736,
77737,
77738,
77739,
77740,
77741,
77742,
77743,
77744,
77745,
77746,
77747,
77748,
77749,
77750,
77751,
77752,
77753,
77754,
77755,
77756,
77757,
77758,
77759,
77760,
77761,
77762,
77763,
77764,
77765,
77766,
77767,
77768,
77769,
77770,
77771,
77772,
77773,
77774,
77775,
77777,
77778,
77779,
77780,
77781,
77782,
77783,
77784,
77785,
77786,
77787,
77788,
77789,
77790,
77791,
77792,
77793,
77794,
77795,
77796,
77797,
77798,
77799,
77800,
77801,
77802,
77803,
77804,
77805,
77806,
77807,
77808,
77809,
77810,
77811,
77812,
77813,
77814,
77815,
77816,
77817,
77818,
77819,
77820,
77821,
77822,
77823,
77824,
77825,
77826,
77827,
77828,
77829,
77830,
77831,
77837,
77838,
77839,
77840,
77841,
77842,
77843,
77844,
77845,
77846,
77847,
77848,
77849,
77850,
77851,
77852,
77853,
77854,
77855,
77856,
77857,
77858,
77859,
77862,
77863,
77864,
77865,
77866,
77867,
77868,
77869,
77870,
77871,
77872,
77873,
77874,
77875,
77876,
77877,
77878,
77879,
77880,
77881,
77882,
77883,
77884,
77885,
77886,
77887,
77888,
77889,
77890,
77891,
77892,
77893,
77894,
77895,
77896,
77897,
77898,
77899,
77900,
77901,
77902,
77903,
77904,
77905,
77906,
77907,
77908,
77909,
77910,
77911,
77912,
77913,
77914,
77915,
77916,
77917,
77918,
77919,
77920,
77921,
77922,
77923,
77924,
77925,
77926,
77927,
77928,
77929,
77930,
77931,
77932,
77933,
77934,
77935,
77936,
77937,
77938,
77939,
77940,
77941,
77942,
77943,
77944,
77945,
77946,
77947,
77948,
77949,
77950,
77951,
77952,
77953,
77954,
77955,
77956,
77957,
77958,
77959,
77960,
77961,
77962,
77963,
77964,
77965,
77966,
77967,
77968,
77969,
77970,
77971,
77972,
77973,
77974,
77975,
77976,
77977,
77978,
77979,
77980,
77981,
77982,
77983,
77984,
77985,
77986,
77987,
77988,
77989,
77990,
77991,
77992,
77993,
77994,
78000,
78001,
78002,
78003,
78004,
78005,
78006,
78007,
78008,
78009,
78010,
78011,
78012,
78013,
78014,
78015,
78016,
78017,
78018,
78019,
78020,
78021,
78027,
78028,
78029,
78030,
78031,
78032,
78033,
78034,
78035,
78036,
78037,
78038,
78039,
78040,
78041,
78042,
78043,
78044,
78045,
78046,
78047,
78048,
78049,
78050,
78051,
78052,
78053,
78055,
78056,
78057,
78058,
78059,
78060,
78061,
78062,
78063,
78064,
78065,
78066,
78067,
78068,
78069,
78070,
78071,
78072,
78073,
78074,
78075,
78076,
78077,
78078,
78079,
78080,
78081,
78082,
78083,
78084,
78085,
78086,
78087,
78088,
78089,
78090,
78091,
78092,
78093,
78094,
78095,
78096,
78097,
78098,
78099,
78100,
78101,
78102,
78103,
78104,
78105,
78106,
78107,
78108,
78109,
78110,
78111,
78112,
78113,
78114,
78115,
78116,
78117,
78118,
78119,
78120,
78121,
78122,
78123,
78124,
78125,
78126,
78127,
78128,
78129,
78130,
78131,
78132,
78133,
78134,
78135,
78136,
78137,
78138,
78139,
78140,
78141,
78142,
78143,
78146,
78147,
78148,
78149,
78150,
78151,
78152,
78153,
78154,
78155,
78156,
78157,
78158,
78159,
78160,
78161,
78162,
78163,
78164,
78165,
78166,
78167,
78168,
78169,
78170,
78171,
78172,
78173,
78174,
78175,
78176,
78177,
78178,
78179,
78180,
78181,
78182,
78183,
78184,
78185,
78186,
78187,
78188,
78189,
78190,
78191,
78192,
78193,
78194,
78195,
78196,
78197,
78198,
78199,
78200,
78203,
78204,
78205,
78206,
78207,
78208,
78209,
78210,
78211,
78212,
78213,
78214,
78215,
78216,
78217,
78218,
78219,
78220,
78221,
78222,
78223,
78224,
78225,
78226,
78227,
78228,
78229,
78230,
78231,
78232,
78233,
78234,
78235,
78236,
78237,
78238,
78239,
78240,
78241,
78242,
78243,
78244,
78245,
78246,
78247,
78248,
78249,
78250,
78251,
78252,
78253,
78254,
78255,
78256,
78257,
78258,
78259,
78260,
78262,
78263,
78264,
78265,
78266,
78267,
78268,
78269,
78270,
78271,
78272,
78273,
78274,
78275,
78276,
78277,
78278,
78279,
78280,
78281,
78282,
78283,
78284,
78285,
78286,
78287,
78288,
78289,
78290,
78291,
78292,
78293,
78294,
78295,
78296,
78297,
78298,
78299,
78300,
78301,
78302,
78303,
78304,
78305,
78306,
78307,
78308,
78309,
78310,
78311,
78312,
78313,
78314,
78315,
78316,
78317,
78318,
79507,
79508,
79509,
79510,
79511,
79512,
79513,
79514,
79515,
79516,
79517,
79518,
79519,
79520,
79521,
79522,
79523,
79524,
79525,
79526,
79527,
79528,
79529,
79530,
79531,
79532,
79533,
79534,
79535,
79536,
79537,
79616,
79617,
79618,
79619,
79620,
79621,
79622,
79623,
79624,
79625,
79626,
79627,
79628,
79629,
79630,
79631,
79632,
79633,
79634,
79635,
79636,
79637,
79638,
79639,
79640,
79641,
79642,
79643,
79644,
79645,
79646,
80157,
80158,
80159,
80160,
80161,
80162,
80163,
80164,
80165,
80166,
80167,
80168,
80169,
80170,
80171,
80172,
80173,
80174,
80175,
80176,
80177,
80178,
80179,
80180,
80181,
80182,
80183,
80184,
80185,
80186,
80187,
80493,
80494,
80495,
80496,
80497,
80498,
80499,
80500,
80501,
80502,
80503,
80504,
80505,
80506,
80507,
80508,
80509,
80510,
80511,
80512,
80513,
80514,
80515,
80516,
80517,
80518,
80519,
80520,
80521,
80522,
80847,
80848,
80849,
80850,
80851,
80852,
80853,
80854,
80855,
80856,
80857,
80858,
80859,
80860,
80861,
80862,
80863,
80864,
80865,
80867,
80868,
80869,
80871,
80872,
80873,
80874,
80875,
80876,
80894,
80895,
80896,
80897,
80898,
80899,
80900,
80901,
80902,
80903,
80904,
80906,
80907,
80908,
80909,
80910,
80911,
80912,
80913,
80914,
80915,
80916,
80917,
80918,
80919,
80920,
80921,
80922,
69672,
85332,
85333,
85334,
85335,
85336,
85337,
85338,
85339,
85340,
85341,
85342,
85343,
85344,
85345,
85346,
85347,
85348,
85350,
85352,
85353,
85354,
85355,
85356,
85358,
85359,
85360,
85361,
85403,
85404,
85405,
85406,
85407,
85408,
85409,
85410,
85411,
85412,
85413,
85414,
85415,
85416,
85417,
85418,
85419,
85420,
85421,
85422,
85423,
85424,
85425,
85426,
85427,
85428,
85429,
85430,
85431,
85432,
85625,
85626,
85627,
85628,
85629,
85630,
85631,
85632,
85633,
85634,
85635,
85636,
85637,
85638,
85639,
85640,
85641,
85642,
85643,
85644,
85645,
85646,
85647,
85648,
85649,
85650,
85651,
85652,
85653,
85654,
85655,
77578,
89358,
89359,
89360,
89361,
89362,
89363,
89364,
89365,
89366,
89367,
89368,
89369,
89370,
89371,
89372,
89373,
89374,
89375,
89376,
89377,
89378,
89379,
89380,
89381,
89382,
89383,
89384,
89385,
89386,
89387,
80905,
80923,
80866,
80870,
85349,
85351,
85357,
65699,
65927,
66093,
68108,
68235,
68975,
69287,
80523,
80924,
80877,
85362,
85433,
95307,
95308,
95309,
95310,
95313,
95314,
95315,
95316,
95317,
95318,
95319,
95320,
95321,
95322,
95323,
95324,
95325,
95326,
95327,
95328,
95329,
95330,
95331,
95332,
95333,
95334,
95335,
95441,
95442,
95443,
95444,
95445,
95446,
95447,
95448,
95449,
95450,
95451,
95452,
95453,
95454,
95455,
95456,
95457,
95462,
95464,
95465,
95466,
95467,
95468,
95469,
95470,
95471,
95472,
95473,
95474,
95475,
95476,
95477,
95478,
95479,
95480,
95481,
95482,
95483,
95484,
95485,
95486,
95487,
95488,
95489,
95490,
95655,
95656,
95657,
95658,
95659,
95660,
95661,
95662,
95663,
95664,
95665,
95666,
95667,
95668,
95669,
95670,
95672,
95673,
95674,
95675,
95677,
95679,
95680,
95681,
95682,
95683,
95684,
95803,
95804,
95805,
95806,
95809,
95810,
95811,
95812,
95813,
95814,
95815,
95816,
95817,
95818,
95819,
95820,
95821,
95822,
95823,
95824,
95825,
95826,
95827,
95828,
95829,
95830,
95831,
95832,
96005,
96006,
96007,
96008,
96009,
96010,
96011,
96012,
96013,
96014,
96015,
96016,
96017,
96018,
96019,
96020,
96021,
96022,
96023,
96024,
96025,
96026,
96027,
96028,
96029,
96030,
96031,
96032,
96033,
96034,
96349,
96351,
96352,
96353,
96354,
96355,
96356,
96357,
96358,
96359,
96360,
96362,
96363,
96364,
96365,
96366,
96367,
96368,
96369,
96370,
96371,
96372,
96373,
96374,
96375,
96376,
96377,
96378,
96645,
96646,
96647,
96648,
96649,
96650,
96651,
96652,
96653,
96654,
96655,
96656,
96658,
96659,
96660,
96661,
96662,
96663,
96664,
96665,
96666,
96667,
96668,
96669,
96670,
96671,
96673,
96674,
97128,
97129,
97130,
97131,
97132,
97133,
97134,
97135,
97136,
97137,
97138,
97139,
97140,
97141,
97142,
97143,
97144,
97145,
97146,
97147,
97148,
97149,
97150,
97151,
97152,
97154,
97155,
97157,
97477,
97478,
97479,
97480,
97481,
97482,
97483,
97484,
97485,
97486,
97488,
97489,
97490,
97491,
97492,
97493,
97494,
97495,
97496,
97498,
97499,
97500,
97501,
97502,
97503,
97504,
97505,
97506,
97782,
97783,
97784,
97785,
97786,
97787,
97788,
97789,
97790,
97791,
97792,
97793,
97794,
97795,
97797,
97798,
97799,
97800,
97801,
97802,
97803,
97804,
97805,
97806,
97808,
97809,
97810,
97811,
98030,
98031,
98032,
98033,
98035,
98036,
98037,
98038,
98039,
98040,
98041,
98042,
98043,
98044,
98045,
98046,
98047,
98048,
98050,
98051,
98052,
98053,
98054,
98055,
98056,
98057,
98058,
98059,
98307,
98308,
98309,
98310,
98311,
98312,
98313,
98314,
98315,
98316,
98317,
98318,
98319,
98320,
98321,
98322,
98324,
98325,
98326,
98328,
98329,
98330,
98331,
98332,
98333,
98334,
98335,
95671,
95676,
95678,
95461,
95463,
96350,
96361,
96657,
96672,
97153,
97156,
97487,
97497,
97796,
97807,
89388,
95336,
95685,
95491,
95833,
96035,
99053,
99054,
99055,
99056,
99057,
99058,
99059,
99060,
99061,
99062,
99063,
99064,
99065,
99066,
99067,
99068,
99069,
99070,
99071,
99072,
99073,
99074,
99075,
99076,
99077,
99078,
99079,
99080,
99081,
99082,
99224,
99225,
99227,
99228,
99229,
99230,
99231,
99232,
99233,
99234,
99235,
99236,
99237,
99238,
99239,
99240,
99241,
99242,
99243,
99245,
99246,
99247,
99248,
99249,
99250,
99251,
99252,
99253,
99488,
99489,
99490,
99491,
99492,
99493,
99494,
99495,
99496,
99497,
99498,
99499,
99500,
99501,
99502,
99503,
99504,
99505,
99506,
99507,
99508,
99509,
99510,
99511,
99512,
99513,
99514,
99515,
99486,
99487,
99755,
99756,
99757,
99758,
99759,
99760,
99761,
99762,
99763,
99764,
99765,
99766,
99767,
99768,
99769,
99770,
99771,
99772,
99773,
99774,
99775,
99776,
99777,
99778,
99779,
99780,
99781,
99782,
99783,
99784,
100260,
100261,
100262,
100263,
100264,
100265,
100266,
100267,
100268,
100269,
100270,
100271,
100272,
100273,
100274,
100275,
100276,
100277,
100278,
100279,
100280,
100281,
100282,
100283,
100284,
100285,
100286,
100287,
100288,
100289,
100290,
100291,
100292,
100293,
100294,
100665,
100666,
100667,
100668,
100669,
100670,
100671,
100672,
100673,
100674,
100675,
100676,
100677,
100678,
100679,
100680,
100681,
100682,
100683,
100684,
100685,
100686,
100687,
100688,
100689,
100690,
100691,
100692,
100693,
100694,
100695,
100696,
100697,
100698,
101779,
101780,
101781,
101782,
101783,
101784,
101785,
101786,
101787,
101788,
101789,
101790,
101791,
101792,
101793,
101794,
101795,
101796,
101797,
101798,
101799,
101800,
101801,
101802,
101803,
101804,
101805,
101806,
101807,
101808,
102103,
102104,
102105,
102106,
102107,
102108,
102109,
102110,
102111,
102112,
102113,
102114,
102115,
102116,
102117,
102118,
102119,
102120,
102121,
102122,
102123,
102124,
102125,
102126,
102127,
102128,
102129,
102130,
102131,
102132,
104603,
104604,
104605,
104606,
104607,
104609,
104610,
104611,
104612,
104614,
104615,
104616,
104617,
104618,
104619,
104620,
104621,
104622,
104623,
104624,
104625,
104626,
104627,
104628,
104629,
104630,
104631,
104632,
95311,
95312,
95807,
95808,
96379,
96675,
97158,
97507,
97812,
98060,
98336,
99083,
99254,
99516,
100295,
100699,
99785,
101809,
102133,
104633,
98034,
98049,
98323,
98327,
99226,
99244,
104608,
104613
)
AND products.product_type = 'P'
AND products.parent_product_id = 0
GROUP BY
products.product_id
ORDER BY
products.timestamp desc,
products.product_id desc,
products.product_id ASC
LIMIT
1520, 20