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(8068848,8068850,10930247,10448088,10943692,8838799,10846082,10846089,10846093,10846094,10846095,10846098,10846099,10846100,10846101,10846102,10846106,10846108,10846110,10846111,10846114,10846116,10846117,10846119,10846120,10846124,10846127,10846128,10989144,4970777,8569851,8569855,8569862,8569877,8569878,7074119,7074122,7074123,7074146,7074150,7074151,7074175,7074178,7074179,7074185,7074190,10950842,4968534,8067343,8622341,10437538,4968932,7074768,4969053,10964614,8619781,4969329,10845011,10845025,8620293,10988159,8620324,8620327,8620329,8620334,10988184,8838011,8838014,8838017,8838018,8838019,8838026,8838040,8838042,8838047,8838052,8838056,8838059,8838060,8838067,8838069,8838071,8838073,8838075,8838076,8838077,8838082,8068485,8838085,8068487,8838086,8838087,8838088,8068491,8838089,8838090,8068492,8838092,8838093,8838098,8838099,8838101,8838108,8838110,8838113,8838119,8838126,8838128,8838146,8838147,10929933,8838151,8838152,8838155,8838156,8838157,8838158,8838159,8838167,8838182,8838184,8838188,8838195,8838199,8838207,8838208,8838209,8838210,8838211,8838212,8838221,8838228,3228331,10986120,8618284,10973175,10973176,3898992,8559490,7064696,8836200,10103986,8836347,8065914,8595739,8595805,10932618,4967487,10932657,8619239,8596126,8066489,8560582,8560586,8560592,3927382,11036738,10102340,10102708,8835068,10102840,4430379,4430394,4430401,4430403,4430404,4430405,4430406,4430407,4430409,4430430,4430431,4430432,4430435,4430437,4430443,4430447,10102962,10102968,4430472,4430500,4430503,4430505,4430506,4430508,8908015,7068987,7068997,10995701,10956716,8555990,8555991,7069075,10944643,10995971,8564173,8615547,10100870,3236172,11035441,11035453,11035454,10100910,11035467,11035469,11035489,11035495,11035502,11035508,11035513,11035515,11035517,11035521,11035523,11035524,11035530,11009531,11035531,11035533,11009534,11035534,11035540,11035541,11035548,11035550,11035561,11035566,11035567,11035568,11035569,11035570,11035571,11035572,11035573,11035574,11035575,11035576,11035581,11035585,11035588,11035597,11035599,11035600,11035605,11035614,11035617,11035623,11035625,11035627,11035633,11035638,11035640,11035646,11035654,11035656,11035658,11035662,11035664,11035665,11035679,11035724,11035728,11035746,11035762,11035763,11035768,11035776,11035777,11035783,11035786,11035789,11035812,11035818,11035831,11035834,11035837,11035850,11035855,8557196,8616148,11010139,11010152,10958317,10958326,3927140,3927144,3927147,3927152,3927154,3927157,3927159,3927160,3927161,3927162,3927164,3927165,3927166,3927168,3927170,3927172,3927174,10967666,8612821,3234071,3234072,3234079,11007557,11007558,11007564,11007565,11007572,11007573,11007574,3924443,8907364,11008350,10619702,10619705,3232520,11044858,11044862,10836941,10953892,10836977,10967039,10954185,10622568,11045282,10967324,8612652,10617944,10620101,9216832,10990991,10990993,8570303,10951956,8570308,8570309,10848216,10952256,10952258,10965365,10615847,10615848,10615857,8610676,8610714,10930991,10930999,10426514,10921719,10921743,10921745,10921762,10952911,10952915,10921768,10952917,10921773,10921775,10921778,10921779,10921790,10921791,10921792,10921793,10921794,10921795,10921806,10921807,10921808,10921809,10921812,10921814,10921820,10921829,10921838,10921848,10921875,10921897,10921901,10921902,10921906,10921912,10921915,10921916,10979065,10921920,10921921,10921926,10921952,10921954,10921955,10926995,10426862,8577839,3232220,10953544,7155460,3654524,9189365,3654614,9165536,10562437,8864275,8864279,10562582,9197908,6666058,10559943,10559946,10559947,10559949,7057687,10119855,10560508,10560521,9914082,9914126,9914275,9914276,9914277,9914278,9914279,9914280,9914281,9914282,9914283,9914284,9914285,9914286,9914287,9914288,9914289,9196226,10120443,10120446,9204565,9204571,9204572,9204586,7058763,9204600,3653813,9204607,9204609,9204611,9204612,9204617,9204618,9204623,9204628,9204630,9204645,9204646,9204649,7058833,9196689,9204706,9204708,9188710,9188752,9188757,9188777,9188781,9164895,8863510,8863511,8863515,10558854,9205079,9165253,10517548,9161788,8592955,8593083,10513787,7056502,7056504,10118896,9170937,10518816,7057212,9179106,9179109,10124530,10124532,10427992,10124880,10124885,10124887,7055171,9193105,9193106,9209193,9209198,9161249,4971245,10122595,9174466,6678739,9182582,6666726,6666728,10471310,9174819,9166826,9166828,9174950,10465568,6667146,6667235,4972123,8917033,10465984,9183461,10123694,6667571,6667572,9183641,8917323,10466300,8917414,4972659,10464474,10470521,10427564,10464849,10627974,10903771,10903782,10903785,10628552,10628560,10628572,8594194,10175199,10879259,10899295,10629524,10905132,10171272,10629872,10629878,10629882,10629891,10629892,10629894,10629897,10629904,10629909,10629910,10629911,10905423,10629914,10629927,10629928,10629934,10629935,10629942,10629944,10629945,10629946,10629949,10629952,10629958,10629959,10183593,10183600,10183604,10183605,10183611,10183618,10183623,10183640,10183647,10183648,10183650,10183651,10183655,10183656,10183662,10163664,10183665,10183666,10183676,10183677,10183683,10183686,10183693,10183707,10183715,10183725,10183727,10183739,10183740,10892743,10183755,10183757,10183759,10183767,10183768,10183769,10183772,10183780,10183781,10173782,10183782,10183785,10183815,10183816,10183832,10183833,10183838,10183846,10183849,10893158,10908159,10893159,10908160,10893160,10893161,10184226,10174360,10629962,10629978,10629980,10629986,10629988,10629992,10629996,10629997,10625051,10890701,10630628,10630649,10911366,10911482,10911528,10172591,10949605,10949810,10949830,10887041,10626578,10902206,10626782,10902295,10158439,10571272,10574364,10574365,10574366,10574367,10574368,10574369,10574370,10574371,10574372,10574373,10574374,10574375,10574376,10574377,10574378,10574379,10574380,10574381,10574382,10574383,10574384,10574385,10574386,10574387,10574388,10574389,10574390,10574391,10574392,10574393,10574394,10574395,10574396,10574397,10574398,10574399,10574400,10574401,10574402,10574403,10574404,10574405,10571642,10571643,10574790,10574791,10575098,10572224,10572225,10572226,10572227,10572228,10606085,10578525,10578528,10578530,10578533,10569671,10569672,10578693,10578694,10578695,10578696,10578699,10578700,10572918,10572919,10572920,10578921,10572921,10572922,10572923,10572924,10572925,10572926,10572927,10578928,10572928,10578929,10572929,10572930,10572931,10572932,10572933,10572934,10572935,10572936,10578937,10572937,10572938,10572939,10572940,10572941,10572942,10572943,10572944,10572945,10572946,10578947,10572947,10572948,10572949,10578954,10651018,10575978,10579031,10579043,10579048,10579051,10579057,10579072,10579082,10579084,10579112,10579124,10579125,10579131,10579136,10579148,10579149,10579150,10579151,10579152,10579153,10579154,10579155,10579156,10579157,10579180,10579212,10579213,10579225,10579226,10579233,10579235,10570236,10570237,10579241,10579247,10579249,10579252,10579256,10579257,10579258,10579273,10579285,10579287,10579291,10579295,10579296,10579301,10579316,10579336,10579337,10579351,10579363,10579367,10579379,10579396,10570405,10579408,10579409,10579410,10579411,10579412,10579413,10579425,10579426,10579432,10576590,10651889,10570999,10571000,10571001,10571002,10571003,10571004,10545579,10519604,10537616,10537624,10537625,10537632,10529690,10537747,10519858,10519861,10520142,10538272,10532401,10534477,10422304,10476931,10476932,8562436,10479204,10479233,10479246,10479252,10479259,10494273,10479286,10496310,10496313,10479319,10494339,10494342,10494346,10494347,10479352,10479364,10486377,8562836,10479545,8563060,10492806,10487186,10489324,10489388,10489400,10493516,10493537,10493538,10493539,10476560,10495598,10495636,10476714,10495743,10476844) 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'