QUERY: SELECT
p.products_id,
p.products_model,
p.label_ids,
p.main_category,
p.products_ean,
p.products_fsk18,
p.products_quantity,
p.products_quantity_min,
p.products_quantity_step,
p.products_price,
p.products_price_small_opt,
p.products_price_opt,
p.products_purchase_price,
p.small_opt_purchase_price,
p.count_small_opt_purchase_price,
p.count_opt_purchase_price,
p.opt_purchase_price,
p.postavshik,
p.suplier_catalog_id,
p.postavshik_comment,
p.name_catalog_id,
p.products_tax_class_id,
p.products_image,
p.products_vpe,
p.products_vpe_status,
p.products_vpe_value,
p.products_currency,
p.products_page_url,
p.video,
p.show_video,
pd.products_short_description,
p.rev_total,
p.rev_rating,
pd.products_name,
p.products_ordered,
pd.products_short_description,
s.status,
IF(s.status, s.specials_new_products_price, 0) as specials_new_products_price,
m.manufacturers_name,
m.manufacturers_id FROM products AS p
LEFT JOIN products_description AS pd ON (p.products_id = pd.products_id)
LEFT JOIN manufacturers AS m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN specials AS s on p.products_id = s.products_id
LEFT JOIN products_to_categories as p2c2 ON (p2c2.products_id=p.products_id)
LEFT JOIN categories as c ON (c.categories_id=p2c2.categories_id) WHERE p.products_status = 1 AND c.categories_status = 1 AND pd.language_id = '1' AND p.products_id IN(10447777,10447781,10447787,10447796,10447806,10939725,10939742,10939882,10939908,7076288,7076291,7076293,8574480,8574485,8574497,8574501,8574504,8574505,8574512,8574522,8574523,8574528,8621467,8583434,4968332,8583487,10950673,10951109,8575733,8575734,8575735,8622491,10844802,11001079,7067444,7067765,7067801,10959557,6000198,6000199,8617860,7072148,7072149,7072150,7072151,8911229,10985860,10842937,10842940,8911250,10843021,10843024,10843035,10843100,10973056,7064386,10931903,10931904,10931905,10931906,10960214,10960215,10960336,7064652,10843427,8836214,8836216,8836250,8836251,10986516,10103986,10986681,10843773,10999966,10999967,10932917,10104638,10961233,10997521,10997522,10997523,10997524,10997525,10997526,10997527,11010598,11010599,11010600,11010601,11010602,11010603,11010604,11010606,10958955,10958956,10958987,11037113,11037128,8910604,8910605,10102864,10102876,10102922,8907904,10839994,8615236,8908495,8908496,10840218,10941691,10941693,10941695,10941697,10941698,10996689,8909075,8909076,10941755,10941758,10941762,10941770,10941774,10942141,8860397,10101736,8860555,8860613,7070793,10993599,10993600,10993665,10993666,8612862,11045724,8612936,10618274,10967841,10967842,10967843,10967844,11006989,10955053,10994243,10623732,10838527,8906891,8906901,8907037,10619353,10838966,10838967,10838973,10838978,10838980,8907292,10838991,10838992,8907436,8907489,10995359,10995360,10995379,10995380,10619924,10619925,10619926,11047472,11047484,11047490,11047495,11047496,11047497,10992578,10992579,10992581,10992582,10927562,11044780,11044806,11044807,11044808,11044809,11044810,11044811,11044812,11044813,8905217,8905218,8905220,10617332,8905251,8905252,8905253,8905262,10617352,10617353,10617397,10617410,10617422,10617425,10617434,10617435,10617455,8612468,10993358,10993359,10993362,10993366,10993373,10928353,10993383,10993384,10993386,10993387,10993388,10993389,10993390,10993392,10993393,10993394,10993395,10993396,10993397,10993398,10993400,10993409,10993410,10993412,10993414,10993415,10990667,10990668,10990669,10990670,10990671,10425359,8576181,10425387,10425388,10425389,10425392,10615179,10615229,10425485,10620303,10615329,10615330,10425551,10425556,10615343,10425566,10425571,10615711,11043256,10426009,10952313,10615894,10991487,11043502,10991516,10991580,10991581,10991582,10616044,10991583,10616045,10991584,10991585,10991592,10952581,10991720,10991727,10991735,10991736,10991741,10991743,10991744,10991745,8904188,8904189,8904210,8904222,8904224,8904226,8904232,8904234,8904236,8904242,8904254,8904260,10952888,10991893,10991899,10991900,10991901,10991902,10991914,10991948,10991950,10991951,10991973,10991983,10991984,10991991,10991998,10992001,10992005,8904382,8904405,8904420,8611258,8611259,8611260,8611374,10992235,10992236,10992237,10992240,10992241,10992286,10992301,8611455,8611459,8611466,8611467,8611468,10992317,10992318,10992319,10992324,10992326,10992377,10992379,10992383,10992387,8577911,10616888,10616905,10922436,10922437,10922441,10922443,10922444,10922445,10922446,8577968,10922447,8577969,10922448,10922449,10922450,10610964,9205324,10610995,9205341,10565155,9205343,10565158,9205346,10614054,7019062,7019097,7019135,10565328,7019290,7019324,7019356,7059883,6665742,10611411,10611417,10611452,10714271,10611462,10611495,10614495,10611521,10611542,10614552,10614553,10614554,10611563,9173955,9173979,10611666,9174013,9174014,9174015,9214037,9214038,9174048,9174049,9174062,9174063,9174064,9174074,9174075,9174083,9174087,10611831,10611833,9214179,9174284,7019949,10612137,10119706,10119707,10612191,10612192,10612201,9211551,9211552,9211557,10560489,10560490,10560491,10560492,10560493,10560494,10560495,10560496,10560497,10560498,10560499,10560500,10560501,10560502,10560503,10560504,10560505,10560506,10560507,7017677,7017678,8862556,8862557,10609707,7017840,7017841,10609916,10609917,10609918,10612940,10612941,7017939,7017959,8862830,8862835,9212318,7017979,10609988,9188357,9196358,9188364,9188365,9188366,10610030,9188370,9188379,10610046,9188394,10610063,10613081,10613082,9196444,10613107,10613109,7018178,10610311,10613369,10613434,7018514,7018548,7018582,7018616,7018650,10610697,10613736,10610775,10610777,10613812,10613813,10613814,10613815,7018822,9189174,9189175,9189176,7018856,7018890,10610917,9197281,9197282,9197283,9197284,9197285,10513388,7015283,7015303,9169669,7015323,10117890,10117891,9185718,9185722,9185727,9185742,9185743,10513559,9185754,9185795,9185796,9185804,9185808,9185829,9185830,9185831,7015486,9185832,7015487,7015488,7015489,7015490,9185836,7015491,9185851,9185854,9185855,4974715,9185863,4974716,9185864,4974719,4974720,4974721,4974722,4974723,4974724,4974726,4974727,4974730,4974731,4974732,4974733,4974739,9185892,9185895,9185905,9185908,9185916,9185921,9185930,9185938,9186012,10118247,9186051,9186053,9186054,9186127,9162145,9186148,9186182,10514015,9186354,9186357,9186358,9186359,9186360,9186757,9186772,9186773,9186774,9186775,9186778,9186779,9186780,9186784,9186787,9186797,9186798,9186799,9186801,10516678,10516914,10516916,10516918,7057449,10416359,10416363,10416386,9160499,10419450,10419457,10419469,10419472,10419473,10419474,10419475,10419476,10419477,10419478,10419479,10419480,10419481,10419482,10419483,10419484,10419500,10419528,10419568,7054871,9168721,10419669,10419670,10419710,10419716,10419717,10415727,10419733,10419748,10419749,10419750,10419751,10419752,10419753,10419754,10415793,10415816,10419817,10419819,10419820,10415831,10419846,10419849,10415881,10419894,10419966,10420014,9193119,10417061,10417068,10417078,10417089,10417090,10417091,10417101,10417102,10417113,10419114,10417114,10417115,10417116,10417117,10417118,10417119,10417120,10417121,10417122,10417123,10417124,10417125,10417126,10417127,10417128,10417129,10417130,10417131,9209260,10419190,8549462,8549463,7019977,9190335,7020005,7020033,8549560,8549562,7020061,8549564,8549566,8549567,10463029,9174513,7020186,7020214,10467160,7020242,8549883,10463315,10467327,7020469,10467409,7020493,7020517,9166869,7020541,7020565,7020589,7020613,7020637,9198995,10469573,7020686,9175046,7020739,8550264,7020764,7020789,10463728,7020810,10463739,7020830,10465760,9175184,7020851,8550359,7020873,7020894,7020914,9175274,7020934,9175282,10465867,9175301,9207302,7020980,10465910,10463922,7021084,9175430,7021104,7021137,8550664,10470089,9175727,9175728,10466306,10466309,8550898,9207774,9175807,8550974,8550975,9175882,9175883,9175884,9175894,10462474,9175922,9167993,9192016,9168073,9168101,9192232,10176225,10877492,10163547,10632161,10632162,10632163,10632164,10632165,10877721,7001072,7001079,10153992,10153993,10153996,10627580,10627588,10627630,10630068,10630070,10630078,10161604,10630089,10630146,10630273,10630274,10172074,10172080,10172082,10172089,10172092,10162246,10162247,10172262,10626125,10626229,10626238,10876751,10626241,10626242,10626244,10631247,10631248,10631249,10626259,10626292,10626293,10626343,10626378,10626379,10167924,10631419,10631420,10631421,10626447,10168025,10168072,10877124,10626817,10945212,10568126,10598567,10598568,10598569,10598570,10598571,10598588,10598589,10598602,10598603,10598606,10598620,10598626,10598631,10598632,10598633,10598634,10598635,10598636,10598637,10598638,10598640,10598641,10598644,10598645,10598656,10598657,10598658,10598665,10598668,10598669,10598674,10598675,10598677,10598680,10598693,10598694,10598695,10598696,10598697,10598698,10598699,10598700,10598701,10598702,10598703,10598704,10598705,10598719,10598723,10598731,10598732,10598733,10598750,10598751,10598752,10598753,10598755,10598763,10598778,10598779,10598780,10598781,10598782,10598783,10598795,10598819,10598820,10598827,10598828,10598829,10598846,10598847,10598854,10598858,10590272,10590279,10590284,10590307,10582561,10591756,10579803,10579804,10579805,10579806,10539117,10529342,10539807,10539808,10528110,10528111,10528112,10528113,10528114,10528139,10528143,10528151,10528160,10528181,10528193,10528194,10528195,10530282,10530283,10522284,10522304,10522305,10522306,10522307,10522316,10522342,10522343,10522347,10522359,10522360,10522375,10522376,10522614,10522615,10528667,10522673,10522889,10524894,10520901,10520904,10520905,10520909,10527004,10539036,10539037,10421270,10422279,10422316,10421355,10498311,10420424,10420425,10420435,10420438,10420443,10420444,10498368,10420567,10420570,10424570,10424582,10422597,10423664,10423665,10423666,10423679,10421763,10422764,10421764,10424896,10421947,10421948,10421949,10421950,10421981,10421998,10425034,10425041,10425044,10425045,10425047,10425048,10425049,10425050,10425055,10423128,10423152,10423163,10477386,10484501,10484502,10486952,10474001,10478008,10478009,10493251,10493252,10493255,10476464,10487515,10487523,10476534) GROUP BY p.products_id ORDER BY CASE WHEN products_price = 0 THEN 99999999 WHEN products_price > 0 THEN products_price END asc ,p.products_specials desc
ERROR: Unknown column 'p.products_specials' in 'order clause'