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(10843427,8836214,8836216,8836250,8836251,7076288,7076291,7076293,10103986,10843773,10104638,4968332,10238479,10238480,10844802,10223134,8910604,8910605,10197290,10102864,10102876,10102922,7067444,8617860,8911229,10842937,10842940,8911250,10843021,10843024,10843035,10249998,10249999,10250000,10250001,10250002,7067765,7067801,10843100,8615236,8908495,8908496,6000198,6000199,10840218,7072148,7072149,7072150,7072151,7064386,10931903,10931904,10931905,10931906,8909075,8909076,10234785,7064652,10196186,10196187,10222305,10101736,10196321,10274344,10274361,10209517,10235591,10235592,10235593,10235594,10235595,10235596,10235597,10932917,10235924,10222959,8907436,8907489,10233359,10233360,10246376,10233379,10233380,10285520,10285526,10285531,10285532,10285533,8907904,10194861,10194862,10194896,10839994,10231137,10231138,10231141,10231147,10231154,10231164,10231165,10231167,10231168,10231169,10231170,10231171,10231173,10231174,10231175,10231176,10231177,10231178,10231179,10231181,10231194,10231195,10231197,10231199,10231200,8612468,10231415,10231416,10231547,10231548,10283598,8612862,8612936,10232122,10941691,10941693,10941695,10941697,10941698,10941755,10941758,10941762,10941770,10941774,10838527,8906891,8906901,10942141,8907037,8860397,8860555,10838966,10838967,10838973,10838978,10838980,8907292,10838991,8860613,10838992,7070793,10229126,10229158,10281212,10229222,10229223,10229224,10229225,10229226,10229227,10229234,10426009,10229359,10229366,10618274,10229374,10229375,10229381,10229383,10229384,10229385,10433248,10229537,10229543,10229544,10229545,10229546,10229558,10229595,10229597,10229598,10229624,10229634,10229635,10229642,10229649,10229650,10229651,10229655,10229660,10433521,10623732,8904188,8904189,8904210,8904222,8904224,8904226,8904232,8904234,8904236,8904242,8904254,8904260,10229914,10229915,10229916,10229919,10229920,10229970,10190981,10229985,10230001,10230002,10230003,10230008,10230010,8904382,8904405,8904420,10230073,10230075,10230079,10230084,8611258,8611259,8611260,8611374,10204252,10204253,10204254,10204255,10230298,10230299,10230301,10230302,8611455,8611459,8611466,8611467,8611468,8577911,10619353,8577968,8577969,10282568,10282600,10282603,10282604,10282605,10282606,10282607,10282608,10282609,8905217,8905218,8905220,8905251,8905252,8905253,8905262,10619924,10619925,10619926,10228140,10228141,10228142,10228143,10228144,10927562,10432046,8575733,8575734,8575735,8622491,10617332,10617352,10617353,10617397,10617410,10617422,10617425,10617434,10617435,10617455,10425359,8576181,10425387,10425388,10425389,10425392,10425485,10425551,10425556,10425566,10425571,10928353,10280960,10615179,10615229,10620303,10615329,10615330,10615343,10447777,10447781,10447787,10447796,10447806,10239745,10615711,10615894,8574480,8574485,8574497,8574501,8574504,8574505,8574512,8574522,8574523,8574528,10616044,10616045,8621467,10188594,8583434,8583487,10431606,10616888,10616905,10922436,10922437,10922441,10922443,10922444,10922445,10922446,10922447,10922448,10922449,10922450,9205324,9205341,9205343,9205346,10565155,10565158,10614054,7019062,7019097,7019135,10565328,7019290,7019324,7019356,7059883,6665742,10714271,10614495,10614552,10614553,10614554,9173955,9173979,9174013,9174014,9174015,9214037,9214038,9174048,9174049,9174062,9174063,9174064,9174074,9174075,9174083,9174087,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,7017840,7017841,10612940,7017939,10612941,7017959,8862830,8862835,9212318,7017979,9188357,9196358,9188364,9188365,9188366,9188370,9188379,9188394,10613081,10613082,9196444,10613107,10613109,7018178,10613369,10613434,7018514,7018548,7018582,7018616,7018650,10613736,10613812,10613813,10613814,10613815,7018822,9189174,9189175,9189176,7018856,7018890,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,4974716,9185863,9185864,4974719,4974720,4974721,4974722,4974723,4974724,4974726,4974727,4974730,4974731,4974732,4974733,4974739,9185892,9185895,9185905,9185908,9185916,9185921,9185930,9185938,9186012,10118247,10118248,9186051,9186053,9186054,10118273,9186127,9162145,9186148,10118365,10118367,10118373,9186182,10514015,10118516,9186354,9186357,9186358,9186359,9186360,10118606,10118679,9186757,10118965,9186772,9186773,9186774,9186775,9186778,9186779,9186780,9186784,9186787,9186797,9186798,9186799,9186801,10119045,10119046,10516678,10516914,10516916,10516918,10119336,10119352,10119353,10119393,10119417,10119418,10119419,10119420,10119421,10119433,10119434,10119435,10119436,10119437,7057449,10416359,10416363,10416386,9160499,10116701,10116710,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,10419733,10419748,10419749,10419750,10419751,10419752,10419753,10419754,10419817,10419819,10419820,10419846,10419849,10419894,10419966,10420014,9193119,10417061,10417068,10417078,10417089,10417090,10417091,10417101,10417102,10417113,10417114,10419114,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,7020061,8549562,8549564,8549566,8549567,9174513,7020186,7020214,7020242,10467160,8549883,10467327,7020469,7020493,10467409,7020517,9166869,7020541,7020565,7020589,7020613,7020637,9198995,10469573,7020686,9175046,7020739,8550264,7020764,7020789,7020810,7020830,9175184,10465760,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,9175922,9167993,9192016,9168073,10116289,10116291,10116292,9168101,9192232,10883571,10883624,10883625,10883627,10883629,10883668,10884082,10884083,10884084,10884085,10884423,10884697,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,10876751,10626238,10626241,10626242,10626244,10631247,10631248,10631249,10626259,10626292,10626293,10626343,10626378,10626379,10167924,10631419,10631420,10631421,10626447,10168025,10168072,10877124,10626817,10654722,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,10424570,10420570,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'