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(10845900,11014974,11014975,11014976,11014977,11014978,11015526,8621910,9215912,11016113,11016114,11016115,11016116,11016117,11016118,8067428,8067429,8067436,11016170,11016171,11016172,11016173,8622377,8622378,11029394,11029395,10872232,10872233,10872234,10872303,8619851,8619852,10872433,11026884,11026885,11013885,11013886,11026886,11026887,11013887,11013888,11013889,11013890,8620155,7075512,11014368,10870042,10870043,10870044,10870045,10870046,10870047,10870048,10870049,10870050,10870051,10870052,10870053,10870054,10870055,10870056,10870057,10870058,10870059,10870060,10870061,10870062,10870063,10870064,10870065,10870066,10870067,11001588,11001589,11011642,11011643,10842938,10842939,8559144,11012109,11012341,11012342,11012343,11012344,11012345,7072661,7072662,7072665,7072668,10103833,10103868,10103926,7073034,7073035,7073036,10867359,10867360,10867361,8618952,8618953,8619008,11012871,11012872,11012873,11012874,11012875,10859644,7073449,11013305,11013306,11013307,11013308,7073628,8560602,7073684,11013449,11013450,11013451,11013452,7073863,11013556,11013557,11013558,11013562,3237409,3237410,10942654,11023781,11023782,10102513,8617243,8617245,8617246,8617247,8617248,8617249,11024246,11024247,11024248,11024249,11024250,11024251,10943192,10943197,8910652,8617617,8617618,8617619,8617620,8617621,3925433,3925434,8908194,8908195,8615058,8556308,11035309,11035310,11035344,11035345,11035346,11035347,11035348,11035387,11035465,10941706,10941707,10941708,11023051,11023052,11048309,11048310,7070735,7070736,7070737,7070738,7070739,11019743,11033565,11020590,7157534,11021493,10852309,10852310,10852311,11018709,10852312,11005735,8541599,8541600,10836860,10927890,7156107,10928254,11006458,7156440,8570013,8570014,10920740,10920741,10920742,10920743,10920744,10920745,10920746,8570206,8570228,10991519,10991520,10991521,10991522,10991523,10991524,10991525,10991526,10991527,10991528,10991529,10991530,10991531,10991532,10991533,10991534,10991535,10991536,10991537,10991538,10991539,10991540,10991541,10991542,10991543,10991544,10991545,10991546,10991547,10991548,10991549,10991550,10991551,10991552,10991553,10991554,10991555,10991556,10991557,10991558,10991559,10991560,10991561,10991562,10991563,10991564,10991565,10991566,10991567,10991568,10991569,10991570,10991571,10991572,10991573,10991574,10991575,10991576,10991577,10991578,10921556,11004740,11004741,11030848,11030849,11030850,10921964,11031188,11031189,7019075,3654736,3654737,3654738,10565350,10565351,10565352,10565353,10565354,10565355,10565356,10565357,10565358,10565359,10565360,10565361,10122077,10122078,10122079,10122080,10122081,10122082,10122083,10122084,10122085,8864586,10122335,7025294,10609348,7058524,10613520,10613521,9204930,8852826,7026770,9911550,10517287,10517288,9185633,9185634,9185635,9185636,9185637,9185638,9185639,9185640,9185641,9185642,9185643,9185644,9185645,9185646,9185647,9185648,9185649,9185650,9185651,9185652,9185653,9185654,9185655,10125949,10515594,10515595,10515596,7023477,10126178,7023637,10118615,7024121,10514368,10514369,9160362,9176449,8918238,8918239,10420150,10420151,10420152,9209261,9209262,9174631,9198998,8854831,8854832,8854833,8854834,10123364,9175410,10123965,9176120,10903576,10903577,10903578,10903579,10903580,10903581,10903582,10903583,10903584,10903585,10903586,10903587,10909019,10170319,10170320,10170321,10170322,10170323,10170324,10170325,10170481,10629030,10909658,10909659,10909660,10629323,10629324,10629325,10629326,10879869,10184193,10176623,10176732,10891384,10891385,10891386,10172405,10626192,10626193,10626194,10626195,10626196,10911964,10911986,10911987,10911988,10911989,10911990,10911991,10912003,10912004,10912005,10912066,10892324,10892325,10652702,10652703,10650036,10654454,10654455,10654456,10539144,10539145,10539146,10529877,10529878,10529879,10529880,10529881,10529882,10529883,10529884,10529885,10529886,10529887,10529888,10529889,10529890,10529891,10529892,10529893,10529894,10529895,10529896,10529897,10529898,10529899,10529900,10529901,10529902,10529903,10529904,10529905,10529906,10529907,10529908,10529909,10529910,10529911,10529912,10529913,10529914,10529915,10529916,10529917,10529918,10529919,10529920,10529921,10529922,10529923,10529924,10529925,10529926,10529927,10529928,10529929,10529930,10529931,10529932,10529933,10529934,10529935,10529936,10529937,10529938,10529939,10529940,10529941,10529942,10529943,10529944,10529945,10529946,10529947,10529948,10529949,10529950,10529951,10529952,10529953,10529954,10529955,10529956,10529957,10529958,10529959,10529960,10529961,10529962,10529963,10534186,10534187,10538407,10520740,10520741,10520742,10423411,10423412,10423457,10505546,10421967,10421968,10421969,10421970,10421971,10421972,10421973,10421974,10421975,10421976,10421977,10421978,10421979,10507969,10481585,10481586,10481587,10481588,10481589,10481590,10481591,10407941,10414076,10496835,10496836,10493072,10493084,10493326,10408856,10408857,10408858,10408859,10408860,10408861) 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'