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(8561907,7068093,3228509,10943515,3228520,3228576,10931086,10943683,10846043,10931193,10939940,10846143,10846148,10846149,10846151,10846154,10846158,10846160,10846163,9215064,10846166,10846167,10846168,10846169,7068425,10940083,10943905,4970820,4970857,7068652,7068661,10950303,10950304,10989396,8621558,8621559,8569709,10976466,4971009,11041484,10989493,10989494,11015494,11015495,11015496,11015497,11015498,11015499,11015500,11015501,10989502,10989503,10989505,10989508,4971101,10976699,4968250,7066097,10989792,8583589,10933493,10950773,10933524,10933525,10963988,7066335,10990023,10990134,8583921,10990135,10990138,10990141,11029152,8575673,10964226,10964232,10964313,4968936,10990405,4969016,4969017,8622657,10872124,10872127,8632496,8632503,11042553,10938511,10860252,8067869,10938629,10844775,4969352,4969353,8561158,4969471,4969476,4969480,4969481,4969483,4969485,4969488,10961983,10961984,10961985,10961986,8591546,10929733,10962282,11014457,10845548,8838315,10998745,8594817,10103388,10103392,10843035,10959973,11011984,10931679,7064343,10843129,10960090,7064541,10858843,10858844,10858845,10858846,7064665,7064666,7064667,7064668,8595318,8065726,8065750,8595421,10843571,8595533,10960589,8595549,4967166,8572297,8572298,8572299,8572300,8572301,8066158,8595900,4967494,4967512,4967534,8560359,8560482,8837076,10104736,8629269,8629270,3227056,3227067,10104803,10987367,10987368,10987372,8572875,7065833,10929118,3227277,10958644,10865306,10997704,3927460,10865409,10102251,10102312,8834764,8834765,7200521,7200522,7200523,7200524,7200530,7200531,7200532,7200533,8064595,4430252,8910743,7200978,8835237,8835238,10972446,10972447,10972448,10972449,10102932,6000085,6000088,10842562,10858187,10858188,10985585,10995623,8614780,10944367,10944368,10995635,10995636,10995637,8614839,10100176,10944554,10100377,10100378,10840021,8556268,10840076,10840077,3655909,10957043,8564072,8564073,8564074,3235881,8564199,8564200,10840312,10840313,11009344,3926131,11047685,10100948,10957603,10996622,10856234,10996632,10957641,10957643,7199265,8557056,8557057,7199358,11009799,11009800,8557171,8564999,3236722,3657032,3926888,3236944,3236955,3236960,3236961,3236969,3657181,3657185,3657187,3657191,7070753,3237224,10102023,3237338,10837717,8554055,8554061,10618166,10618172,3233735,10955016,10955017,10994311,10994312,11046316,11046350,11046360,11046398,11020424,7197063,11033504,3234284,3924442,3234780,8907513,10839257,10839367,11021387,10619894,10995619,10621966,11005658,8553045,8553046,10617471,10617570,3922958,3922959,3922960,11045273,11045274,8553657,8553662,10993437,3923169,10967512,8542342,8542362,10993551,10928441,10993593,10993599,10993601,8612759,10990623,10964699,10964700,8609879,10990794,10990797,10425549,10925890,10925893,11004156,10848282,10850865,10850868,3581958,3581959,10926175,10926176,10991359,10991360,10930671,10851002,10926285,3231173,9217437,10930779,10615984,10851296,10930968,7154588,10991817,10426500,10426501,10426502,10426503,10426504,10926708,3231641,8540740,8540741,10616302,10616303,10616311,10616323,10616324,10991984,10926852,10992005,10953062,11044063,11044065,10616411,10616412,10921963,10616453,8904649,10992379,10966419,10427185,9915531,9915532,9173327,9173368,9173372,9173378,10611310,10121890,7059886,9173726,8864326,8853631,8568320,9916033,10122097,8864445,9214145,10614819,10122381,8549451,8861874,9913571,8861914,8861915,8861916,9171409,9171410,9171411,10609213,8862124,10609343,3652903,10119945,8566258,10120009,9180036,3653292,10609764,10609765,10612804,9172146,3653392,8862767,8862768,8862769,10610025,10610056,10610057,10613116,9188471,9188474,9188477,9188515,9172774,9220941,10613718,10121274,9213109,9213123,9213132,6677364,10564990,8863700,9213180,9213201,9915434,9915435,9915436,8863797,10117525,9177400,9177438,7055765,9177610,9161774,9185831,8592986,4974702,9169852,9161875,9161880,4974737,9161885,8593108,9162045,10517918,10517919,10517920,10517941,8850035,8850036,10518040,9162361,9162362,9162363,9162364,9162365,9162366,9162367,8551689,8551690,8551805,2809157,2809158,8551876,10118812,3651823,2809260,8552000,9186778,9186827,8552131,8552133,8552134,9178852,9178853,9178854,9186855,9186859,7057170,7057171,7057172,9171023,9171024,10518952,8861676,10517006,10517010,9179293,10427713,9192338,9160338,9192339,9160339,9192340,9160340,9192341,9160341,9160342,9192343,9160343,9192344,9160344,4973211,10427744,9160387,8918054,10415349,10417463,10418464,9184659,10418614,6680941,9160742,7054936,9910981,9168775,9208791,9184859,9160896,9176943,10419897,9911184,7055209,7055246,9161185,10117419,7014896,10416214,9916518,3962653,3962654,3962655,3962656,3962657,3962658,3962659,3962660,10122596,8568913,6678633,10122638,8549603,10467037,9174534,9190576,10465225,10467227,6666725,10471312,10465329,10471355,10465370,9206817,10465428,6671073,6671074,6671075,4971733,4971740,10471520,10471521,9166964,9166972,3963294,9183002,4971869,8550177,6667156,6667157,6665405,6665406,6665407,9175230,9167233,6679495,6679507,8563222,8563224,10465912,8563301,8563302,10115611,10115612,10115613,10115614,10115615,10115616,10115617,6671669,10466069,10466070,10464115,9175566,8917337,8563595,10115904,10115921,10124048,10464555,8551193,10464632,10116287,9168121,10464740,4973050,10116402,10116403,6672482,10903561,10946406,10154645,10946514,10878707,10903708,10878716,10628239,10946612,10903830,10903835,10159917,10878907,10946721,10946722,10884135,10904197,8594210,10889210,10628703,10889213,10628710,10628711,10155478,10155479,10884576,10884804,10155847,10894897,10875004,10875005,10875007,10875011,10875012,10875013,10875014,10875015,10875016,10875017,10910049,10171074,10171091,10905110,10156157,10156158,10156159,10156160,10156161,10156162,10156163,10156164,10156165,10156166,10156167,10156168,10156169,10156170,10156171,10156172,10156173,10156174,10156175,10156176,10156177,10156178,10915208,10915209,10915210,10915211,10895237,10905254,10875328,10910435,10902505,10632100,10892630,10902735,10877819,10877822,10183890,10183894,10627372,10183895,10183896,10877939,10877940,10877941,10877942,10877943,10877944,10877945,10907971,10159075,10159076,10159077,10159078,8593269,10159386,10161517,10161549,10161550,10900544,10890587,10890590,10890592,10161614,10161655,10910706,10625256,10625259,10895823,10895845,10171871,10171872,10910909,10875931,10895943,10905960,10895960,10895973,10906020,10906021,10906022,10891056,10886064,10886065,10177094,10187131,10177170,10177177,10177179,10177205,10177216,10177221,10177222,10177228,10177239,10911239,10911240,10911241,10911242,10896277,10949134,10162395,10881469,10881501,10891637,10911851,10891948,10949967,10902168,10892177,10626676,10188237,10882241,10902270,10882324,10882325,10163343,10907349,10882376,10158443,10877437,10646213,10583174,10605091,10592248,10571272,10592303,10592310,10592311,10592317,10592322,10598326,10598327,10598332,10598351,10598354,10602241,10598441,10583467,10652528,10652531,10595507,10595508,10595517,10595565,10608457,10595641,10595648,10571686,10608563,10595757,10643826,10596078,10596141,10596155,10596156,10596158,10596177,10606198,10606199,10606200,10606201,10606202,10606203,10596387,10606313,10566672,10653841,10644900,10644901,10644902,10644903,10644904,10644905,10647914,10647922,10647923,10650968,10603777,10651096,10648332,10648338,10585333,10585334,10573347,10651421,10654428,10604361,10645633,10582603,10648749,10588727,10607672,10579874,10648941,10648990,10646028,10598021,10521268,10547675,10521846,10548138,10548139,10548140,10548141,10548142,10548143,10548144,10548145,10548146,10548147,10530200,10530201,10530202,10548957,10527028,10527029,10533048,10533049,10533050,10533051,10533052,10423322,10423325,10423366,10420401,10509318,10509329,10498367,10420494,10505419,10498499,10420629,10498639,10498640,10498642,10498686,10421006,10503943,10503959,10503969,10425159,10478891,10478927,10411321,10479050,10409397,10409411,10407508,10477290,10496327,10486454,10486576,10492630,10492646,10477663,10477673,10477675,10477676,8563035,10486724,10477724,10408070,10477726,10408072,10408075,10496818,10496819,10486825,10496853,10496879,10408269,10714608,10474035,10474038,10714705,10714745,10487115,10408483,10408485,10408488,10408492,10408565,10408567,10485228,10478299,10482310,10412758,10412759,10482525,10482526,10489568,10408923,10408924,10485637,10485639,10476666,10409058,10409059,10495738) 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'