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(3228945,10862262,8631691,8631701,8631702,8631703,8631735,8631736,8631737,8631738,8631739,8631863,8631864,8631865,8631866,8632521,10866428,10866556,10866557,8595045,8595047,8595052,8595053,8595059,10866900,10866901,7201959,10859283,10859284,9794571,7065920,7200209,10866129,10863436,7198702,10863842,10863843,10856137,8909073,8909074,10101462,11048366,3923423,10618180,7197231,7197232,7197233,7197234,7197235,7197236,7197246,7197249,7197267,7197268,7197269,7197270,7197271,7197272,7197278,10854322,7197282,7197283,7197284,7197285,10854362,10854366,10854417,10854438,10854439,10854440,10854441,10854442,10854443,10854444,10854445,10854446,10854447,10854448,10854449,10854450,10854451,10854453,10854454,10854455,10854458,10854459,10854460,10854463,10854464,10854465,10854469,10854470,10854471,10854472,10854473,10854474,10854475,10854476,10854477,10854478,10854479,10854480,10854481,10854483,10854484,10854485,10854488,10854489,10854490,10854494,10854495,10854496,10854500,10854501,10854502,10854503,10854504,10854505,10854506,10854507,10854508,10854509,10854510,10854511,10854523,10854524,10854525,10854526,10854527,10854528,10854529,10854531,10854532,10854535,10854536,10854537,10854539,10854540,10854541,10854545,10854546,10854547,10854548,10854549,10854550,10854551,10854552,10854553,10854554,10854555,10854556,10854567,10854568,10854569,10854570,10854571,10854572,10854574,10854575,10854581,10854587,10854588,10854589,10854590,10854591,10854592,10854593,10854594,10854595,10854596,10854597,10854598,10854599,10854600,10854601,10854602,10854604,10854607,10854608,10854609,10854610,10854611,10854612,10854613,10854614,10854615,10854616,10854617,10854618,10854619,10854620,10854621,10854622,10854623,10854624,10854625,10854626,10854627,10854628,10854629,10854630,10854631,10854632,10854633,10854634,10854635,10854636,10854637,10854638,10854639,10854640,10854641,10854642,10854643,10854644,10854645,10854646,10854647,10854648,10854649,10854650,10854651,10854652,10854653,10854654,10854655,10854656,10854657,10854658,10854659,10854660,10854661,10854662,10854663,10854664,10854665,10854666,10854667,10854668,10854669,10854670,10854671,10854672,10854673,10854674,10854675,10854676,10854677,10854678,10854679,10854680,10854681,10854682,10854683,10854684,10854685,10854686,10854687,10854688,10854689,10854690,10854691,10854692,10854693,10854694,10854695,10854696,10854697,10854698,10854699,10854700,10854701,10854702,10854703,10854704,10854705,10854706,10854707,10854708,10854709,10854710,10854711,10854712,10854713,10854714,10854715,10854716,10854717,10854718,10854719,10854720,10854721,10854722,10854723,10854724,10854725,10854726,10854727,10854728,10854729,10854730,10854731,10854732,10854733,10854734,10854735,10854736,10854737,10854738,10854739,10854740,10854741,10854742,10854743,10854744,10854745,10854746,10854747,10854748,10854749,10854750,10854751,10854752,10854753,10854754,10854755,10854756,10854757,10854758,10854759,10854760,10854761,10854762,10854763,10854764,10854765,10854766,10854767,10854768,10854769,10854770,10854771,10854772,10854773,10854774,10854775,10854776,10854777,10854778,10854779,10854780,10854781,10854782,10854783,10854784,10854785,10854786,10854787,10854788,10854789,10854790,10854791,10854792,10854793,10854794,10854795,10854796,10854797,10854798,10854799,10854800,10854801,10854802,10854803,10854804,10854805,10854806,10854807,10854808,10854809,10854810,10854811,10854812,10854813,10854814,10854815,10854816,10854817,10854818,10854819,10854820,10854821,10854822,10854823,10854824,10854825,10854826,10854827,10854828,10854829,10854830,10854831,10854832,10854833,10854834,10854835,10854836,10854837,10854838,10854839,10854840,10854841,10854842,10854843,10854844,10854845,10854846,10854847,10854848,10854849,10854850,10854851,10854852,10854853,10854854,10854855,10854856,10854857,10854858,10854859,10854860,10854861,10854862,10854863,10854864,10854865,10854866,10854867,10854868,10854869,10854870,10854871,10854872,10854873,10854874,10854875,10854876,10854877,10854878,10854917,10854918,10854919,10854927,10854928,10854929,10854930,10854931,10854932,10854941,10854946,10854963,10854964,10854965,10854966,10854967,10854968,10854969,10854970,10854971,10854972,10854973,10854974,10854975,10854978,10854980,10854992,10854993,10854994,10854997,10854998,8624357,8624358,10855000,10855001,10855002,10855003,8624473,10855124,10855126,8904995,8904999,8905004,8905006,8905007,8905008,8905009,8905010,8905011,8905012,8905201,8905354,10615050,10615772,10615814,10426438,8540594,8904984,8904985,8904986,8904989,6669817,6669825,10714112,6669905,6669912,6669950,6669951,6670040,10614730,10614731,10612354,10612413,10609848,10609849,10609850,10609859,10609867,10609868,10609874,10609880,10609883,10609884,10609885,10609886,10609889,10609891,10609892,10609898,10609899,10609905,10609908,10609910,10609912,10609914,10609915,10609928,10609929,10609930,10609931,10609932,10609933,10609934,10609944,10609945,10609947,10609948,10609949,10609950,10609951,10609955,10609959,10609968,10609969,10609971,10613193,10610274,10610359,10610691,10610692,10610694,10117498,10117499,10117507,10117508,10117513,10117514,9169352,6673619,6673620,6673621,6673622,6673623,6673624,9169428,6673736,6673740,6673741,6673742,9911825,9911827,9911833,9911834,9911839,9911840,9911843,9911887,9912016,9912017,6674226,8850108,8850111,8850122,8850123,8850124,9912801,10417293,10417294,10417295,6672603,6672605,6672608,6672659,10419407,10419780,10419781,6673072,6673178,10415941,10416971,6673257,6673263,6673302,6673316,8549466,6670766,8549937,8549939,8549945,8549948,8549952,10467615,10467623,10467624,10467625,10467626,976432,976433,10883679,10888933,10889013,10884529,10889947,10889948,10887638,10887640,10887665,10887666,10882901,10882910,10882919,10882922,10882925,10882933,10882934,10882936,10882938,10882958,10882965,10882966,10882970,10882971,10882972,10882973,10882974,10882975,10882976,10882980,10882982,10882983,10882984,10882985,10882986,10882988,10882991,10882992,10882993,10882996,10882998,10882999,10883000,10883002,10883004,10883011,10883012,10883013,10883014,10883020,10883021,10883022,10883023,10883024,10883025,10883026,10883222,10883229,10161824,10161828,10161831,10161832,10161833,10876804,10876805,10876810,10876813,10876814,10887139,10602313,10608811,10608812,10647352,10647353,10647354,10603873,10603874,10603875,10604086,10604215,10604529,10508267,10411252,10413730,10413731,10410097,10410139,10410142,10410143,10410144,10410145,10410146,10410147,10410148,10410149,10410150,10410158,10410168,10410169,10410171,10410177,10410179,10410190,10410191,10410192,10410193,10410194,10410195,10410196,10410203,10410208,10410209,10410210,10410211,10410212,10410213,10410214,10410215,10410305,10410306,10410308,10410309,10410310,10410311,10410312,10410313,10410314,10410315,10410316,10410317,10410318,10410319,10410320,10410321,10410322,10410323,10410324,10410325,10410326,10410327,10410328) 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'