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(4970666,4970667,4970668,4970669,4970675,4970684,4970687,4970688,4970701,4970703,4970713,4970715,4970716,4970717,4970718,4970724,4970725,4970726,4970732,4970733,4970734,4970742,4970746,4970757,4970767,8067903,8067906,8067910,8067911,8067927,8067938,8067939,8067940,8067942,10932008,10932009,10932011,4967032,10932570,10932571,10932572,10932573,10932711,10933036,10933039,10933045,10933046,10933047,10933053,10933054,10933055,10933212,8970213,10940580,10940584,10940655,10940658,10940659,10940660,10940665,10940666,10940668,10940669,10940675,10940681,10941019,10941440,10941441,10941442,10941444,10941467,10941602,10941729,10941732,10941733,8073547,10623069,10623310,10623311,10623312,10623313,10623314,10623315,10623316,10623317,10623318,10623319,10623320,10623321,10623324,10623335,10623346,10623357,10623368,10623378,10623388,10623397,10623399,10623400,10623401,10623402,10623403,10623404,10623405,10623406,10623407,10623408,10623409,10623410,10623411,10623412,10623413,10623414,10623415,10623418,10623429,10623440,10623459,10623466,10623490,10623491,10623492,10623503,10623508,10623524,10623582,10623587,10623588,10623589,10623590,10623632,10623633,10623965,10624906,10621966,10622188,10622197,10622199,10622345,10622346,10622347,10622348,10622349,10622350,10622351,10622352,10622353,10622354,10622355,10622356,10622357,10622358,10622359,10622363,10622413,10622415,10622450,10622451,10622452,10622772,10620164,10620186,10620187,10620188,10620189,10620190,10620191,10620192,10620193,10620194,10620195,10620196,10620197,10620198,10620199,10620200,10620208,10620214,10620255,10620256,10620257,10620258,10620259,10620267,10620301,10620327,10620441,10620442,10620443,10620444,10620465,10620467,10620483,10620487,10620488,10620491,10620537,10620538,10620540,10620563,10620585,10620591,10620592,10620593,10620594,10620595,10620596,10620597,10620598,10620599,10620600,10620601,10620602,10620603,10620604,10620605,10620606,10620607,10620608,10620609,10620610,10620611,10620612,10620613,10620614,10620615,10620616,10620617,10620618,10620619,10620620,10620621,10620622,10620623,10620628,10620708,10620741,10620742,10620747,10620750,10620764,10620767,10620768,10620779,10620780,10620791,10620792,10620793,10620796,10620855,10620856,10620934,10620935,10620936,10620981,10621103,10621649,10621658,10621659,10621701,10621702,10621707,10621718,10621722,10621723,10621729,10621741,10621777,10621959,10613978,10613983,10613988,10613989,10614009,10614015,10614016,10614039,10614047,10614051,10614060,10614061,10614064,10614067,10614068,10614069,10614074,10614078,10614079,10614094,10614190,10614199,10614201,10614210,10614221,10614248,10614249,10614252,10614253,10614254,10614264,10614272,10614274,10614282,10614296,10614316,10614317,10614323,10614337,10614340,10614343,10614354,10614355,10614378,10614383,10614414,10614419,10614421,10614422,10614423,10614443,10614444,10614445,10614447,10614462,10614463,10614464,10614472,10614486,10614488,10614489,10614497,10614499,10614502,10614517,10614524,10614525,10614533,10565700,10565701,10565702,10614552,10565703,10614553,10565704,10614554,10565705,10565706,10614561,10614565,10614566,10614567,10614568,10614569,10614570,10614572,10614588,10614617,10614619,10614620,10614621,10614626,10614635,10614636,10614637,10614647,10614648,10614655,10614662,10614664,10614668,10614670,10614672,10614675,10614677,10614678,10614681,10614684,10614698,10614699,10614703,10614709,10614710,10614714,10614724,10614726,10614727,10614729,10614730,10614746,10614753,10614760,10614819,10614820,10614821,10614822,10614830,10614833,10614852,10614864,10611971,10611976,10611977,10611978,10611979,10611989,10612005,10612009,10612021,10612027,10612030,10612031,10612032,10612033,10612034,10612035,10612036,10612039,10612041,10612050,10612053,10612060,10612068,10612069,10612077,10612082,10612083,10612086,10612088,10612095,10612127,10612128,10612129,10612130,10612137,10612168,10612169,10612172,10612173,10612177,10612178,10612179,10612188,10612191,10612192,10612194,10612199,10612200,10612201,10612204,10612205,10612207,10612208,10612209,10612210,10612211,10612212,10612213,10612232,10612244,10612252,10612259,10612260,10612263,10612267,10612273,10612284,10612285,10612294,10612310,10612315,10612320,10612321,10612330,10612337,10612344,10612348,10612366,10612381,10612388,10612393,10612394,10612395,10612407,10612412,10612413,10612414,10612417,10612424,10612480,10612481,10612482,10612484,10612486,10612487,10612488,10612489,10612490,10612491,10612492,10612496,10612498,10612501,10612502,10612503,10612513,10612516,10612517,10612518,10612519,10612520,10612521,10612522,10612523,10612524,10612525,10612526,10612528,10612529,10612530,10612531,10612532,10612534,10612535,10612538,10612546,10612547,10612551,10612552,10612553,10612554,10612555,10612558,10612565,10612566,10612567,10612568,10612570,10612573,10612584,10612585,10612586,10612587,10612589,10612592,10612596,10612597,10612604,10612608,10612609,10612611,10612618,10612619,10612620,10612622,10612625,10612626,10612633,10612637,10612641,10612642,10612643,10612646,10612647,10612648,10612650,10612652,10612655,10612658,10612659,10612661,10612663,10612668,10612675,10612677,10612679,10612680,10612682,10612683,10612684,10612685,10612687,10612688,10612689,10612690,10612697,10612698,10612699,10612700,10612701,10612705,10612707,10612711,10612713,10612714,10612715,10612718,10612720,10612723,10612724,10612727,10612728,10612730,10612731,10612732,10612733,10612734,10612735,10612736,10612737,10612738,10612741,10612745,10612746,10612747,10612748,10612752,10612753,10612754,10612755,10612756,10612757,10612764,10612765,10612769,10612773,10612774,10612775,10612776,10612777,10612778,10612779,10612780,10612783,10612784,10612786,10612791,10612792,10612794,10612805,10612806,10612811,10612812,10612813,10612816,10612821,10612822,10612824,10612833,10612834,10612836,10612837,10612839,10612840,10612841,10612842,10612844,10612845,10612846,10612848,10612856,10612860,10612864,10612866,10612867,10612868,10612873,10612875,10612877,10612884,10612886,10612888,10612904,10612905,10612907,10612916,10612921,10612922,10612923,10612931,10612937,10612938,10612941,10612942,10612943,10612952,10612954,10612958,10612964,10612973,10612979,10612980,10612982,10612996,10612997,10612999,10613003,10613005,10613006,10613009,10613010,10613011,10613016,10613022,10613043,10613044,10613055,10613062,10613067,10613084,10613085,10613086,10613087,10613088,10613090,10613091,10613092,10613093,10613094,10613096,10613097,10613098,10613099,10613100,10613101,10613102,10613103,10613104,10613105,10613106,10613107,10613108,10613109,10613110,10613111,10613112,10613113,10613114,10613115,10613116,10613117,10613119,10613127,10613152,10613153,10613154,10613230,10613232,10613233,10613234,10613235,10613261,10613262,10613263,10613274,10613275,10613276,10613278,10613285,10613286,10613290,10613291,10613293,10613294,10613295,10613296,10613297,10613298,10613299,10613300,10613301,10613302,10613303,10613304,10613305,10613306,10613318,10613342,10613350,10613356,10613357,10613365,10613366,10613367,10613368,10613369,10613373,10613378,10613393,10564549,10564550,10564551,10613421,10613425,10613426,10613430,10613440,10613441,10613442,10613443,10613453,10613455,10613464,10613479,10613497,10613498,10613502,10613503,10613507,10419243,10419257,10419258,10419272,10419274,10419275,10419276,10419278,10419279,10419280,10419281,10419282,10419284,10419285,10419293,10419294,10419295,10419296,10419299,10419339,10419340,10419341,10419343,10419344,10419345,10419346,10419347,10419396,10419440,10419458,10419459,10419478,10419493,10419497,10419524,10419525,10419526,10419527,10419544,10419546,10419548,10419550,10419560,10419568,10419571,10419587,10419588,10419592,10419596,10419600,10419627,10419628,10419653,10419654,10419689,10419690,10419691,10419692,10419698,10419699,10419700,10419701,10419702,10419718,10419719,10419768,10419769,10419770,10419771,10419772,10419778,10419779,10419781,10420014,10420015,10420016,10420102,10420103,10420104,10420105,10420106,10420107,10420108,10420109,10420110,10420111,10470999,10471000,10471001,10471002,10471003,10471004,10471010,10471056,10471057,10471058,10471059,10471060,10471067,10471087,10471105,10471106,10471108,10471109,10471110,10471114,10471117,10471118,10471129,10469900,10469947,10469957,10469965,10469966,10469967,10469968,10469969,10469970,10469971,10469972,10469973,10469974,10469975,10469976,10469977,10469978,10469979,10469980,10469981,10469982,10469983,10469984,10469985,10469986,10469987,10469988,10469989,10470155,10470156,10470161,10470162,10470205,10470644,10470645,10470646,10470647,10470648,10470649,10470650,10470651,10470652,10470653,10470666,10470667,10470668,10470726,10470727,10470728,10470729,10470731,10470732,10470733,10470768,10470776,10470778,10470781,10470789,10470793,10470799,10470800,10470814,10470815,10470816,10470817,10470818,10470819,10470820,10470821,10470822,10470823,10470824,10470825,10470826,10470827,10470828,10470829,10470830,10470831,10470832,10470833,10470854,10470861) 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'