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(7075855,8068842,7075859,7076094,10943619,10943620,10943621,10943622,10943623,10943624,10943625,10943626,10943627,10198546,10198547,10198548,7076337,7076339,7076341,7076342,7076344,7076345,7068356,7068360,7068361,7068362,7068363,10198704,10198705,10198706,10198707,7068683,7068684,7068685,7068686,7068687,7068688,7068689,7068690,7068691,7068692,7068693,7068694,7068695,8569734,10199287,10199288,10251739,10212756,7066518,10212757,10212758,10212759,10212760,10212761,10212762,10251763,10212763,10212764,10212765,10212766,10212767,10251768,10251769,7066565,10212810,10200014,7074844,7066873,8067859,10197129,10210612,10210613,10210614,10210615,10210616,10210617,10210618,10210619,10210636,10210637,10210638,10210639,10210648,10210649,7075449,7075510,7075511,7067685,10249969,10249970,10250019,10250020,10250021,10234384,10234492,10234493,10234494,10234495,10208646,10208655,7064458,7064459,10234828,10234848,10195909,10222388,10222389,10222390,10222394,10222395,10222396,10222397,10222398,10222449,10196466,10222470,10196472,10196473,10222473,10196474,10196475,10196476,10196477,10196478,10222514,10196691,10222704,10196871,4968029,10235971,10196998,10196999,10942633,7071222,7071245,7071246,7071263,7071296,10246542,10233547,10233549,10233550,7071312,10233551,7071335,10233592,10233593,10233707,10233708,10233709,7071565,10943315,10943325,10943327,10943404,10943408,10943415,10231057,10205060,10205061,10205062,10944336,10205063,10231244,10231259,10231260,10231261,10941787,10941792,10941808,10941826,10941828,10941832,10941834,10941885,10941895,10941999,10942020,10942099,7070718,7070756,7070789,7070804,7070809,7070812,7070813,7070814,10229196,10203362,10203363,10203364,10203365,10229386,10229387,10618334,10618335,10618336,10618337,10618338,10618347,10618348,10229663,10618611,10618707,10618708,10618709,10618710,10229842,10229854,10618764,10229875,10229876,10203954,10203955,10230016,10230039,10230040,10204196,10204197,10204198,10204214,10204215,10204223,10619238,10230388,10230389,10204434,10204435,10204436,10204437,10204438,10230459,10230460,10617212,10617475,10228670,10189788,10189789,10189790,10189791,10189792,10189793,10189794,10189795,10189796,10189797,10189798,10189799,10189800,10189801,10189802,10189803,10928306,10928307,10928308,10928309,10928310,10928311,10928312,10928313,10189896,10928314,10622919,10617955,10615144,8570017,8570018,8570035,10615352,10213466,10213467,10615482,10620487,10615557,8570521,8570522,8570523,10615822,10616044,10616045,10621077,10621078,10926808,10926809,10926810,10926833,10616475,10201596,10927066,10922072,10927077,10616655,10616656,10616657,10201772,10201773,10201774,10201775,10201777,10616804,10616888,10616907,10565225,10559248,10559249,10559250,7059604,10559251,10562267,10562268,10562269,10559296,9189502,9189504,10565318,9165554,7059744,10614271,9189637,9189638,9189639,9189640,9189641,9189642,9189646,9189647,10559477,10559478,7059863,9189737,9189738,9189739,9189740,9189741,9189742,9189744,9189745,9189746,6665789,9181856,10614538,9181880,9173934,9173935,10565885,10565886,10565887,10565888,10565889,10565890,10565891,10565892,10565957,10565958,10565959,9166157,10566064,10566065,7057480,7057481,7057483,7057486,7057490,8861860,7057519,7057520,7057521,7057522,7057524,7057527,7057528,7057529,9187504,10612342,10557513,10612559,10612624,7058148,8862638,10612845,9188204,9188205,9188235,9188246,9188249,9188277,9188278,9172315,9172358,10613066,9188426,9188487,9188488,9188489,9188510,10613175,10613176,9188519,9188520,10613191,10613192,9188557,9188558,10613232,10613233,10613234,10613385,9172734,9172740,9172745,10558579,10613555,10613666,10613667,10613670,9189059,9173082,9173083,9173084,9173096,9189156,9189168,9189227,9189229,9189230,9189232,9189233,9189234,9189235,9189243,9189251,9189252,9189255,9189256,9189258,9189259,9189260,9189264,9189265,9189272,9189273,9189278,9189279,9189282,9189283,9189284,7059458,9177317,9177318,9169352,9185361,10511184,10511185,10511204,10511205,10511206,10511207,10511208,10511234,10511235,10511236,10511237,10511238,10515243,10515244,10511281,10511282,10513287,10511301,10517317,9161505,10517318,9161506,9161507,9161508,9161509,9161510,9161511,9161512,10511333,10511381,10511382,9185600,9185602,9185642,9185654,10511477,7055836,9185681,9185682,9185683,9185684,9185685,9185686,9185687,9185688,9185689,9185690,9185691,9185692,9185700,10517552,9185786,9185787,10511607,10511608,10511609,10511610,10511611,10511612,10511613,10511614,10511615,10511616,10511617,10511618,10515629,10515630,10515631,10515632,10517682,10517683,10517684,10511711,10511712,9185950,9185951,9185952,9185953,9185954,9185955,9185956,9185957,9185958,9185959,9185960,9185962,9185963,9185964,9185965,9185966,9185967,9185968,9185969,9185970,9185971,9185972,9185974,9185975,9185976,9185977,9185978,9185979,9185981,9185982,9170095,9170096,10511919,10511920,10511921,10511922,10511923,10511924,10511925,10511926,10511927,10511928,10511929,10511930,10511931,10511932,10511933,10511934,7056288,10511935,10511936,10511937,10511938,10511939,10511940,10511941,10511942,10511943,10511944,10511945,10511946,10511947,10511948,10512062,10512063,10512064,10512065,10512066,10512067,10516142,10514162,10514163,10514182,10516187,9170379,10512205,10514215,10514216,10512218,10512219,10512220,10512229,10512230,10512231,10514243,10512299,10512300,10512301,10512302,10512303,10512304,10512305,10512306,10512307,10512308,10512309,10514309,10512310,10512311,10512312,10512313,10512314,10512315,10512316,10512317,10512318,10512319,10512320,10512321,10512322,10512323,10512324,10512325,10512422,10512423,10512424,10512431,10512432,10512433,10512454,10512455,10512456,10512457,10512458,10512459,10512460,10512461,10512462,10512463,10512464,10512465,10512466,10512467,10512468,10512469,10512470,10512471,10512472,10512473,10512474,10512475,10512476,10512477,10512478,10512479,10512480,10512481,10512482,10512483,10512484,10512485,10512486,10512487,10512488,10512489,10512490,10514494,10514495,10514496,9170700,10514516,10514517,10514518,10514519,10514520,10514521,10516535,10512540,10514541,10516561,10514561,10514568,10514569,10514677,10514678,10514679,10514680,10514681,10514682,10514683,10514684,10514685,10514705,10514706,10514707,10514708,10514709,10514710,10514711,10514712,10514713,10514742,10514769,10514770,10514771,9170963,9170998,9171002,10513046,9176410,9176411,9176412,9176413,9176414,8918074,8918075,10417355,10419438,10419439,8918219,8918220,10418552,10419564,10419565,9168728,9168759,9168760,9168761,9168762,4973673,9168922,9168926,9168927,10418914,9169172,10420125,10469204,9174648,9174649,10469230,10469259,9174841,9174893,10467554,9175006,9175007,9175008,9175009,9175010,9175011,9175012,6667150,6667151,6667152,6667163,6667164,8916904,10467989,9175427,9175428,9175451,9175463,10468076,9175500,9175501,9175502,9175507,9175508,8917173,9175554,6667926,6668181,6668182,6668183,6668184,6668185,6668186,8917849,10628580,10163506,10632171,10632207,10632245,10632246,10632247,10627581,10627737,10630060,10630102,10626167,10626168,10626170,10626171,10626172,10626174,10626176,10626193,10626641,10163317,10631796,10568548,10568549,10567329,10567330,10567331,10567408,10567409,10567410,10567411,10567412,10567413,10567414,10567415,10567463,10521153,10521186,10521253,10521254,10521266,10521267,10521269,10521270,10521281,10521282,10521283,10521284,10521286,10521287,10521288,10521289,10521290,10521316,10521317,10521318,10523481,10523482,10523483,10523484,10523485,10523486,10523487,10523488,10523489,10523490,10523491,10523492,10523493,10523494,10523495,10523496,10523497,10523498,10523499,10523500,10523501,10523502,10523503,10523504,10523505,10523506,10523507,10523508,10523509,10523510,10523511,10523512,10523513,10527709,10521830,10521831,10521832,10521833,10521834,10521874,10521875,10522248,10522249,10522250,10522272,10522469,10522470,10522471,10522651,10522652,10520740,10520741,10520742,10524789,10522891,10423244,10423245,10423246,10421249,10423251,10423252,10423257,10423258,10423262,10423267,10423278,10423284,10423285,10423286,10420308,10420309,10420310,10420369,10422388,10422389,10422390,10422399,10422400,10422407,10422409,10422410,10420411,10420414,10423417,10422417,10422418,10422419,10422420,10422421,10422422,10422437,10422438,10423442,10423443,10422445,10423446,10422446,10423447,10422447,10422455,10424464,10422474,10422475,10422476,10420490,10424497,10424498,10422500,10422501,10420505,10422505,10422506,10422511,10422518,10420521,10420522,10420527,10420529,10420532,10422709,10422775,10422776,10424784,10424785,10424786,10424787,10422787,10424788,10424789,10421985,10423070,10423071,10479108,10479109,10479110,10479113,10479114,10479120,10479121,10479125,10479126,10479127,10479128,10479129,10479130,10481810,10481814,10476222,10476238,10480828) 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'