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(10447907,10447908,10447909,10931048,10931049,10931050,10931051,10931052,10931053,10931054,10931055,10931056,10931057,10931058,10931059,10931060,10931061,10931062,10870948,10870949,10870950,10870954,10870955,10870956,10870957,10870958,10870959,10437322,10437323,10437324,10437325,10437326,10437327,10437328,10437329,10437330,10437331,10437334,8575782,8575783,8575784,8575785,8575786,8575787,8575788,8575789,8575790,8575791,8575792,8575793,8575794,8575795,8575796,8575797,8575798,8575799,8575800,8575801,8575802,8575803,10929954,10929955,10929956,10929957,10929958,10929959,10929960,10929961,10929962,10929963,8068800,8068801,8068802,8068803,8068804,8068805,8068806,10103065,10103066,10103067,10103068,10103069,10103070,10103071,10103072,10103073,10103074,10103075,10103076,10103077,10103078,10103079,10103080,10103081,10103082,10103083,10103084,10103085,10103086,10103087,10931998,10932000,10932001,10932002,10932003,10932004,10932005,10932006,10932007,10986475,10986476,10986477,8836444,10843848,10843849,10843850,10843851,10843852,10843853,10997620,10997621,10997622,10997623,10997624,10997625,10997626,10997627,10997628,10997629,10997630,10997631,10997632,10997633,10997634,10997635,10997636,10997637,10997638,10997639,10997640,10997641,10997642,10997643,10997644,10997645,10997646,10997647,10997648,10997649,10997650,11049014,11049021,11049022,11049023,11049024,11049025,11049026,7071822,7071823,7071824,7071825,7071826,7071827,7071828,7071829,7071830,7071831,10103047,10103052,10103053,10103054,10103055,10103056,10103057,10103058,10103059,10103060,10103061,10103062,10103063,10944690,10944691,10944692,10944693,10944694,10944695,10944696,10944697,10944698,10944699,10944700,10944701,10944702,10944703,10944704,10944705,10944706,10944707,10944708,10944709,10944710,10944711,10944712,3235832,3235833,3926248,3926249,3926250,3926251,3926252,3926253,3926254,3926255,3926256,3926257,8615772,8615773,8615774,8615775,8615776,8615777,8615778,8615779,8615780,8615781,8565006,8557523,8557524,8557525,8557526,8557527,8557528,8557529,8557530,8557531,10997605,10997606,10997607,10997608,10997609,10997610,10997611,10997612,10997613,10997614,10997615,10997616,10997617,10997618,10997619,3233973,3233974,3233975,3233976,3233977,3233978,3233979,3233980,3233981,3233983,3233984,3233985,3233986,3233987,3233988,3233989,3233990,3233991,3233992,3233993,3233994,3233995,3233996,3233997,3233998,3234000,3234001,3234002,3234003,3234004,3234005,3234006,3234007,3234008,3234009,3234010,3234011,3234012,3234013,3234014,3234015,3234016,3234017,8070966,8070968,8070969,8070970,8070973,8070974,8070975,8070976,8070978,8070979,8070980,8070981,8070982,8070983,8070984,8070985,8070986,8070987,8070988,8070989,8070990,8070991,8070992,8070993,8070994,7156311,7156312,7156313,7156314,7156315,7156316,7156317,7156318,7156319,7156320,7156321,7156322,7156324,7156327,7156328,7156329,7156330,7156331,7156332,7156333,7156334,7156335,7156336,7156337,7156338,7156339,7156340,7156341,7156342,7156343,7156344,7156345,7156346,7156347,7156348,7156349,7156350,7156351,7156352,7156353,7156354,7156355,7156356,7156357,7156358,7156359,7156360,7156361,7156362,7156363,7156364,7156365,7156366,10951745,10951746,10951747,10951748,10951749,10951750,10951751,10951752,10951753,10951754,10951755,10951756,10951757,10951758,10951759,10951760,10951761,10951762,10951763,10951764,10951765,10951766,10951767,10951768,10951769,10951770,10951771,10951772,10951773,10951774,10951775,10951784,10427287,9221403,9221404,9221405,9221406,9221407,9221408,9221409,9221410,9221411,9221412,9221413,8568034,8568035,8568036,8568037,8568038,8568039,8568040,8568041,8568042,8568043,8568044,8568045,8568046,8568047,8568048,8568049,8568050,10714283,10714284,10714285,8864341,8864342,8864343,8864344,8864345,3655044,3655045,3655046,3655047,3655048,3655049,3655050,3655051,3655052,8542595,8542596,8542597,9220335,9220336,9220337,9915234,9915235,6677414,6677415,6677416,6677417,6677418,6677419,6677420,6677421,10660178,10660180,10660181,10660182,10660183,8592918,8592919,8592920,8592921,8592922,8592923,8592924,8592925,8592926,3651663,10428068,10428069,10428070,9190331,9190333,9190334,9190335,9190336,9190337,9190338,9190339,9190340,9190341,9190342,9190343,9190344,9190345,9190346,9190347,9190348,9190349,9190350,9190351,9190352,9190353,9190354,9190355,9190356,9190357,9190358,9190359,9190360,9190361,9190362,9190363,9190367,9190368,9190369,9190370,9190371,9190372,9190373,9190374,9190375,9190376,9190377,9190378,9190379,9190380,9190381,9190382,9190383,9190384,9190385,9190386,9190387,9190390,9190391,9190392,9190393,9190394,9190395,9190396,9190397,9190398,9190399,9190400,9190401,9190402,9190403,9190404,9190405,9190406,9190407,9190408,9190409,9190410,9190411,9190412,9190413,9190414,9190415,9190416,9190417,9190418,9190419,9190420,9190421,8854619,8550731,8550732,8550735,8550736,8550737,8550738,8550739,8550740,976643,976644,8594237,8594238,8594239,8594240,8594241,10627097,10627098,10627099,10627100,10627101,10627102,7001004,7001105,7001106,10172905,10172906,10172907,10172908,10172976,10172977,10172979,10172980,10172981,10172982,10172983,10172984,10172985,10172986,10172987,10172988,10172989,10172990,10172991,10172992,10172993,10172994,10172995,10172996,10172997,10172998,10172999,10173000,10173001,10173002,10173003,10173004,10173005,10173006,10173007,10173008,10173012,10173013,10173014,10173015,10173020,10173021,10173022,10173023,10173024,10173025,10173026,10173027,10173028,10173029,10173030,10173031,10173032,10173033,10173035,10173036,10173037,10173038,10173039,10173040,10173041,10173042,10173043,10173044,10173045,10173046,10173047,10173048,10173049,10173050,10173051,10173052,10173053,10173054,10173055,10173056,10173057,10173058,10173059,10173060,10173061,10173062,10173063,10173064,10173065,10173066,10173067,10173068,10173069,10173070,10173071,10173072,10173073,10173074,10173075,10173076,10173077,10173078,10173079,10173080,10173081,10173082,10173083,10173084,10173085,10173086,10173087,10173088,10173089,10173090,10173091,10173092,10173093,10173094,10949893,10173095,10949894,10173096,10949895,10173097,10949896,10173098,10949897,10173099,10949898,10173100,10949899,10173101,10949900,10173102,10907318,10907319,10907325,10907326,10907327,10907328,10907329,10907330,10907331,10907332,10907333,10907334,10907335,10907336,10907337,10907338,10907339,10651703,10651704,10651705,10651706,10651707,10651708,10651709,10651710,10651711,10651712,10651713,10651714,10651715,10651716,10651717,10651718,10651719,10651720,10651721,10651722,10540018,10540019,10540020,10540021,10540022,10540023,10540024,10540025,10540026,10540027,10540028,10540029,10540030,10540031,10540032,10540033,10540034,10540035,10540036,10540037,10540038,10540039,10540040,10540041,10540042,10540043,10540044,10540046,10540047,10540048,10540049,10540050,10540051,10540052,10540053,10540054,10540055,10540056,10540057,10540058,10540059,10540060,10540061,10540062,10540063,10540064,10540065,10540066,10540067,10540068,10540069,10540070,10540071,10540072,10540073,10540074,10540075,10422561,10422562,8562694,8562695,8562696,8562697,8562698,8562699,10715084,10715085,10715086,10489492,10489493,10489494,10489495,10489496,10489497,10489498,10489499,10489500,10489501,10489502,10489503,10489504,10489505,10489506,10489507,10489508,10489509,10489510,10489511,10489512,10489513,10489514,10489515,10489516,10489517,10489518,10489519,10489520,10489521,10489522,10489523,10489524,10489525,10489526,10489527,10489528,10489529,10489530,10489531,10489532,10489533,10489534,10489535,10489536,10489537,10489538,10489539,10489540,10489541,10489542,10489543,10489544,10489545,10489546,10489547,10472805,10472807,10472808,10472809,10472810,10472811,10472812,10472813,10472814,10472815,10472816,10472817,10472818,10472819,10472820,10472821,10472822,10472823,10472824,10472825,10472826,10472827,10472828,10472829,10472830,10472831,10472832,10472833,10472834,10472835,10472836,10472837,10472838,10472839,10472840,10472841,10472842,10472843,10472844,10472845,10472846,10472847,10472848,10472849,10472850) 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'