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(10224362,10224363,10224364,7076154,10224451,10224476,10224536,10224537,7068308,7068309,7068339,10263623,10263624,10263625,10263626,10263627,10263628,10263629,10263630,10263631,10263632,10263633,10263634,10263635,10263636,10263637,10263638,10263639,10263640,10263641,10263642,10263643,10263644,4970921,7068709,7074164,10199610,10225698,10225699,10238767,10251800,10251801,10238845,10238846,10238847,10238848,10199945,7074750,10239019,7074831,7074843,7074849,7074859,7074892,7066927,8067956,8067957,8067958,8067959,8067991,8067992,8067993,8067994,8067995,8068067,8068068,8068069,8068070,8068071,8068072,10262346,10262347,8068131,8068132,8068133,8068134,8068135,8068136,8068137,8068138,10197446,8068253,10262558,10262559,10262560,10262561,10197562,10262562,8068307,10262563,10262564,10262565,10262566,8068363,8068364,8068365,8068366,8068367,8068368,8068398,10197673,10197674,10197675,10197676,10197677,10197678,8068430,8068431,8068473,8068484,8068519,8068602,8068608,8068619,10197905,10197906,8068652,10197907,8068653,8068672,8068691,8068699,8068724,8068750,8068755,8068756,10234405,10234414,7072350,7072361,7072370,7072373,10260627,10260628,10260629,10260630,10260631,10260632,10260633,10260634,10208635,7072397,7072398,10221712,10221717,10221718,10221729,10221730,10221732,10221733,10221734,10221745,10221758,10221843,10221844,10221845,10221846,10221847,7072618,7072619,7072620,10221868,10221869,7072677,10221941,10221942,10221943,10221944,10221945,7072721,10932202,7072767,7072768,10932207,10932208,10248053,7072820,7072917,10209193,10209194,10209195,10235200,10235201,10235312,10235313,10261316,10261317,10261318,10261319,10261320,10261321,10261322,10261323,10261324,10261325,10261326,10235402,10235403,10235457,10261506,10261507,10261508,10248597,10261833,10248932,10222982,10222983,10222984,10222985,10222986,10222987,10222988,10222989,10222990,10222991,8860988,10942830,7071158,8861079,10942926,10942970,10942971,10943017,10943041,10943046,10943090,10259638,10259639,10259640,10259641,10259642,10259643,10259644,10259645,10259646,8861337,10233824,10233863,10233937,7068964,10940693,10244222,10244223,10940715,10940716,7069038,10244652,10244653,10244654,10244655,10244656,10244657,10244658,10205806,10205807,10205808,10205809,10205810,10205811,10245019,10245097,10232492,10232493,10206509,10232592,10232593,10245793,10232870,10232871,10245967,10923495,10923496,10923497,10618026,10618027,10923548,10923549,10923571,10923581,10923630,10242245,10242246,10242247,10618155,10242248,10923762,10923763,10923764,10923765,10923766,10923767,10923768,10923769,10923770,10923771,10242398,10623306,10242399,10923843,10923844,10923845,10923904,10923905,10923906,10923907,10923908,10923909,10923910,10923911,10923912,10242530,10242531,10923983,10923984,10923985,10924071,10924072,10924073,10924074,10924075,10924107,10242716,10242717,10924173,10924174,10924175,10924235,10924236,10924237,10924238,10924267,10924274,10924275,10216937,10924448,10924449,10924450,10924451,10924452,10924453,10924454,10924455,10924456,10924457,10924458,10924459,10924460,10924461,10924462,10924463,10924464,10924465,10924466,10924467,10623959,10924771,10924915,10924916,10924917,10924918,10243696,10925116,10925117,10925172,10925288,10925289,10925290,10925291,10925292,10925293,10925294,10925295,10925296,10925397,10925398,10925466,10925467,10925468,10925469,10925470,10617000,10617086,10617087,10922653,10922654,10922655,10922656,10922657,10922658,10922659,10922660,10922661,10922662,10922663,10617155,10617156,10922676,10922686,10922720,10617218,10241310,10241311,10922743,10617255,10922772,10922773,10922774,10622406,10241516,10241517,10241518,10923007,10923041,10923069,10923070,10923071,10923072,10923084,10923095,10923130,10923131,10923157,10923158,10241755,10923242,10923243,10923295,10923296,10923297,10923298,10923299,10241899,10923368,10622909,10923431,10242038,10923457,10923458,8569809,10925495,10615088,10615266,10920781,10920782,10925850,10925870,10620371,10920997,8570351,8570354,8570355,10615681,10615717,10921282,10930646,10921427,10921551,10921650,10240309,10240310,10240311,10253354,10921782,10921783,10621288,10621289,10616334,10616335,10616336,10616337,10616338,10616339,10616340,10616341,10616342,10616343,10921904,10921905,10921906,10921907,10921908,10921909,10253505,10621426,10621450,10616462,10621531,10621532,10621533,10621568,10253690,10621621,10621622,10621623,10621625,10621667,10621674,10621677,10621678,10621679,10621680,10616689,10616690,10616691,10616692,10240787,10240788,10253791,10621728,10621746,10621747,10241043,7059522,10614160,10614296,10614299,9189675,9189694,10614377,10614407,10614532,10614637,9190056,10562957,10562958,9190197,8864814,10612104,10612105,7057771,9187639,9187730,9187731,9187732,10612414,9187921,9187922,10612848,10612883,10612909,10613075,10613293,10613300,10613301,10613365,10613388,10613391,10613394,10613395,7058919,10613496,10613540,10613541,10613543,10613544,10613546,10613547,10613548,10613553,10613554,10613559,10613561,7059082,8863439,7059117,8863500,10613652,10613663,10613664,7059169,10613672,7059239,8863620,8863623,7059289,7059290,7059393,7059410,7059434,7055538,9169720,4974765,4974766,4974769,4974776,4974783,4974824,4974842,4974871,4974872,4974873,4974890,4974891,4974892,4974893,4974894,4974895,2809395,2809398,10512814,10516998,10516999,9171192,9171214,9168889,9168957,9168958,9169111,10420065,10417131,10469162,10469164,10469185,10469189,10469196,10469211,10469237,10469250,10469533,10469534,10467570,9175054,10465682,10465683,10465684,10465685,10465686,10465687,10465688,10465689,10465690,10465691,10465692,10465693,10465694,10465695,10465696,10465697,10465698,10465699,10465700,10465701,10465702,10465703,10465704,10465705,10465706,10465707,10465708,10465709,4972043,9183309,4972165,10467921,10469928,4972204,10467929,4972224,10467972,4972254,10468090,10470112,8917217,4972446,10468222,10470403,10470524,10470671,10169485,10169486,10169487,10169512,10169513,10169536,10169555,10164589,10628091,10169632,10169633,10169712,10174713,10169721,10169737,10169769,10169770,10174772,10174773,10169781,10169782,10169792,10169793,10169794,10169817,10169876,10169922,10169940,10169941,10169981,10170031,10165241,10165242,10170327,10170441,10170442,10170443,10170567,10170652,10170653,10166089,10166193,10629936,10629937,10168485,10168506,10168507,10168586,10168587,10168588,10168624,10168632,10168633,10168816,10168844,10168896,10168898,10168948,10168949,10168958,10168959,10168960,10173977,10168988,10168989,10169033,10169080,10169081,10169082,10169083,10169084,10169085,10169160,10169161,10169162,10169180,10169202,10169203,10169204,10169205,10169206,10169207,10169208,10169254,10169255,10169286,10169287,10169288,10169289,10169290,10169353,10169354,10169355,10169356,10169357,10169358,10169379,10169388,10169389,10169420,10169421,10169422,10169423,10630070,10630071,10630103,10166719,10166720,10166721,10166722,10166811,10166812,10166855,10161884,10166955,10166956,10630533,10630534,10630535,10630536,10630537,10630627,10162177,10167198,10167199,10630730,10630731,10630732,10630733,10167310,10167349,10630863,10630864,10630917,10630918,10630919,10630920,10630921,10630922,10631003,10631029,10162689,10162690,10162691,10162692,10162693,10162694,10162695,10162696,10162697,10162698,10162699,10162700,10162715,10162716,10162717,10631214,10631215,10631216,10631217,10631218,10631219,10631220,10631229,10162796,10168054,10168098,10168214,10168215,10168303,10168304,10168305,10168306,10168307,10168308,10168375,10168415,10577229,10571495,10577571,10577572,10577573,10577574,10577575,10577576,10577577,10571667,10580694,10568705,10568706,10580706,10580707,10577770,10580804,10580805,10580806,10574825,10568910,10577934,10577935,10577936,10571947,10571948,10580952,10574966,10574967,10574968,10574969,10574970,10581015,10581076,10578097,10575215,10575216,10575217,10575218,10572371,10572372,10575466,10575578,10575579,10575580,10578934,10578935,10578936,10578937,10578938,10578939,10575999,10579138,10576779,10576780,10576781,10576782,10576783,10576784,10576785,10576786,10576989,10523750,10527768,10523769,10523770,10523771,10523772,10523773,10523774,10523775,10523776,10523777,10523778,10523785,10523786,10523787,10523788,10523799,10523800,10523801,10523802,10527803,10524592,10524593,10524710,10524711,10524712,10524720,10423816,10421099,10479135,10481229,10481230,10481231,10481232,10481451,10481452,10481453,10481634,10479672,10479673,10479674,10479675,10479676,10479677,10481727,10481728,10481729,10481730,10481731,10481732,10479832,10479833,10479834,10479835,10479836,10479837,10479885,10479944,10479945,10477966,10480016,10480017,10480018,10480019,10478052,10480097,10480098,10480219,10480220,10480221,10480222,10480223,10480224,10480225,10480226,10480227,10480285,10480286,10480287,10480288,10480345,10480405,10480406,10480407,10480408,10480477,10480478,10480531,10480532,10480533,10480534,10480558,10480559) 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'