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(10861327,10861328,10861329,10861330,9214761,7068138,7068139,7068140,7068141,7068142,7068143,7068144,7068145,7068146,7068147,7068148,7068149,7068150,7068151,7068152,7068153,7068154,7068155,7068156,7068157,7068158,4970450,10870604,10870605,9214992,10861769,10861770,9215247,9215248,9215249,4970858,10963338,10963339,4970899,4970900,4970901,4970902,4970903,4970904,4970905,4970906,4970907,4970908,4970909,4970910,4970911,4970912,4970913,4970914,4970915,10846466,8569752,8569753,10862154,10459447,10459471,10862494,10862522,10862523,8067270,10871584,10459881,10459886,10459891,10459933,10459973,10460013,10460053,10437351,10460093,10437398,10460133,9216231,10460173,10460213,10460253,10460293,10437584,10460333,10460384,10872190,10872204,10845320,11001319,11001353,11001354,10930043,10842929,10842949,7072488,10931851,10843337,10843338,8559591,8559592,8559597,10973370,10973371,10973372,10973373,10973374,10973375,10973376,10973377,10973378,10973379,10973380,10973381,10973382,10973383,10932047,10973384,10973385,10973386,10973387,10973388,10973389,10973390,10973391,10973392,10973393,10973394,10973395,10973396,10973397,10973398,10973399,10973400,10973401,10973402,10973403,10973404,10973405,10973406,10973407,10973408,10973409,10973410,10973411,10973412,10973413,10973414,10973415,10973416,10973417,10973418,10973419,10973420,10973421,10973422,10973423,10973424,10973425,10973426,10973427,10973428,10973429,10973430,10973431,10973432,10973433,10973434,10973435,10973436,10973437,10973438,10973439,10973440,10973441,10973442,10973443,10973444,10973445,10973446,10973447,10973448,10973449,10973450,10973451,10973452,10973453,10973454,10973455,10973456,10973457,10973458,10973459,10973460,10973461,10973462,10973463,10973464,10973465,10973466,10973467,10973468,10973469,10973470,10973471,10973472,10973473,10973474,10973475,10973476,10973477,10973478,10973479,10973480,10973481,10973482,8836287,10973483,8836288,10973484,10973485,10973486,10973487,10973488,10973489,10973490,10973491,10973492,10973493,10973494,10973495,10973496,10973497,10973498,10973499,10973500,10973501,10973502,10973503,10932167,10973504,10973505,10973506,10973507,10973508,10973509,10973510,10973511,10973512,10973513,10973514,10973515,10973516,10973517,10973518,10973519,10973520,10973521,10999522,10973522,10973523,10973524,10973525,10973526,10973527,10973528,10973529,10973530,10973531,10973532,10973533,10973534,10973535,10973536,10973537,10973538,10973539,8618691,10973540,10973541,10973542,10973543,10973544,10973545,10973546,10973547,8618698,10973548,10973549,10973550,10973551,10973552,10973553,10973554,10973555,10973556,10973557,10973558,10973559,10973560,10973561,10973562,10973563,10973564,10973565,10973566,10973567,10973568,10973569,10973570,10973571,10973572,10973573,10973574,10973575,10973576,10973577,10973578,8559840,10973579,8618731,10973580,10973581,10973582,10973583,10973584,10973585,10973586,10973587,10973588,10973589,10973590,10973591,8559852,10973592,10973593,10973594,10973595,10973596,10973597,10973598,10973599,10973600,10973601,10973602,10973603,10973604,10973605,10973606,10973607,10973608,10973609,10973610,10973611,10973612,10973613,10973614,10973615,10973616,10973617,10973618,10973619,10973620,10973621,8595866,10932599,10932646,10932649,10932686,10932693,10932694,7202711,7202712,10932846,7073588,7073669,10961381,10868034,10497583,10497584,11036710,11036713,8616941,11036841,11036857,11036862,11036867,11036894,8558258,8071710,8071775,8071840,8071905,8071970,8072035,8072100,8072165,3235850,10840211,8072230,8615358,8615359,8615360,8615361,8615362,8615363,8615364,8615365,8615366,8615367,8615368,8072306,3926100,8072592,8072602,8072612,8072618,8072658,8072659,8072660,8072661,8072662,3926391,8615906,8615920,8072833,8072834,8072835,8072836,8072837,8072838,8072839,8072840,8616163,8616164,8616171,8616172,8616173,3926733,3926734,3926735,3926736,8073097,8565075,8565088,8565091,3926795,3926807,11048432,11010284,10942257,10841396,8557637,7156480,7156483,7156487,4936871,4936895,10853550,10853551,8554303,4937112,4937118,4937146,4937175,4937196,7157023,7157030,7157051,4937235,4937240,7157062,4937247,7157101,7157102,7157130,4937319,7157175,4937384,4937449,4937514,3234234,3234235,3234236,4937579,10618888,4937644,4937709,3234454,4937774,4937839,4937904,10994930,4937969,10994931,10994932,10994933,10994934,10994935,10994936,10994937,10994938,10994939,10994940,4938045,8071077,8071111,3234801,3234802,3234803,3234814,10839300,10839301,10839302,10839303,4938297,4938307,4938317,4938323,8071371,4938362,4938363,4938364,4938365,8071377,4938366,8071405,8071434,8071455,8071497,8071502,8071509,4938527,4938528,4938529,4938530,4938531,4938532,8071580,8071645,10836941,8542125,8542265,10951657,10460659,10460669,10460679,10460685,8570151,10848353,3582154,10930892,8540622,3231766,3231767,8577893,8577897,9915639,9915640,9915653,9915659,9915660,9221433,8568084,8568222,8853729,9173973,8568476,8568511,8568520,8568521,8568524,8568529,8568530,3655255,3655256,3655257,3655383,7057886,7057887,7058797,10564618,10564619,10564620,10564621,10564650,10564651,10564652,10564703,10564704,10564705,10564706,10564707,10564708,10564709,10564710,10564711,10564758,10564759,10564760,10564761,10564762,10564763,10564764,10564765,9915305,9915337,9205255,6677477,9193329,10660199,9185598,9185599,10117918,4974671,4974672,4974675,4974681,4974682,4974683,8849760,9162120,6674548,6674586,10118981,9171207,9171208,9171209,9171210,9171211,10415291,10415292,10415293,10415294,10415618,10415619,4973580,4973581,4973589,4973590,4973597,4973598,10428195,6681061,6681062,10415859,10428342,10416132,10416161,10416162,9198503,9198527,9198547,9190919,9190920,9190921,9190922,9190923,10471560,6667209,6667210,6667211,6667212,6667213,6667265,3963612,8550683,8550798,9175687,8917479,10627971,10627972,10908742,10894611,10175660,10175661,10175783,10175787,10175788,10175789,10175790,10175803,10905028,10905029,10905030,10905031,10905032,10895335,10895336,10895337,10895338,10895339,10895340,10163504,10907606,10907624,10907625,10907626,10907627,10907628,10173715,10173716,10173717,10173718,10173719,10173720,10173721,10173722,10173723,10627205,10173815,10173816,10173817,10173820,10173821,10173822,10173823,10173876,10173879,10627550,10627552,10627573,10908196,10174217,10908206,10174218,10174258,10174259,10174260,10174261,10627959,10172378,10172379,10172380,10911394,10167412,10167413,10167414,10167415,10911403,10911468,10911519,10911538,10911539,10911562,10911563,10911645,10911670,10911671,10626535,10626536,10626537,10626538,10626539,10626540,10626541,10173327,10173328,10950204,10950205,10648187,10651987,10652001,10652107,10652118,10652119,10541955,10541956,10541957,10541958,10541959,10541960,10542115,10550461,10550462,10536624,10536625,10536626,10536627,10536628,10536629,10536630,10536631,10536632,10536633,10536634,10536635,10536636,10536637,10536638,10536639,10423381,10423391,10420679,10423053,8562594,10473276,10473280,10473289,10473307,10473308,10473309,10473310,10473311,10473346,10473347,10473355,10473356,10473375,10473376,10473377,10473378,10473398,10490400,10490424,10490425,10473438,10473439,10473440,10473478,8562814,10473509,8562885,10473742,10473744,8563067,8563085,10473904,10487006,10487155,10489316,10489317,10489318,10489319,10489320,10489360,10489361,10487453,10487458,10487468,10487469,10487470,10487471,10487472,10487473,10487474,10495512,10495513,10478518,10478519,10478520,10478521,10478522,10478523) 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'