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(10939561,10939562,10939563,10939564,10939565,10447845,8574297,8574303,10448004,10448006,8574324,8574325,8574337,10845970,7076361,7076364,10940010,10940011,10989164,10989165,10989166,10989167,10989168,10989169,10989170,10989171,10989180,10989181,10989182,10989183,10989184,10989185,10989186,10989187,3228952,8621400,7068729,7068743,7068753,7068769,7068774,7068777,8569766,8569767,8569768,8569773,8569774,8569781,8569782,7068816,7068817,7068820,7068858,7068859,7068860,7068861,7068862,7068863,8569842,8569843,8569844,8569845,8569846,8569847,8569848,8569849,7068879,7068880,7068881,7065969,7065970,7065972,7065973,10950688,7066222,10976969,10976970,7074338,10951224,7066600,10951235,8609575,8619771,8619785,8837672,10961884,10961885,10961886,10961887,10961888,10961889,10961890,10961891,10961892,10961893,10961894,8573388,10961895,10961896,8573389,10961897,10961898,10498042,10498043,8837825,8620323,10962194,10962195,8838047,8068461,8068469,8838199,10447621,10447623,10447633,10447634,10447635,10447641,10447642,10447645,7075901,8835442,7201211,7201248,7201249,8835495,8911108,8911110,8911111,7201309,7201368,7201520,7201521,7201522,10843055,10843056,10843058,10103446,10999087,10931771,10931772,10931773,7064470,7064471,7064472,10986500,10986501,10986502,10986503,10986504,10986505,8065822,7202148,7202150,7202152,7202155,7202156,7202157,7202159,7202172,7202173,8065905,7202174,7202175,7202176,7202177,7202178,7202187,7202189,7202194,7202219,7202220,7202221,7202222,7202223,7202224,7072979,7202225,7202226,7202227,7202228,7202229,7202230,7202231,7202232,7202233,7202247,7202252,7202253,7202254,7202256,7202258,7202259,7202261,7202267,7202269,7202283,8836620,8836621,8066190,7202530,8066457,10844274,10844275,8619434,8572997,8573014,4968060,8837417,8837418,7070968,8616849,8617002,10102331,8617132,8617133,8617201,10102538,10943063,8617364,7200827,7200828,7200908,5999947,7071685,10842482,10842483,8835389,8835390,8835391,7068941,3655528,7068986,8614980,10100294,8615101,8615102,8615103,8615113,7069416,8615362,3656274,8909145,8909294,8909295,10941881,10941882,10841126,10841225,10841226,8909550,8909551,8909552,8909553,7070625,7070637,7070640,8909764,8834241,8834242,8834243,8909926,7070878,7070893,7070894,7070895,7070896,7070897,7070925,7070926,7070927,7070928,7196253,10618144,8906180,7196440,7196441,7196442,7196443,7196444,7196445,7196446,7196447,7196448,7196449,7196450,7196451,10928812,11019961,8070020,8070021,8906355,8613150,8613154,10918870,10918871,10918872,10918873,10918874,11007068,8613301,8613302,8613306,8613307,8613308,8613331,8613332,8613404,8613407,8613418,8613425,8613439,8613490,8613491,8613695,8613701,8613702,8613704,8613724,8613725,10618980,10618981,10618982,8613794,8613795,8070808,8070827,8070835,8070849,8614217,8614220,10839352,10839353,10839354,10839355,8907726,8907727,8907728,10624841,10619872,10619946,11044630,11044658,11044659,11044781,11044782,11044783,11044784,11044785,11044786,8612108,8612109,8612110,8612111,10622378,10622379,10622380,10622549,10993337,10993434,10993435,10993436,11006476,11006483,8579015,10622917,10951611,8576182,10425385,8609899,10920635,10920656,10620203,10620204,10620205,10620206,10915729,10425570,10425571,10425572,10425573,10425574,8576610,10921263,10615822,10930755,10426194,10426195,10426196,10620859,10426197,10426198,10620860,10426199,10620861,10620875,10620876,8577035,10921413,10921414,10426252,10991661,10991662,10621070,10621074,10621075,10921605,10926633,10921758,10921759,8577411,8577412,8577413,10621362,10621368,10621369,10621370,10917083,10917084,10917085,10917086,10917087,8577808,10427109,10992601,10992606,9197650,9213653,7059843,10122287,10614779,10614780,10614801,10614802,9174198,10611994,9203342,9171379,9171380,9171381,9171382,9171383,9187450,9187463,9187464,9203488,9211513,9211515,9211518,9211520,9211521,9211522,10119799,10119800,10119801,10119802,10119803,10119859,10119860,10119861,10119862,10563567,9187902,9187903,9211920,9195952,10120174,10120175,10120176,10120177,10120178,10120179,9187988,10120186,9187989,10120187,10120188,10120189,10120203,10120262,10120272,10120286,9188126,10120434,10120435,10609960,10609970,10613061,10613062,10613075,10613153,10613232,10613233,10613234,9204586,10613251,9196621,9196855,9196890,8863468,10613693,10613722,7059329,7059359,7059360,9173255,9169454,9177472,9177473,9177506,9161542,9161543,9161544,9161595,9177640,9185693,9185694,9185695,9177701,9177748,4974627,9193776,10513620,7056001,10118085,10118086,9201889,10118087,9194105,9194106,9186381,9186451,9186553,9202743,9202744,9202745,9202855,9202856,9202857,9202858,7057251,9195109,9195110,9203136,9203255,9203256,9203257,9195268,9203291,10416276,9168399,10416372,10416373,10416374,9176599,10418741,10418743,9168830,9168831,9200838,10415785,10418883,9176991,9177030,10416958,10416044,10416045,10417115,10467433,10467434,10467435,10467436,10467437,10467438,10467439,10467440,10467441,10467442,10467443,10467444,6666901,8550063,4971944,4971953,4971957,4971958,10463692,10469740,10469741,10469742,10469743,10463768,10463769,10463770,10463771,10463772,10463773,10463774,10463775,10463776,10463777,10463778,10463779,10463780,10463781,10463782,10463783,10463784,10463785,10463786,10463787,10463788,10463789,10463790,10463791,10463792,10463793,10463794,10463795,10463796,10463797,10463798,10463799,10463800,10463801,10463802,10463803,10463804,10463805,10463806,10463807,10463808,10463809,10463810,10463811,10463812,10463813,10463814,10463815,10463816,10463817,10463818,10463819,10463820,10469820,10463821,10469821,10463822,10469822,10463823,10463824,10463825,10463826,10463827,10463828,4972104,10463829,10463830,10463831,10463832,10463833,4972145,4972146,4972147,10115575,10467990,10468004,10468022,10468048,10468087,10468102,10470397,10470513,10462728,10462729,10462730,10462731,8593541,10179678,8593816,8593817,8593828,10179934,10883988,10180138,10180139,10180140,10180141,10180546,10180934,10629611,10629612,10629613,10629614,10629659,10629660,10181217,10181218,10885398,10885399,10885400,10181480,10181481,10181482,10631994,10632018,10632079,10168639,10168667,10168668,10168669,10168670,10183747,10183748,10183749,10883357,10630116,10181738,10186821,10186828,10186829,10186832,10186836,10186838,10186844,10186847,10181849,10181850,10181851,10181899,10181900,10181901,10181965,10181966,10181967,10182038,10172201,10172202,10172203,10182206,10172209,10172210,10172345,10182369,10182473,10182474,10949315,10949316,10949317,10949318,10949319,10949320,10949321,10949322,10949323,10162598,10162599,10182612,10182613,10167615,10167616,10182801,10187809,10626339,10172870,10182988,10178009,10183073,10183319,10601212,10574631,10574798,10574799,10574800,10574801,10574802,10574803,10574804,10571841,10571842,10599340,10599341,10599342,10599343,10599344,10599345,10599346,10599369,10578522,10578523,10575559,10575560,10569732,10569733,10569734,10569735,10569736,10569737,10569738,10569739,10569740,10569741,10578840,10591027,10591028,10570111,10570112,10576179,10579247,10579248,10579249,10579250,10579251,10579252,10579253,10579254,10579255,10579256,10579257,10579258,10579259,10570289,10576367,10576559,10576560,10576561,10539219,10539220,10533259,10539330,10533367,10535397,10535398,10529410,10529411,10533425,10533506,10539527,10539528,10539529,10539530,10531559,10531560,10523561,10531561,10523562,10531562,10523563,10531563,10523564,10531564,10531565,10531566,10531567,10531568,10531569,10531570,10531571,10531572,10531573,10531579,10531580,10531581,10531582,10531583,10531584,10531585,10531586,10531587,10531588,10531589,10531590,10531591,10531592,10531593,10531594,10531595,10531596,10531597,10531607,10531608,10531609,10531610,10531611,10531612,10531613,10529615,10529616,10529617,10529618,10539626,10531634,10523662,10523675,10529682,10539703,10539704,10529708,10531848,10529982,10529983,10535985,10535986,10535987,10534310,10522412,10522413,10522414,10522415,10522417,10522418,10522419,10522421,10522428,10522429,10522430,10522431,10522432,10522433,10522434,10522435,10522436,10522437,10522438,10522439,10522440,10522451,10522454,10522455,10522456,10522458,10522463,10522466,10522467,10522468,10522472,10522473,10522474,10522475,10530646,10532672,10524790,10524803,10538850,10532881,10532882,10528910,10526979,10421221,10422320,10422321,10421390,10420474,10422700,10420717,10420869,10420870,10420871,10420872,10420874,10420875,10420876,10420884,10420885,10420886,10421923,10421924,10421925,10421926,10421927,10421928,10424937,10424954,10424960,10424965,10424977,10424982,10425070,10425071,10425072,10425073,10425074,10423106,10485982,10485983,10494013,10486025,10494129,10479192,10479309,10479310,10481478,10481797,10481826,10481827,10481828,10479898,10476426,10493739,10493740) 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'