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(11014531,11014615,10962653,10962664,10962665,11014675,11014694,11014745,11014770,11014791,11014804,11014828,10862012,10862013,10862141,11015541,11015550,11015551,11015560,11015561,11015562,11015570,11015571,11015572,11015578,11015579,11015580,11015589,11015590,11015593,11015594,11015599,11015600,11015607,11015613,8575109,11015620,11015621,11015622,11015627,11015628,11015629,11015630,11015639,11015640,10862253,10862254,10862255,10862256,10862257,10862258,10862259,10862260,11015675,11015676,11015686,11015688,11015698,11015699,11015716,11015717,11015723,11015724,11015725,11015726,11015727,11015728,11015729,11015740,11015741,10950684,11015765,11015766,11015775,11015776,11015791,11015812,11015813,11015814,11015824,11015867,11015881,11015885,11015890,11015893,11015894,11015895,11015909,11015918,11015934,8622104,11015966,11016057,11016079,11016122,11016123,11016124,11016125,11016126,11016127,11016130,11042131,11016131,11042132,11042133,11042134,11016137,11016138,11016146,11016147,11016153,11016163,11016164,11016179,11016201,11016202,11016213,9216183,11016222,11016223,10849835,10849847,11016279,10862892,11016297,11016320,10862970,10862983,11016401,11016424,11016425,11016444,11016464,11016481,7066825,10860135,8629718,8629731,8629732,8629733,8629734,8629735,8629736,10939437,10962436,8630440,7201123,8559029,10866382,8618066,10103389,10866612,8075284,8559442,10858822,10858823,10858824,8618764,8628657,8628720,10867506,10859576,8619348,10868100,11010506,11010507,11010508,8626577,8626578,8626579,8626580,10857225,10857226,10857227,10865378,10865379,3927545,10857684,10857685,10857686,10857687,10857688,10857689,10857690,10857691,10857692,10857693,10857694,10857892,10865956,11047520,11047521,11047522,8624504,10839725,10839728,10100256,3655821,10100296,10100297,10100298,10855579,10863810,10863811,10863812,10863813,10101112,10101113,10101137,10864309,10856347,10856348,10856359,8615924,10101311,10101312,10101391,10101423,10101442,3926839,11010440,11010441,11010443,11010444,10853153,3923375,10853290,10853294,10853320,10853354,10853355,10853356,10853357,10853358,10853359,10853455,10853456,10853465,10853466,10967883,10967884,10967885,10853489,10967886,10853490,10967887,10967888,10853491,10967889,10967890,10967891,10967892,10967893,10967894,10967895,10618365,10618367,10618370,3233810,3233811,11007147,3923951,8554709,8554711,8554712,8554725,10854287,10854288,8071092,8555287,3234992,8624327,10619922,11018503,11018515,11018524,11018559,11018560,8634566,10617107,11018819,8612003,8612006,8612020,8612028,11018879,11018893,11018894,11018900,11018912,10617430,10852608,10852613,11019063,11019064,11019067,11019077,11019079,11019080,11019081,11019220,10852870,10915478,9216479,10915501,10915505,10915515,10915517,10915544,10915548,11016580,10915558,10915564,10915566,10915571,10915574,11016607,11016608,10915580,10915581,11016614,10915587,11016617,11016618,10915590,3230357,3230361,10951574,10951575,3230384,3230388,11016660,10915632,10915636,10915639,10915658,10915670,11016711,11016743,10915727,11016760,11016778,11016779,11016786,11016787,11016788,10915761,11016789,10915767,10915779,11016829,10915803,11016838,11016839,11016840,11016844,11016845,11016856,11016857,10915835,11016868,9216843,11016894,11016940,11016950,10915922,11016951,10915941,11016978,10915955,10850587,10915968,10915972,10915975,10915979,10915982,10915983,8576506,8576507,11017020,11017028,11017029,11017092,11017093,11017094,10916072,10916096,11017125,10916100,10916101,11017139,11017140,11017141,11017142,11017143,11017144,10916119,11017174,10916152,10916154,10916170,11017200,10916176,11017219,11017232,11017233,11017234,11017235,10916219,11017253,11017255,11017256,11017257,11017258,11017259,11017264,10916236,11017270,11017271,11017277,11017278,11017279,10916253,10916255,11017285,11017288,10916261,10916266,11017303,10916283,10916287,10916291,10916292,11017324,10916307,10916308,10916317,10916324,10916325,10916327,10916336,10916344,11017376,10916350,10916365,10916375,10916396,10916400,10916402,11017431,10916405,10851040,10916415,10916418,8576940,10916437,9217436,10916447,11017476,11017478,3582178,10916470,10916474,10916479,10916481,10916485,11017522,10916498,11017543,11017544,11017545,11017546,11017547,11017548,10916526,10916529,11017561,11017565,10916538,10916540,11017571,10916545,11017585,10916559,10916572,10916580,11017634,10916608,10916609,10916612,10916614,10916620,10916623,11017653,10916628,10916639,10916690,10916693,10916706,10916709,11017745,10916723,11017786,11017792,10916770,11017812,10916804,10916815,10916819,10916909,11017960,11017961,11017962,11017998,10916976,10916977,8540885,10917047,11018080,10917060,10917067,11018102,11018103,11018104,11018123,10917111,10917114,11018164,10917143,10917144,10917145,10917146,10917158,11018202,10917180,10917183,10917191,11018224,10917204,11018269,11018270,11018271,11018272,11018273,11018274,11018275,11018287,11018302,11018319,11018321,11018322,10917295,11018360,11018401,10917381,10917382,10917396,10852045,10852048,11018446,9915714,9915715,10614649,10614650,9214156,9214157,10119737,10119738,8566543,8862703,9196442,9172459,9172465,9172468,9172473,9172493,9172498,9172504,9172505,9172506,9172514,10558453,10561984,10564991,10564994,3654415,9912112,10515724,10515726,10515737,10515738,10515743,10515744,10515745,10515746,10515747,10515748,10515749,10515784,10515785,10515786,10515793,10515822,10515834,10515835,10515836,10515838,10515839,10515957,10515958,10515990,10515991,10515992,10515993,10515994,10515995,10515996,10515997,10515998,10515999,10516000,10514029,10514030,10516055,10512577,6675214,6675241,8552467,8552468,8552469,9160305,10419381,10416460,10416533,10416549,10417634,4973672,6681100,10415850,9193252,9198840,6473428,9183139,6679514,10123511,6679541,6679548,6679556,6679571,6679593,6679599,6679613,6679650,10123664,6679682,6679685,6679688,6679711,6679714,6679743,9207550,6679760,9175998,9175999,9176000,10628799,10628801,10628802,10628803,10628805,8069051,10875181,10875182,10875183,10915257,10915274,10915288,10915304,10915323,10915327,10915342,10915353,10915371,10915412,10915414,10915419,10915464,10887610,10891442,10891445,10602360,10583806,10583807,10584254,10584255,10584256,10584257,10653398,10653399,10653400,10584522,10584523,10584524,10584525,10584526,10584527,10647703,10585352,10567354,10567355,10567361,10521341,10522237,10522550,10522551,10522552,10522553,10522554,10522555,10522562,10522563,10522564,10542817,10542818,10542819,10532850,10532851,10532852,10532853,10532854,10532855,10527101,10508137,10508138,10420286,10506496,10506497,10506498,10506499,10506500,10506501,10506502,10506743,10506744,10505912,10505913,10505914,10505915,10505916,10505917,10505918,10505919,10505920,10505921,10505922,10507960,10508086,10508087,10508088,10409221,10407343,10407354,10413371,10413372,10486238,10409602,10409603,10414016,10414521,10410743) 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'