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(8630784,8631030,8631052,8631053,8631054,8631055,8631056,8631057,8631058,8631059,8631060,8631061,8631062,8631063,8631064,8631065,8631066,8631067,8631068,3228908,8583199,3229183,3229184,3229188,3229189,3229190,3229201,3229207,3229280,7065968,10950646,10849389,8631829,8631831,7066267,10849985,10863023,8632425,8632426,10863085,10860103,10860105,10860106,10860109,10860123,10860131,10860132,8067919,10860259,10860260,10860261,10860262,10860264,10860265,10860266,10860268,10860273,10860287,10860288,10860289,10860290,10860291,10860406,8573332,10860551,8595143,8595146,10858822,10858850,10858851,10858861,10858870,10858872,10858878,10858898,7202048,10859279,10859318,10859397,10859431,8628812,8628813,10859457,7202687,7202767,10859992,10859994,10860045,10860049,10860050,10860051,10860075,10860076,10860077,10860078,3227206,10860085,10860086,10860093,10860094,10860095,10860098,10860099,10860101,10860102,10865412,8834762,8834763,10865953,10865957,10865996,8627377,8627378,8627379,8627380,8627381,8627382,10866091,7198347,8624758,8624759,8624760,8624763,3925519,7198525,7198526,7198527,7198528,3235778,7198662,7198693,7198760,8625241,8625242,10863927,10863928,10863929,8625374,8625375,10864152,10864153,11035974,10864749,7199710,10864757,10864760,10864761,10864762,10864763,10864817,10864818,10864819,10864820,10864821,10864822,10857092,10853411,3923548,3923593,3923602,3923604,3923640,3923641,3923642,10853731,10853732,10853733,8906767,10854226,10854227,7197439,7197608,7197619,7197621,7197630,7197633,7197635,7197636,7197639,7197640,7197641,7197644,7197649,7197651,7197654,7197657,7197660,7197661,7197663,7197664,7197667,7197668,7197671,7197672,7197674,7197676,7197679,7197681,7197682,10616967,10616968,10616969,10617162,10617163,10617169,10617170,3922823,8905582,8905595,8905596,8905658,8905716,8905777,8632490,8632495,8632496,8632497,8632500,8632502,8632503,10850371,10615335,10615717,10615719,10615971,10615972,10615980,10616089,10616092,10426342,10426356,8540594,8540596,8611398,8611451,10616866,8634376,8634377,8634378,8634379,10616911,10614024,10614050,9165541,10614274,10614282,10714119,10614304,10714129,10714149,10611367,10611368,10611369,10611370,10614476,10614486,10559766,10611713,10611764,10611802,10611819,10612051,10609151,10609152,10609153,10609167,10609170,10609171,10609188,10609194,10609195,10609230,10609247,10609250,10609260,10609262,10609397,10609398,10612506,10612558,10612696,10612697,10612725,10612746,10612755,10612757,10612767,10612825,10612895,10612896,10612897,10612898,10612910,10612911,10612912,10612913,10612914,10612915,10613019,10613139,10613140,8852311,10613184,8852348,8852349,10613187,8852350,8852351,10613189,8852352,8567072,8567073,10613242,10613243,10613265,10613266,10610268,10610271,10613286,10613324,10613325,10613348,10610396,10613458,10613464,10613490,10613508,10613509,10613543,10613546,10613547,10613562,10613645,10613662,10613664,10613673,10613682,10613683,10613685,10613691,10613693,10613694,10613708,10613709,10613710,10613716,10613717,10610846,10610851,6673526,6673527,6673528,6673529,6673530,6673531,7055491,6673532,6673533,6673534,6673535,6673536,6673537,6673538,6673539,6673540,6673541,6673542,6673543,6673544,6673546,6673549,6673550,6673556,6673563,6673642,6673644,6673645,10515335,9911939,9911940,9169870,9169871,10118111,6674190,9912217,6674256,6674288,6674323,6674326,9912371,9912372,9912373,9912404,9912484,9912485,9912488,9912493,9912512,9912514,9912515,9912517,9912518,9912525,9912568,10118591,10118592,10419232,9168363,10417358,10417359,10417360,6672706,6672707,9168854,9168861,9168871,6673078,6673080,9168962,10418060,10418068,10418076,10418077,10418078,10418079,10418141,10418142,10418143,10418144,10418145,10418146,10468947,10471113,8550154,8916797,9167681,976472,976473,6671918,976521,976522,976525,9168290,10888819,10888839,10888842,10888843,10888844,10888845,10888846,10888847,10888848,10888849,10888850,10889052,10889060,10884195,10884519,10884523,10889591,10889707,10884933,10874992,10875004,10875005,10875006,10875007,10875008,10875009,10875010,10875011,10875012,10875014,10875015,10875016,10875017,10875018,10875019,10875020,10875021,10875022,10890022,10875023,10875024,10875025,10875026,10875027,10875028,10890028,10875032,10875033,10875034,10875035,10875036,10875037,10875038,10875039,10875040,10875041,10875042,10875043,10875044,10875045,10875046,10875047,10875048,10890094,10890105,10890106,10890107,10890108,10890109,10890110,10890111,10890112,10890113,10890114,10890115,10890116,10890117,10890118,10890119,10890120,10890121,10890122,10890123,10890124,10890125,10890161,10890162,10890173,10890174,10890175,10890208,10890209,10890210,10890211,10890212,10627298,10627301,10627303,10627304,10627307,10627308,10627309,10627312,10627313,10888298,10888463,10885497,10885526,10885578,10885580,10885614,10885616,10885617,10885621,10885624,10885625,10885626,10885627,10885646,10885691,10885723,10885724,10885741,10885798,10885799,10885927,10885928,10885938,10885955,10881554,10876593,10876600,10882360,10882435,10602445,10590192,10647649,10647650,10603879,10604067,10527750,10508267,10508473,10508474,10508527,10508606,10507675,10507676,10507836,10507937,10508002,10508009,10508010,10508011,10508012,10508025,10508034,10413383,10413384,10413394,10413399,10413403,10413404,10413409,10413423,10407448,10477141,10409749,10409750,10409751,10413754,10413759,10413761,10413765,10413853,10413896,10413915,10411933,10409989,10409990,10414388,10414391,10414438,10414441,10414442,10414443,10414444,10414463,10414464,10414465,10414466,10414473,10414475,10414484,10414485,10414486,10414487,10414489,10414490,10414491,10414492,10414493,10414494,10414496,10414497,10414498,10414500,10414515,10414616,10414617,10414623,10414630,10414631,10414632,10414633,10414634,10414707,10414710) 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'