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(10845582,10845594,10845622,8574075,10845662,10930213,10930217,10930229,10845747,10845748,10943611,8838592,8620987,10939899,8838705,3228689,8621141,10448283,8569447,8569516,3228986,10944095,8621441,8569588,10944142,3229168,10944312,11041520,11041521,11041522,10950477,8583342,7073941,3229447,3229475,8583608,10846923,7074199,7066459,8575889,11042422,3230227,10951441,3227407,3227408,11000793,8573316,8573347,10929452,7067191,10929534,10929561,10929576,10929581,10929587,7067317,8573495,10929592,8573514,8573533,8573638,10939186,10845252,7067553,8573799,10845393,10929936,10929986,7067718,8835305,8835306,8835307,8835308,6000111,3238257,6000193,11011620,11011626,11011627,11011628,11011629,11011630,11011631,11011632,11011633,11011634,6000275,6000295,8617866,10842817,8617932,11011813,11011814,11011815,7072147,8617995,10103344,10843005,11012031,3238768,7064369,11012104,11012105,10931914,8075329,7201771,10103665,10103836,10103889,10843521,10843522,8618612,10103925,8065938,10843740,8066093,8066094,8066110,8066112,8066113,8066114,10999731,8618981,8618987,8619006,8619011,8619013,7073199,5654539,10986931,10986944,8619178,8619179,7073525,9794606,9794611,8572768,10928873,7073715,7073730,10929009,7073795,11010561,11010563,11010564,11010565,10102078,8616848,8616884,8616886,8616887,8616888,8616889,8616890,8616891,8616892,8616893,8616894,8616895,8616896,8616897,8616898,8616899,3237613,7200468,7200469,8834944,7200732,7200733,7200734,10943321,10998351,11011360,11011361,11011362,10102872,8910810,8835290,6000084,8835300,8835303,8835304,11047558,11047559,11047560,11047561,10944420,10944434,10944437,4938663,8563651,8563698,3235413,8563735,10839881,10944690,8563932,8563974,8563998,10944834,8615176,10840171,8564132,8615265,7198686,7198692,10945040,3235964,3235974,7069599,3236018,7069600,10840519,8564526,3236284,8564608,8564623,8564635,3656620,3656621,10840793,10840794,10840795,10996737,7199329,10941832,10941841,10941871,10840914,10941939,11009914,11009915,11009919,10941950,8565149,3236892,8565209,7199769,7199895,10101780,10101787,7070670,11036386,7070803,8542384,8579066,8612840,8612847,8612848,11045703,11045704,11045705,11045706,11045707,11045708,11045709,8612877,10837877,10837882,11045817,10837890,10837894,10837895,10837912,11045853,11045861,10837967,10837972,8613064,10837991,10838002,10838010,8906809,3234253,10838706,10619174,11046841,11046998,11046999,11047000,11047001,11047183,11047184,11047185,10619832,8614529,10927472,10927473,8541333,8541334,8541342,8541343,10992628,10992629,10992630,10992631,10992632,10992633,10992634,10992635,10992665,10992666,10992667,10992668,10992720,10836830,11044795,10992823,10992824,10992825,10992826,10992827,10992828,10992829,10992830,10992831,10992832,10992833,10992834,10992835,10992836,10966855,8541749,10927903,10927904,10927905,10927912,10927913,10992960,10992961,10927940,10927981,8612171,10993032,10993033,10928013,10928014,10617507,10928022,10928023,10928093,10928094,10993155,10993156,10928306,10928307,10928308,10617798,10928309,10928310,10928311,10928312,10928313,10928314,8542249,10951445,3230238,8569824,10620057,10620058,10620059,8622758,10951571,8570096,8570097,8570103,8570123,8570125,8576331,8570215,8570216,8570217,3230677,10926071,10926072,10926081,10926082,10926083,11004118,11004124,10615591,10926103,10926104,10926105,10926123,10926134,10926135,10926148,8570486,3230995,10952221,10926265,10926266,10926267,10926268,10952238,10926269,10926270,10926271,10926272,10926307,3231098,10926356,10926357,10930734,10991468,10991469,10991470,10965476,10965477,10991528,10991532,3231278,3231279,3231280,3231281,10991547,3231282,10991548,3231283,10991549,8610712,3231346,3231381,3231382,3231383,3231384,3231385,3231386,3231388,3231394,3231395,3231396,10926699,10926700,10991757,10991758,10952759,10991826,10991827,10426521,10426522,10992045,10927108,8540970,8540971,10927196,10927202,8541125,10616894,8577939,8541275,8541276,8541277,10927431,10927432,8541315,10927459,8541316,10927460,8541317,10927469,8541326,10927470,10927471,9197419,10559320,9213542,9213665,10714165,10714222,9213751,9213825,6670042,6670043,10122080,10614558,9165901,10559738,10122151,10122162,9213970,10122189,10122194,9214003,10122207,8864534,9214026,10122231,10122256,8864584,8864585,10122267,8864596,8864615,8864626,10122325,8864651,3962448,8864661,8864693,8864694,9198192,9174201,10611868,9174207,9166229,9174260,8542532,9203384,10119588,9171432,9179513,9179515,9171578,10609275,8542801,10563524,10563525,10563526,10563527,10563528,10563529,10563543,10563571,9171955,9164049,8862743,9212352,9212366,10613035,7058548,7058551,8862910,8862992,8862993,10120678,8863033,8863035,8863046,8863058,8863059,8863061,8863066,9164620,9196802,8863352,10121200,8863552,6677237,10610768,10613844,10610879,9185343,9185394,9185421,9169476,9161488,9185581,9185664,7055836,10117885,10517520,10517521,10517522,10126039,10126153,10126154,10126155,10126156,9185968,7056156,9186011,9186031,9186095,10118316,10118355,10118376,9186233,6674440,10118512,9186317,9162382,9162383,9186399,9186428,9194445,10118644,9186491,9186518,9186602,9186603,9186604,9186617,9186629,9186630,9186631,9202654,9186686,9178700,9178708,9186713,10119065,10119076,9178908,9179068,9179127,9179142,8552456,8552457,10415259,10415260,10415266,10415267,10415268,10417287,10417289,10417291,10417292,8918042,10416462,10416474,10415476,10415477,10418486,10418539,9160675,10124901,10116936,10419789,9160995,10125210,4974008,4974009,4974010,4974011,4974012,4974013,4974014,10117387,10117388,10416150,10416151,10417162,10416174,10416175,4974115,4974116,10416186,8549471,9166387,3962718,8549596,9166572,9166580,9166589,9166607,9174711,8549880,9166772,9166773,9182809,6666827,9206867,9174871,9166872,6666876,6666877,9174880,8550101,6666960,9174992,10469633,9175070,10469702,10469703,10469704,10469780,10469781,10469782,3963584,8550453,9167299,9199337,10115559,8917046,8917047,8917048,8917049,8917050,8563311,8917077,9199431,10123705,9207539,9207540,9207541,9207542,9207543,10123817,10468228,9167670,9175695,10123893,9175696,10123894,10123895,10123896,10123897,10123898,10123899,10123900,10123924,9175732,9175742,9175743,9175747,10123961,10468369,8917449,8917450,8917451,8917452,8917453,8917454,8917455,8917456,8917457,8917458,8917459,8917460,8917461,8917462,8917463,9199818,9199819,9207833,10124077,10124078,10124079,9199889,9175963,10116204,8917708,9176104,9176105,8593519,8593544,10893652,10893653,10893654,10893678,10628215,10893736,10893737,10893738,10893741,10628698,10628699,8594359,10884472,10175574,10180668,10884657,10879848,10629414,10874993,10874994,10874995,10874996,10874997,10874998,10874999,10875000,10156162,7000691,10173652,7000902,7000922,10882885,10158965,10163982,10163985,10163987,10163991,10883139,10888227,10164267,10627772,10627773,10627774,10893353,10627910,10630038,10630100,10875851,10162015,10157035,10177104,10187227,10891216,10891217,10891218,10891259,10891291,10891292,10891427,10187732,10626473,10188067,10892331,10892335,10892336,10892337,10892357,10887440,10887441,10646240,10583645,10583646,10583647,10583648,10598908,10599067,10590307,10584478,10591426,10591427,10600442,10591458,10567497,10591570,10591571,10591572,10591573,10591574,10591575,10591576,10591577,10591578,10600586,10600587,10600588,10600589,10591645,10591666,10591667,10600703,10600704,10591742,10591743,10591744,10601048,10568083,10568084,10568085,10568086,10568087,10568088,10568089,10521331,10531345,10531346,10531347,10531348,10531349,10531350,10531351,10531352,10531353,10531354,10531355,10531356,10531357,10531358,10531453,10531454,10531511,10531647,10531648,10531649,10531732,10531733,10531734,10531735,10531736,10531737,10531738,10531739,10531740,10531741,10531742,10531743,10531744,10531745,10531746,10531747,10531748,10531749,10531750,10531890,10531891,10531892,10531893,10532074,10532075,10532076,10532077,10532078,10532097,10530106,10532276,10530299,10530300,10530301,10530302,10532364,10532365,10532366,10530392,10530393,10532411,10532474,10532475,10532476,10532477,10532808,10532843,10530857,10522862,10532890,10532891,10532892,10520928,10520929,10520930,10532953,10520955,10530973,10530988,10423465,10423466,10423479,10423488,10423574,10505584,10420695,10420699,10420701,10420702,10422025,10483056,10477108,10483133,10477347,10477348,10477361,10477362,10494392,10496768,10492925,10492943,10492944,10492945,10492946,10492947,10492948,10492949,10492950,10492951,10492955,10492956,10492975,10492976,10493071,10493075,10493086,10493135,10495140,10495141,10495142,10495143,10495144,10495145,10495146,10493158,10493159,10493242,10493248,10493249,10493267,10493268,10406890,10406973,10406974,10406975,10406976,10406977,10406978,10406979) 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'