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(10861374,10861375,10861449,10861450,10861451,10861515,10861516,10861517,10861518,10861519,10861520,10861521,10861522,10861523,10861524,10861525,10861526,10861527,10861528,10861529,10861530,10861531,10861532,10861533,10861534,10861535,10861536,10861537,10861538,10861539,10861540,10861541,10861542,10861543,10861544,10861545,10861546,10861547,10861548,10861549,10861550,10861551,10861552,10861553,10861554,10861555,10861556,10861557,10861558,10861559,10861560,10861561,10861562,10861563,10861564,10861565,10861566,10861567,10861568,10861569,10861570,10861571,10861572,10861573,10861574,10861575,10861576,10861577,10861578,10861579,10861580,10861581,10861582,10861583,10861584,8630980,8630981,8630982,4970765,8631163,8631253,3229170,3229187,8631540,8631541,8631542,8631543,8631544,8631545,8631546,8631547,8631548,8631549,8631550,8631551,8631552,8631553,8631559,10862885,10862897,10862900,8629471,8629476,8629477,10858311,10858312,10858313,10858314,10858315,10858316,10858317,10858318,10858319,10858320,10858321,10858322,10858323,10858324,10858325,10858326,10858327,10858328,10858329,10858330,10858331,10858332,10858333,10858334,10858335,10858336,10858337,10858338,10858339,10858340,8627789,8595188,8595189,8595190,5654673,8629273,8629274,8629431,8626841,8626842,8626843,8626844,8626927,10857681,10865781,10865782,10865783,10865784,10865785,10865786,10865787,10865788,10865789,7198677,7198684,7198946,7199173,7199174,7199175,7199176,7199177,7199178,10864657,8860389,8860390,10856789,10856790,10856791,10856792,10856793,10856794,10856795,10856796,10856797,10856798,10856799,10856800,10856801,10856802,10856803,10856804,10856805,10856806,10856807,10856808,10856809,10856810,10856811,10856812,10856813,10856814,10856815,10856816,10856817,10856818,10856819,10856820,10856821,10856822,10856823,10856824,10856825,10856826,10856827,10856828,10856829,10856830,10856831,10856832,10856833,10856834,10856835,10856836,10856837,10856838,10856839,10856840,10856841,10856842,10856843,10856844,10856845,10856846,10856847,8626258,8626259,10864921,10865038,10865039,10865040,10865041,10865042,10865043,10865044,10865045,10865046,7197133,8070781,10854313,10854314,10854315,10854316,10854317,10854318,10854319,10854320,3234501,3234502,10838875,8624429,8634557,8634558,8634559,8634560,8634561,8634562,8634563,8634564,10617485,3232797,8905857,8905858,8905859,8905860,10615021,10615022,8633332,8633333,8633334,8633335,8633336,8633337,8633343,8633351,8633352,8633353,8633354,8633355,8633356,8633357,8633358,8633359,8633360,8633361,8633362,8633363,8633364,8633365,8540715,10616716,10616717,10616718,10616719,10616720,10616721,10616722,10616723,10616724,10616725,10616726,10616727,10616728,10616729,8634239,8634240,8634241,8634242,8634243,8634244,10611233,10614242,10614243,10614244,10614245,10614246,10614247,10614248,10614249,10614379,10614424,10614425,10614426,10614427,10614428,10614429,10614430,10614431,10614432,10614433,10614434,10614435,10614436,10614437,10614438,10614439,10614440,10612059,10612386,8851701,10609769,10609770,10609771,8566710,8566711,8566712,8852151,10613523,10613524,10613525,8852699,7055499,10117564,7055655,6673729,6673730,9911786,9911787,9911788,10117879,9169802,9169803,9169804,9169805,10118181,10118182,10118215,10118216,10118217,9912344,8850174,8850175,9912753,9912767,9912768,9912769,9912770,9912771,9912772,9912773,9912774,9912775,8552224,9913239,9913240,9913241,9913242,9913243,9913244,9168388,10418323,10418324,10418325,10418326,10418327,10418328,10418329,10418330,10418331,10415378,10415379,9168477,10415409,10415410,10415411,10415412,10415413,10415414,10415415,10415416,10415417,10415418,10415419,10415420,10415421,10415422,10415423,10415424,10415425,10415426,10415427,10415428,10415429,10415430,10415431,10415432,10415433,10415434,10415435,10415436,10415437,10415438,10415439,10415440,10415441,10415442,10415443,10415444,10415445,10415446,9168525,10415447,10415448,9168526,10415449,9168527,10415450,10415451,10415452,10416453,10415453,10415454,10415455,10415456,10415457,10415458,10415459,10415460,10415461,10415462,10415463,10415464,10415465,10416466,10415466,10415467,10415468,10416469,10415469,10415470,10415471,10415472,10415473,10415474,10415475,10415476,10415477,10415478,10415479,10415480,10418994,10418995,9169177,9169251,9169252,9169253,9169254,9169255,9169256,9169257,9169258,10117462,10471083,10469245,8550057,8550093,8550094,8550095,10467570,8550238,976545,10427661,10889258,10889259,10889602,10889603,10889604,10889605,10889606,10889607,10889608,10889609,10889610,10889611,10884654,10884888,10889977,10889978,10889979,10889980,10889981,10885078,10885168,10885170,10885176,10885359,10888340,10885849,10162108,10626442,10626443,10626444,10887128,10887264,10887265,10887266,10887267,10887268,10887378,10887379,10887380,10887381,10887382,10887383,10887384,10887385,10887386,10887387,10887388,10887389,10887390,10887391,10887392,10887393,10887394,10887395,10887396,10887397,10887398,10887399,10887400,10887401,10887402,10887403,10887404,10887405,10887406,10887407,10647598,10647599,10647600,10590577,10548450,10548451,10508183,10508184,10508185,10508186,10508187,10508188,10508189,10508190,10508191,10508192,10508193,10508194,10508195,10508196,10508197,10508198,10508199,10411701,10411702,10411703,10411704,10411705,10411706,10411707,10411708,10411709,10411710,10411711,10411712,10411713,10411714,10411715,10411716,10411717,10411718,10411719,10411720,10411721,10411722,10411723,10411724,10411725,10411726,10411727,10411728,10411729,10411730,10411731,10411732,10411733,10411734,10411735,10411736,10411737,10411738,10411739,10411740,10411741,10411742,10411743,10411744,10411745,10411746,10411747,10411748,10411749,10411750,10411751,10411752,10411753,10411754,10411755,10411756,10411757,10411758,10411759,10410058,10410059,10410060,10410061,10410062,10410063,10410064,10496804,10496805,10412280,10412844,10412845,10412846,10412847,10412848,10412849,10412850,10412851,10412852,10412853,10412854,10412855,10412856,10412857,10412858,10412859,10412860,10412861,10412862,10412863,10412864,10412865,10412866,10412867,10412868,10412869,10412870,10412871,10412872,10412873,10412874) 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'