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(4970645,4970666,4970667,4970668,4970669,4970682,4970724,4970748,4970858,4970859,4970860,4970861,4970862,4970863,4970864,4970866,4970867,4970873,4970874,4970875,4970876,4970881,4970882,4970883,4970886,4970887,4970888,4970891,4970892,4970893,4970894,4970897,4970898,4970902,4970905,4970908,4970912,4970924,4970929,4970936,4970937,4970938,4970970,4970974,4970977,4971029,4971050,4971053,4971054,4971095,4971137,4971138,4971152,4971153,4971154,4971155,4968315,4968316,4968317,4968318,4968319,4968320,4968321,4968330,4968331,4968410,4968411,4968412,4968413,4968647,4968654,4968846,4968847,4968848,4968859,8075214,8075215,8075216,8075217,8075284,8075321,4967031,4967061,4967062,4967996,4968060,8073677,8073678,8073679,8073680,8073681,8073682,8073683,8073684,8073685,8073686,8073687,8073688,8073689,8073690,8073691,8073692,8073693,8073694,8073695,8073696,8073697,8073698,8073699,8073700,8073701,8073702,8073703,8073704,8073705,8073706,8073707,8073708,8073709,8073710,8073711,8073712,8073713,8073714,8073715,8073716,8073717,8073718,8073719,8073720,8073721,8073722,8073723,8073724,8073725,8073726,8073727,8073728,8073729,8073730,8073731,8073732,8073733,8073734,8073735,8073736,8073737,8073738,8073739,8073740,8073741,8073742,8073743,8073744,8073745,8073746,8073747,8073748,8073749,8073750,8073751,8073752,8073753,8073754,8073755,8072303,8072437,8072548,8072549,8072582,8072583,8072643,8072644,8072645,8072646,8072647,8072793,8072794,8072795,8072796,8072797,8072798,8072799,8072800,8072801,8072802,8072803,8072804,8072805,8072806,8072807,8072808,8073038,8073089,8073091,8073092,8073093,8073094,8073096,8073097,8073533,8073534,8073535,8073536,8073546,8073553,8073554,8073555,8073556,8073557,8073558,8073559,8073560,8073561,8073562,8073563,8073564,8073565,8073566,8073567,8073568,8073569,8073570,8073571,8073572,8073573,8073574,8073575,8073576,8073577,8073578,8073579,8073580,8073581,8073582,8073583,8073584,8073585,8073586,8073587,8073588,8073589,8073590,8073591,8073592,8073593,8073594,8073595,8073596,8073597,8073598,8073599,8073600,8073601,8073602,8073603,8073604,8073605,8073606,8073607,8073608,8073609,8073610,8073611,8073612,8073613,8073614,8073615,8073616,8073617,8073618,8073619,8073620,8073621,8073622,8073623,8073624,8073625,8073626,8073627,8073628,8073629,8073630,8073631,8073632,8073633,8073634,8073635,8073636,8073637,8073638,8073639,8073640,8073641,8073642,8073643,8073644,8073645,8073646,8073647,8073648,8073649,8073650,8073651,8073652,8073653,8073654,8073655,8073656,8073657,8073658,8073659,8073660,8073661,8073662,8073663,8073664,8073665,8073666,8073667,8073668,8073669,8073670,8073671,8073672,8073673,8073674,8073675,8073676,10623056,10623061,10623256,10623257,10623303,10623305,10623306,10623307,10623308,10623311,10623400,10623500,10623656,10624954,10624959,10621978,10621979,10621980,10621984,10621987,10621988,10622013,10622014,10622015,10622016,10622017,10622018,10622021,10622024,10622027,10622028,10622029,10622030,10622031,10622032,10622033,10622034,10622035,10622036,10622038,10622040,10622041,10622042,10622049,10622055,10622056,10622057,10622061,10622064,10622065,10622066,10622067,10622070,10622072,10622074,10622077,10622091,10622092,10622093,10622097,10622098,10622099,10622100,10622101,10622104,10622105,10622106,10622107,10622108,10622109,10622110,10622113,10622114,10622115,10622116,10622117,10622118,10622119,10622120,10622121,10622122,10622123,10622124,10622125,10622126,10622127,10622131,10622132,10622256,10622258,10622259,10622260,10622261,10622262,10622263,10622409,10622515,10622627,10622665,10622666,10622667,10622668,10622669,10622670,10622671,10622750,10622751,10622752,10622881,10622882,10622883,10622884,10622885,10622886,10622887,10622888,10622889,10622890,10622891,10622892,10622893,10622894,10622895,10622897,10622901,10622914,10622915,10622917,10622918,10622920,10619964,10619965,10619974,10619977,10619978,10619983,10619984,10619999,10620002,10620006,10620010,10620012,10620014,10620015,10620020,10620021,10620022,10620023,10620024,10620025,10620026,10620027,10620028,10620035,10620036,10620037,10620038,10620039,10620043,10620044,10620045,10620047,10620049,10620050,10620051,10620063,10620064,10620066,10620067,10620084,10620090,10620091,10620270,10620278,10620279,10620280,10620281,10620282,10620297,10620298,10620299,10620300,10620301,10620302,10620303,10620304,10620305,10620306,10620307,10620308,10620320,10620321,10620322,10620323,10620324,10620325,10620326,10620328,10620329,10620338,10620339,10620340,10620341,10620342,10620343,10620344,10620345,10620346,10620347,10620348,10620349,10620350,10620351,10620352,10620353,10620354,10620355,10620356,10620357,10620358,10620359,10620360,10620361,10620362,10620363,10620364,10620365,10620366,10620367,10620368,10620369,10620370,10620371,10620372,10620373,10620374,10620375,10620376,10620377,10620378,10620379,10620380,10620381,10620382,10620383,10620384,10620385,10620386,10620387,10620388,10620389,10620390,10620391,10620392,10620393,10620394,10620395,10620396,10620397,10620398,10620399,10620400,10620401,10620402,10620403,10620404,10620405,10620406,10620407,10620408,10620409,10620410,10620411,10620412,10620413,10620414,10620415,10620416,10620417,10620418,10620419,10620420,10620421,10620422,10620423,10620424,10620425,10620426,10621077,10621119,10621139,10621166,10621230,10621231,10621232,10621233,10621234,10621235,10621236,10621237,10621238,10621239,10621240,10621243,10621247,10621251,10621252,10621253,10621254,10621258,10621260,10621262,10621263,10621264,10621265,10621267,10621270,10621272,10621275,10621276,10621277,10621280,10621285,10621287,10621288,10621289,10621291,10621292,10621293,10621294,10621295,10621296,10621297,10621298,10621301,10621303,10621304,10621305,10621306,10621307,10621308,10621309,10621311,10621314,10621316,10621317,10621318,10621319,10621320,10621321,10621322,10621325,10621326,10621327,10621328,10621329,10621330,10621331,10621332,10621333,10621334,10621335,10621336,10621340,10621341,10621343,10621344,10621345,10621349,10621350,10621352,10621353,10621354,10621356,10621357,10621358,10621363,10621364,10621365,10621366,10621375,10621376,10621383,10621384,10621385,10621386,10621390,10621391,10621392,10621396,10621397,10621400,10621401,10621402,10621403,10621404,10621406,10621407,10621409,10621410,10621411,10621412,10621413,10621414,10621415,10621421,10621422,10621423,10621427,10621428,10621429,10621430,10621431,10621439,10621440,10621441,10621444,10621445,10621446,10621447,10621448,10621449,10621450,10621451,10621452,10621453,10621454,10621455,10621456,10621457,10621458,10621459,10621460,10621461,10621462,10621463,10621464,10621465,10621466,10621467,10621468,10621469,10621470,10621471,10621472,10621473,10621474,10621475,10621476,10621477,10621478,10621481,10621483,10621486,10621487,10621488,10621489,10621490,10621491,10621492,10621500,10621501,10621502,10621503,10621504,10621510,10621511,10621513,10621514,10621521,10621522,10621526,10621529,10621530,10621531,10621532,10621534,10621537,10621538,10621542,10621543,10621544,10621571,10621572,10621573,10621575,10621580,10621585,10621589,10621596,10621597,10621598,10621599,10621600,10621620,10621631,10621632,10621633,10621634,10621637,10621640,10621642,10621645,10621647,10621649,10621650,10621651,10621652,10621653,10621654,10621655,10621656,10621657,10621658,10621659,10621661,10621663,10621664,10621665,10621666,10621667,10621668,10621669,10621670,10621671,10621672,10621677,10621678,10621679,10621681,10621682,10621683,10621684,10621685,10621687,10621688,10621689,10621690,10621691,10621692,10621694,10621695,10621699,10621701,10621702,10621703,10621704,10621708,10621710,10621713,10621714,10621715,10621717,10621721,10621724,10621726,10621727,10621728,10621729,10621731,10621732,10621733,10621735,10621736,10621737,10621738,10621739,10621741,10621742,10621743,10621745,10621746,10621747,10621748,10621749,10621750,10621958,10565147,10565148,10565149,10565152,10565158,10565160,10565161,10565162,10565163,10565164,10565165,10565166,10565167,10565168,10565169,10565195,10565271,10565285,10565286,10565287,10565288,10565289,10565290,10565291,10565292,10565293,10565294,10565295,10565297,10565298,10565316,10565317,10565322,10565843,10565844,10565845,10565846,10565847,10565848,10565849,10565850,10565851,10565852,10565853,10565854,10565855,10565856,10565857,10565858,10566057,10566058,10566059,10566060,10566061,10566062,10566063,10566064,10566065,10566066,10566109,10563148,10563492,10563493,10563494,10563495,10563496,10563497,10563498,10563499,10563500,10563501,10563502,10563503,10563504,10563505,10563506,10563507,10563508,10563509,10563510,10563511,10563512,10563513,10563514,10563518,10563519,10563520,10563534,10564426,10564609,10564610,10564611,10564612,10564613) 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'