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(11014787,11014788,8574311,8574312,8574313,10943629,10943630,10943631,10943632,11015116,8569419,8569420,11015150,11015151,11015153,7068526,7068527,7068528,7068529,7068530,7068531,7068532,7068533,7068534,7068535,7068536,10940302,10940303,10940304,10874003,8583206,8583207,8583208,8631568,10976638,10976639,10976640,10976641,10976642,10976643,10976644,10976645,10976646,9215716,9215717,9215718,9215719,9215720,9215721,9215722,10868504,10868505,10868506,10951226,8067861,8837636,3227590,3227591,7067389,11014237,11027377,11027555,11014556,11027556,11027557,11027605,8594773,8594774,8594775,11024856,11024857,11024858,11024859,11025085,11025086,11025087,11025088,11025089,11025126,11025127,11025128,11025129,11025130,11025131,11025132,11025133,11025134,7064493,7064494,7064495,7064496,7064497,7064498,7064499,7064500,7064501,11012259,11012477,11012478,11012535,11012536,11012537,8595543,8595544,8595545,8572239,8572240,6665682,10843916,8066178,8066179,11012971,11012972,11012973,11012974,8619286,10928868,10928869,11013348,11013474,4968081,4968082,4968083,4968084,4968085,4968086,4968087,4968088,4968089,4968090,4968091,4968092,4968093,4968094,4968095,4968096,4968097,4968098,4968099,4968100,4968101,4968102,11013571,4968103,4968104,11013572,4968105,4968106,4968107,4968108,4968109,4968110,4968111,4968112,4968113,4968114,4968115,4968116,4968117,4968118,4968119,4968120,8619740,11013615,10102303,8064676,8064677,8064678,8064679,8064680,8064681,8064682,8064683,8064684,8064685,8064686,8064687,8064688,8064689,8064690,8064691,8555882,8555883,8624680,10944489,10100309,10100310,10100311,8564008,8564009,8564010,8564011,8564012,8564013,8564014,8564015,11047637,11047638,10841234,10841235,10841236,3927034,8834245,11006662,11006738,7156624,11019814,11019818,7156909,7156988,8613314,3924322,10920129,10920130,10920169,10920170,8552917,8552918,8552919,8552920,8552921,8552922,8552923,8552924,8552925,8552926,8552927,8552928,8552929,8552930,8552931,8552932,8552933,8552934,11005692,11031693,11018888,11018889,11018890,11018891,11018892,11018969,11018970,10837191,10837192,10837193,10837194,10954202,10954203,10954204,10954205,10954206,10954207,10954208,10954209,10954210,10954211,10954212,10954213,10954214,10954215,10954216,10954217,10954218,11006223,11006253,11006254,11006255,11006256,7156154,11006461,11006462,11032484,11006505,11006506,11006540,11016804,11016805,11016806,11016807,11016808,11016809,11016810,11016811,11016812,11016813,11016814,11016815,11016816,11016817,11016818,11016819,11016820,11016821,11029871,10425588,11017030,11017031,11017032,11017033,11017034,11017035,11017036,11017045,10915907,10915908,10915909,10915910,10915911,11004192,10850808,10850809,10850810,10850811,10850812,10620925,10620926,10620927,10620928,10620929,10620930,10620931,10620932,10620933,7154540,7154541,7154542,11004688,11004810,10426623,10426624,10426625,10917093,10917094,10917095,10917096,10917097,11005291,11005292,3232123,11005575,8567869,8567870,8567871,8567872,6677654,6669792,9915814,9915863,9915864,9915865,6677907,6677908,6677909,6677939,6677940,9916096,9916097,9916098,6678306,9916357,8861868,10120216,10120217,10120218,10120219,10120220,10120221,10120222,10120223,10120224,10120225,10120226,10120227,10120228,10120229,6676338,9914400,8863280,8863281,8863282,8863283,3654088,9915382,9915383,9915384,9915388,8592583,9177586,9177587,9177588,9177589,9177590,4974464,9201620,9201621,9161698,9161699,9161700,9161701,9161702,9161703,9161704,9161705,9161706,9161707,9161708,9161709,9161710,9161711,9161712,9161713,9161714,9161715,9161716,9161717,9161718,9161719,9202058,7056335,7056336,8551594,8551595,8551596,8551597,8551598,8551599,8551600,2809147,2809148,2809149,2809150,2809151,2809152,2809361,3651965,3651966,3651967,3651968,9202954,9202955,8565773,8565774,8565775,8565776,8565777,8565778,8565779,9200466,8848354,9910885,9910886,9910887,9910888,9910889,9910890,9910891,9910892,9200726,10428104,7054931,7054932,9200840,9200915,9201019,10117398,8849053,9201242,9201243,9201244,8849083,8549568,8549569,8549570,8549571,8549572,8549573,8549574,6678639,10122665,10122666,9174501,6678758,6670786,6670787,6670788,6670789,6670790,6670791,6670792,6670793,6670794,6670795,6670796,6670797,6670798,6670799,6670800,6670801,6670802,6670803,6670804,6670805,6670806,6670807,6670808,6670809,6670810,6670811,6670812,6670813,6670814,6670815,6670816,6670817,6670818,6670819,6670820,6670821,6670822,6670823,6670824,6670825,6670826,6670827,6670828,6670829,6670830,6670831,6678832,6678876,4971884,4971885,4971886,4971887,4971888,4971889,4971890,4971891,4971892,4971893,4971894,4971895,4971896,4971897,4971898,4971899,4971900,4971901,4971902,8855018,6679438,6679449,10463956,10463957,10463958,10463959,10463960,10463961,10463962,10463963,10463964,10463965,10463966,10463967,10463968,10463969,10463970,10463971,10463972,10463973,10463974,10463975,10463976,10463977,10463978,6679787,6679795,976596,9207888,9207955,10116172,10116173,10116174,10116175,10427446,10179484,10913523,10913524,10913525,10913526,10913527,10913528,10883553,10946464,10946465,10946466,10946467,10946468,10946469,10946470,10946471,10946472,10946473,10946474,10946475,10946476,10946477,10946478,10946479,10946480,10946481,10946482,10946483,10946484,10946485,10946486,10946487,10946488,10174711,10174756,10179826,10179836,10155599,10155600,10155601,10155602,10155603,10155604,10155605,10155606,10155607,10155608,10155609,10155610,10155611,10155612,10155613,10155614,10155615,10155616,10155617,10155618,10155619,10155620,10155621,10155622,10155623,10155624,10155625,10155626,10155627,10155628,10155629,10155630,10155631,10155632,10155633,10155634,10155635,10155636,10155637,10155638,10155639,10155640,10155641,10155642,10155643,10155644,10155645,10155646,10155647,10155648,10155649,10155650,10155651,10155652,10155653,10155654,10155655,10155656,10155657,10155658,10155659,10155660,10155661,10155662,10155663,10155664,10155665,10155666,10155667,10155668,10155669,10155670,10155671,10155672,10155673,10155674,10155675,10155676,10155677,10155678,10155679,10155680,10155681,10155682,10155683,10155684,10155685,10155686,10155687,10166330,10166331,10166332,10630021,10896176,10896177,10896178,10896179,10896180,10896181,10896182,10896183,10896184,10896185,10896186,10896187,10896188,10896189,10896190,10896191,10896192,10896193,10896194,10896195,10896196,10896197,10896198,10896199,10896200,10896201,10896202,10896203,10896204,10896205,10896206,10896207,10896208,10896209,10896210,10896211,10178057,10178189,10178202,10178203,10877232,10877234,10877235,10877236,10877237,10877238,10877239,10877240,10877241,10877242,10877243,10877244,10877245,10877246,10877247,10877248,10877249,10877250,10877251,10877252,10877253,10877254,10877255,10877256,10877257,10877258,10571664,10571665,10602575,10568952,10569303,10644418,10644419,10644420,10644421,10644422,10644423,10644424,10644425,10644426,10644427,10644428,10644429,10644430,10644431,10644432,10644433,10644434,10644435,10644436,10644437,10644438,10644439,10644440,10644441,10644442,10644443,10644444,10644445,10644446,10644447,10644448,10650628,10650629,10650630,10650631,10650632,10650633,10650634,10650635,10650636,10587809,10587810,10587811,10587812,10587813,10587814,10575841,10575842,10575843,10575844,10575845,10585042,10570114,10570115,10604147,10604148,10604149,10604150,10604151,10604152,10604153,10604154,10604155,10604156,10604157,10604158,10604159,10604160,10604161,10604162,10604163,10604164,10604165,10604166,10604167,10604168,10604169,10604170,10604171,10604172,10604173,10604174,10604175,10604176,10604177,10604178,10604179,10570619,10570620,10570621,10570622,10570623,10570624,10570625,10570626,10570627,10570628,10570629,10570630,10570631,10570632,10570633,10570634,10573798,10649022,10649023,10649024,10649025,10601898,10522965,10522966,10421038,10421039,10479005,10479006,10479007,10479008,10479009,10479010,10479011,10479012,10408037,10408038,10408039,10493577,10493578,10493579,8562059) 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'