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(3228552,10950390,3229201,3229280,7065981,3229967,7074698,8609702,3227396,3227397,8067934,8573233,8573337,7201337,7201367,7201430,7201431,7201594,7201595,10960058,7201660,8911579,8911580,7064547,7064548,7201840,7201921,7201969,7201974,7202048,7202088,7202089,7202136,7202138,8911952,8911953,8911954,8911955,8911960,8911961,8911962,8911963,7202155,7202189,7202205,7202206,7202221,7202243,7202314,7202321,7202325,7202618,7202683,7202684,7202685,7202686,7202687,7202688,7202689,7202690,7202691,7202692,7202693,7202694,7202757,3227098,7200293,8910239,8910240,8910241,10102359,7200536,7200622,7200637,7200695,7200714,7200748,7200749,7200778,8910673,7200868,7200910,7200931,7200933,7200934,7200938,7201113,7198206,7198217,7198218,7198273,7198275,7198423,8908422,7198680,7198681,7198682,7198683,7198684,7198685,7198686,7198688,7198689,7198690,7198691,7198693,7198694,7198695,7198696,7198698,7198700,7198701,7198702,7198710,7198711,7198712,7198713,7198714,7198716,7198717,7198722,7198723,7198726,7198728,7198729,7198732,7198733,7198734,7198735,7198736,7198737,7198738,7198739,7198740,7198741,7198742,7198743,7198744,7198745,7198746,7198747,7198749,7198751,7198758,7198759,7198760,7198762,7198763,7198768,7198769,7198772,7198817,7199244,8909073,8909074,7199385,8909871,7200098,7200144,7200158,7200163,7196266,7196267,10623065,7196294,7196295,7196296,7196332,7196458,10618270,7196494,10618275,10618276,10618277,10618281,10618288,10618305,10618306,10618309,10618310,7196530,7196531,10618313,10618314,10618315,7196537,7196538,7196539,7196595,7196629,7196649,7196671,7196687,7196699,7196700,7196712,8906550,8906551,7196846,7196894,8906814,8906891,7197117,8906944,7197231,7197232,7197235,7197246,10838792,7197412,7197433,8907405,7197651,8907468,8907471,7197672,7197823,7198036,10619898,10619899,7198171,10427317,10617035,10617245,10617279,10617286,10617313,10617324,10953985,10953987,10953988,10954017,10954018,10954022,10954024,8612202,10622405,10622408,8905482,10622453,10954195,10954196,10954198,10954199,10954200,8905684,8905826,8905858,7196133,10614971,10425390,10425393,10425394,10425471,10615137,10425553,10425574,10615243,10615244,10425582,10615261,10615263,10615389,10615439,10615467,10615573,10615744,10615768,10615774,10615792,8540351,10426275,10426284,10616049,10616060,10426443,8540594,10616175,10616208,10616294,10616296,8904334,8904341,10616328,10616333,10616336,10616337,10616338,10616339,10616340,8904375,10616349,10616354,10616358,10616359,10616366,10616368,10616370,10616442,10616459,8904543,10616573,8611399,10992335,10992336,10616685,10616788,10616796,10616816,10616823,8904927,8904934,8904935,10616913,8904945,10614048,10614095,9165459,10611236,10611239,10714119,10611343,10611370,10614400,10614427,10611450,10611451,10611462,10611464,10611466,10611488,10611489,10614489,10611497,10611498,10611509,10611510,10611521,10614532,10614555,10559710,10559712,10611563,10611568,10614664,10611675,10611677,10611678,10611698,10611761,10611785,7057465,10611995,10611996,10611997,7017017,7017018,10609036,7017041,7017042,7017065,7017066,10612080,10612086,7017089,7017090,7017109,7017110,7017129,7017130,7017181,7017182,7017219,7017220,7017243,7017244,10612267,10609285,10612344,10609362,10609363,10609367,10612381,10612383,10609387,10609506,10609507,10609508,10609509,10612524,10609537,10609545,10609562,10612580,10612583,10612608,10612609,10609617,10609631,10609632,10609633,10609635,10612660,10612661,10612662,10612663,10609663,10609675,7017679,7017680,7017681,7017682,7017683,7017684,7017685,7017686,7017687,7017688,10612820,7017812,7017813,7017814,7017815,10609834,10612845,10612891,10609899,10610006,10610068,10613079,10613157,10613166,10613168,7058908,10610477,10613540,10613541,10613544,10613603,10613606,10613643,10610668,10610708,10613752,10610779,10610784,10610862,10613899,10610927,10117524,9169403,9169450,10117654,10117674,10117675,10117676,9169580,10117859,10118009,9161893,10118180,10118231,10118289,10118301,10118370,10118420,10118453,8551565,10118577,10118910,10415224,10419228,10419229,10419232,10419233,10419234,10416235,10419255,10419261,9168363,10417288,10417291,10418300,10418301,10416301,10418302,9168390,9168391,10415314,10418320,10415321,10418321,10416322,10416328,10415344,10416347,10417347,10416356,10416357,10419358,10416358,10416359,10417359,10416360,10419360,10416361,10419362,10416362,10416363,10419365,10417369,10415370,10417370,10416376,10416379,10415383,10419384,10415395,10419412,10419429,10416444,10416453,10416454,10419458,10419459,10419465,10418466,10416468,10416470,10416481,10415482,10419497,10416501,10418502,10416505,10418505,10419511,10416513,10416533,10417537,10416542,10415543,10416543,10416545,10415547,10416547,10416548,10417550,10418552,10418553,10418555,10419556,10418557,10417565,10419566,10418570,10418571,10416572,10416579,10418581,10415583,10415584,10415585,10415586,10417609,10416640,10416641,10417645,10417646,10415648,10419649,10415649,10415650,10415651,10416653,10415654,10415658,10415660,10416663,10416664,10416665,10416666,10416667,10416668,10415682,10417700,10417715,7014458,7014459,7014460,7014461,7014462,7014463,7014464,7014465,10418734,7014466,7014467,10419768,10419770,10417770,10419771,10419773,10419777,10419780,10418785,10417786,10415790,10417792,10419859,10419860,10419861,10418864,10418865,9168975,10416920,10418934,10418941,10416955,10416956,10416957,10417959,10417960,10418963,10418964,10418966,10417971,10418976,10417982,10416985,10417985,10417987,10418989,10418991,10419003,10418009,10418010,10417018,10417020,10417024,10419026,10417027,10417028,10417029,10416030,10418030,10419031,10419032,10416032,10419037,10419038,10419040,10418040,10417041,10419041,10417042,10419042,10419043,10419044,10419046,10419047,10417054,10417055,10418055,10416056,10419057,10417057,10417058,10417059,10419060,10417060,10417062,10417063,10417064,10417065,10417066,10417067,10418068,10417068,10417070,10417071,10419072,10417073,10419074,10417075,10417076,10419076,10418076,10419077,10418077,10419078,10419083,10419087,10419088,10419094,10418099,10419117,10419118,10419120,10419123,10419125,10117411,10418141,10418144,10418145,9169239,10418164,10117452,10117453,10419179,10117456,10416185,10117462,10117463,10416189,9169268,10416190,10416191,9169270,10416192,10416193,10419194,10117472,10419198,10468915,8549504,8549506,10471128,8549892,8550058,10467513,8550096,10467522,10467536,10467537,10469548,8550220,10470112,4972394,4972397,10470175,10464213,10464231,9167681,10470324,9167748,10470328,10470350,10464378,10470399,10470401,10470402,10470405,10470406,10470407,10116208,10116210,10116211,10116215,10116216,10116217,10116218,10116219,10116220,10116223,9168029,10470643,10468686,10468733,10468742,9168183,9168207,9168208,7013879,7013880,7013881,7013882,7013883,7013884,7013885,7013886,7013887,7013888,7013889,7013890,7013891,7013892,7013893,7013894,7013895,7013896,7013897,7013898,7013899,7013900,7013901,7013902,7013903,7013904,7013905,7013906,7013907,7013908,7013909,7013910,7013911,7013912,7013913,7013914,7013915,7013916,7013917,7013918,7013919,7013920,9168269,9168270,10468847,10468850,10883492,10883554,10888637,10888638,10888639,10888640,10888641,10888642,10883658,10888732,10888733,10888798,10888819,10883949,10888950,10883951,10883985,10884122,10884194,10889222,10889225,10889310,10889311,10884335,10884519,10884587,10889600,10889617,10884630,10889633,10889663,10889672,10889709,10889710,10889798,10879879,10879880,10879882,10879911,10875016,10885020,10875022,10875024,10890046,10890047,10890230,10890233,10890244,10885302,10885303,10882496,10882508,10882509,10887525,10887544,10882577,10882586,10632108,10882684,10887758,10882765,10627303,10627312,10887883,10882891,10887930,10887931,10888049,10888051,10888104,10888106,10883126,10883127,10883128,10883129,10888160,10888163,10888173,10888175,10888179,10888185,10888190,10888191,10888192,10888193,10888196,10888200,10888205,10888209,10888212,10888213,10888216,10888217,10888220,10888221,10888231,10888232,10888233,10888235,10888236,10888237,10888238,10888242,10888243,10888245,10888246,10888247,10888264,10888274,10888336,10883357,10883378,10883430,10888433,10888434,10883455,10885512,10885815,10161931,10886016,10881486,10881487,10876826,10886934,10886972,10886982,10887013,10887073,10877124,10877125,10877176,10877177,10887391,10882406,10882407,10882412,10882413,10882442,10887454,10887455,10887456,10626954,10598619,10529727,10521873,10528238,10423726,10423728,10477141,10477420,10477428,10477436,10477504,10496517,10496520,10477548,10489212,10489235,10489241,10406907,10472572,10406928,10406929,10407026,10407081,10407083,10407097,10407102,10407104,10407108,10407112,10407114,10407125,10407128,10407133,10407138,10407142,10407143,10407144,10407145,10407146) 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'