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(4970683,4970687,4970688,4970700,4970724,7065980,7066016,7066144,7066145,7066164,7066179,7066192,7066207,7066222,7066250,7066252,7066260,8067909,10939103,10939385,10939419,7067886,7064544,7064547,7064548,7064551,8065812,8065813,8065838,8065839,8065840,7065342,7065911,7065912,7065913,7065914,11049794,10931197,10944444,11048413,11048414,10928736,10623491,10623492,10623505,10623508,10623605,10623606,10622188,10620200,10620201,10620202,10620741,10621777,10614050,10611053,10611054,10611063,10611064,10611103,10611126,10611134,10611230,10611232,10611235,10614252,10614253,10614254,10611267,10614274,10614282,10611282,10614289,10611293,10614297,10614309,10614314,10614316,10614317,10614323,10614327,10614328,10614329,10614330,10611334,10611352,10614355,10614382,10614414,10614458,10614463,10614464,10614469,10614501,10614516,10614517,10614518,10614524,10614525,10614530,10614531,10614532,10614533,10614534,10614537,10614538,10614544,10614547,10614551,10614552,10614553,10614554,10614555,10614558,10614561,10614563,10614565,10614566,10614567,10614568,10614569,10614570,10614571,10614572,10614588,10614592,10559766,10614625,10614632,10611708,10611714,10611722,10611723,10611724,10614749,10611780,10611788,10611789,10611790,10611801,10611802,10611816,10611818,10614822,10611823,10611825,10614852,10611856,10611857,10614858,10611859,10614859,10611860,10611861,10611862,10611863,10611864,10614864,10611879,10611895,10608964,10608977,10608990,10608992,10608998,10609008,10609010,10612053,10612069,10612070,10612071,10612072,10609072,10609073,10609074,10609075,10609076,10609077,10612077,10609079,10609085,10609086,10609087,10609088,10609089,10609090,10609091,10609094,10609101,10609158,10612168,10612169,10612179,10609198,10612210,10612263,10609263,10612273,10612284,10612285,10609285,10612286,10612319,10612320,10612321,10612342,10612344,10609350,10609367,10612388,10612392,10609392,10612393,10612394,10612395,10612396,10612397,10612398,10612399,10612400,10612401,10612402,10612403,10612404,10612405,10612407,10612408,10612409,10612410,10612411,10612412,10612414,10612426,10612427,10612428,10612429,10612430,10609430,10609431,10609434,10609436,10609437,10609450,10609472,10609473,10609475,10609476,10612483,10612484,10612485,10612486,10612487,10612488,10609489,10612489,10612490,10612491,10612492,10612493,10609496,10612496,10612497,10612498,10612499,10612500,10612502,10612503,10612506,10612507,10612508,10612509,10612510,10612513,10612516,10612517,10612518,10612519,10612520,10612521,10612522,10612523,10612524,10612525,10612526,10612527,10612529,10609530,10612531,10612534,10612535,10612536,10612538,10612539,10609540,10609542,10612546,10612547,10612551,10612552,10612553,10612554,10612555,10612556,10612557,10612558,10612559,10612562,10612563,10612565,10612566,10612567,10612570,10612571,10612573,10612579,10612580,10612583,10612584,10612585,10612586,10612587,10612588,10612589,10612592,10612594,10612596,10612597,10612599,10612601,10612604,10612608,10612609,10612611,10612618,10612620,10612622,10612623,10612624,10609624,10609625,10612625,10609626,10612626,10612633,10609634,10612635,10612637,10612638,10609638,10612639,10609641,10612641,10609642,10612642,10609643,10612643,10609644,10612644,10609645,10612645,10609646,10612646,10609647,10612647,10612648,10609648,10609649,10609650,10612650,10609651,10612651,10609652,10612653,10612655,10609655,10609656,10612657,10612658,10612659,10609660,10612660,10612661,10612663,10609664,10612664,10609665,10612666,10612667,10612668,10612673,10612678,10612679,10612680,10612682,10612683,10612684,10612685,10612687,10612688,10612689,10612690,10612697,10612698,10612699,10612700,10612701,10612702,10612703,10612704,10612705,10612706,10612707,10612711,10612716,10612717,10612718,10612720,10612721,10612722,10612723,10609725,10609726,10609727,10612753,10612755,10612758,10609772,10612772,10609773,10612773,10609774,10612774,10609775,10612775,10609776,10612776,10609777,10612777,10609778,10612778,10609779,10612779,10609780,10612780,10609781,10609782,10609783,10609784,10609785,10609786,10609787,10609788,10609789,10609790,10612791,10609791,10612792,10609792,10609793,10609794,10609795,10609796,10609797,10609798,10609799,10609800,10609801,10609802,10609803,10609804,10609805,10609806,10609807,10609808,10612809,10609809,10609810,10612811,10609811,10612812,10609812,10612813,10609813,10609814,10612815,10609815,10612816,10612817,10609818,10609819,10612824,10609824,10609826,10609828,10612833,10612834,10612836,10612837,10612838,10609838,10612839,10612840,10612841,10612842,10612843,10612844,10612846,10612847,10612853,10612860,10612862,10612863,10612865,10612866,10612867,10612868,10612869,10612870,10609870,10612871,10612872,10612873,10612874,10612875,10612876,10612878,10612879,10612881,10612882,10612883,10612884,10612897,10612907,10612914,10612916,10612936,10612937,10612938,10612939,10612941,10612942,10612945,10609947,10609948,10609967,10609968,10609969,10609970,10609975,10609976,10609978,10609979,10609981,10609987,10610006,10613019,10613023,10610025,10613027,10610030,10610046,10610054,10613055,10613079,10613080,10613084,10613085,10613087,10613088,10613089,10613091,10613093,10610094,10610095,10610096,10610167,10610168,10610173,10610175,10610176,10610177,10610190,10610233,10610236,10610237,10610259,10610261,10610262,10610268,10610269,10610270,10610271,10610272,10610273,10610274,10610280,10610282,10610283,10613287,10613288,10613289,10610289,10610293,10610295,10610296,10610298,10610318,10610319,10610334,10613350,10610359,10610362,10610364,10610371,10610373,10610374,10613393,10613421,10613423,10610429,10613430,10613431,10613432,10610437,10610440,10610441,10613455,10610461,10610463,10610466,10610468,10610469,10610471,10610474,10610476,10610481,10613503,10613507,10613525,10613542,10613553,10613562,10613563,10613633,10613643,10613646,10610678,10613732,10613733,10610793,10610794,10613804,10613805,10613806,10613807,10610836,10610844,10610848,10610849,10613856,10610881,10610902,10610929,10610937,10610939,10610940,10610942,10610958,10419231,10419254,10416256,10419257,10419262,10419269,10419270,10419273,10419274,10419275,10419276,10417286,10417289,10415313,10415314,10415323,10415326,10415328,10415339,10419342,10415354,10415357,10415361,10416383,10416385,10416398,10415403,10415405,10416444,10416445,10416446,10416447,10416448,10416449,10416450,10416451,10416452,10416453,10416454,10416455,10416456,10416457,10416458,10416459,10416460,10416461,10416462,10416463,10416464,10416465,10416466,10416467,10416468,10416469,10419470,10416470,10416471,10416472,10419472,10416473,10419473,10416474,10419474,10416475,10419475,10416476,10419476,10416477,10419477,10416478,10419478,10416479,10419479,10416480,10419480,10416481,10419481,10416482,10419482,10416483,10419483,10416484,10419484,10416485,10419485,10416486,10419486,10416487,10419487,10416488,10419488,10419489,10419490,10419491,10419492,10419493,10415539,10415540,10415541,10415542,10415575,10415576,10415579,10415580,10415581,10415582,10415583,10415584,10415585,10415586,10419602,10419603,10419604,10415604,10419605,10419606,10419607,10419608,10419609,10419610,10416610,10415610,10419611,10416611,10419612,10415613,10419613,10419614,10419615,10415616,10419616,10416617,10419617,10419622,10419623,10419624,10419625,10419626,10419627,10419628,10419630,10419631,10419632,10419633,10419634,10415635,10419635,10419636,10416638,10416639,10416640,10417641,10416641,10415641,10419641,10415642,10419642,10419643,10419644,10419645,10415646,10415648,10416649,10415649,10416650,10415650,10416651,10415651,10415654,10416656,10415656,10415657,10416658,10415658,10416659,10416660,10415660,10416661,10415661,10416662,10415662,10415663,10419663,10415665,10415666,10415668,10415671,10415672,10416673,10415673,10416674,10415674,10415675,10415676,10415677,10415678,10415680,10415683,10415684,10415723,10415790,10415851,10415856,10415861,10415866,10415869,10417920,10417924,10417928,10417936,10417940,10417941,10417942,10417943,10417944,10417945,10417966,10417967,10417968,10417969,10417970,10417971,10417972,10417973,10417974,10417975,10417976,10417977,10417978,10417979,10417992,10417993,10417994,10417995,10417996,10417997,10417998,10418022,10416028,10416030,10416032,10416034,10418035,10418044,10418045,10416048,10416051,10418068,10416076,10416113,10416114,10416117,10416118,10416182,10416183,10416185,10416186,10416187,10416189,10416190,10416191,10416192,10416193,10471044,10471139,10471157,10467492,10463510,10463511,10463512,10463513,10463514,10463515,10463516,10463517,10463518,10463519,10463520,10463521,10463522,10463523,10463524,10463525,10463526,10463527,10463528,10463529,10463530,10463531,10463532,10463533,10463534,10463535,10463536,10463537,10469893,10470111,10470152,10470153,10470154,10470155,10470156,10470157,10470158,10470159,10470160,10470161,10470162,10470163,10470166,10470171,10470172,10464190,10470201,10470203,10470205,10470666,10470667,10470668,10470669,10470670,10470671,10470672,10470673,10470674,10470675,10470771,10470789,10470791,10470793,10470796,10470797) 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'