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(10930250,10448289,8621756,8575603,8575604,8575605,8575606,8575841,8584182,8584183,11039638,8561036,11040099,11040100,11040101,11040102,11040103,11040104,11040105,11040106,11040107,11040108,11040109,11040110,11040111,11040112,11040113,11040114,11040115,11040116,11040117,11040118,11040119,11040120,11040121,11040122,11040123,11040124,11040125,11040126,11040127,11040128,11040129,11040130,11040131,11040132,11040133,11040134,11040135,11040136,11040137,11040138,11040139,11040140,11040141,11040142,11040143,11040144,10939175,10939176,8838386,6000254,11037727,11037728,11037729,11037730,11037731,11037732,11037733,8627786,8627788,11037854,11037855,11037884,11037885,8618063,8911361,8911362,8911363,8911364,11012041,8911458,8911467,8911468,8559427,7072505,10999350,10999351,10999352,10999353,10999354,10999355,10999356,10999357,10999358,10999359,10999360,10999361,10999362,10999363,8628623,11013329,11013330,11013331,11013332,11013333,11013334,11013335,8560604,11013353,11013354,8619637,8560758,7073929,7073930,3237421,7071075,10942718,10958949,3927693,8626949,11049290,4430372,7071776,7071777,7071778,4430447,4430464,4430470,11008676,8615300,3925971,3925972,3656150,3925973,3925974,3925988,7198908,11022509,11022510,11022511,11022512,11022513,11022514,11022515,11022516,11022517,11022518,11022519,11022520,11022521,11022522,11022523,11022524,11022525,11022526,11022527,11022528,11022529,11022530,11022531,11022532,11022533,11022534,11022535,11022536,11022537,11022538,11022539,11022540,11022541,11022542,11022543,11022544,11022545,11022546,11022547,11022548,11022549,11022550,11022551,11022552,11022553,11022554,11022555,11022556,8615736,11022599,11022600,11022601,11022602,11022603,11022604,10997022,10997023,10997024,10997025,10997026,8909548,8909549,8909554,8909555,8909556,8909557,8909558,8909559,8909560,8909561,8909562,8909563,10997316,10997317,3927070,10923484,10923485,10923486,10923487,10923488,10923489,10923514,10923521,10923522,10923523,10923524,10923525,10923526,10923547,10923742,10923743,10923744,10923745,10923746,10923747,10923748,10923749,10923750,10923751,10923752,10919590,10919591,10919592,10919593,10919594,10919595,10919596,10919597,10919598,10919599,10919600,10919601,10919602,10994753,10925249,10925250,10925251,10925252,10925253,10925254,10925255,10925256,10925257,10925258,10925259,10925260,10917489,10917490,10917491,10917492,10917493,10917494,10917495,10917496,10917497,8578159,8578196,10922669,10922670,10922671,10922672,10922673,10837040,8634966,8634967,8634968,8634969,8634970,8634971,8634972,8634973,8634974,8634975,8634976,8634977,8634978,8634979,8634980,8634981,8634982,8634983,8634984,8634985,8634986,8634987,8634988,8634989,8634990,8634991,8634992,8634993,8634994,8634995,8635007,8635008,8635009,10927918,11019443,11019444,11019445,11019446,11019447,11019448,11019449,11019450,11019451,11019453,11019454,11019456,11019457,11019458,11019459,11019460,11019461,10918340,10918341,11019489,10918342,10918343,10918344,10918345,10918346,10923410,10923411,10923412,10923413,10923414,10923415,10923416,10923417,10923418,10923419,10923420,10923421,10923422,10923423,10923424,10923454,10923455,10923456,10925489,8622796,11042666,10926070,8576863,8576864,8576865,8576866,11004479,11004480,10927057,8541146,11005551,11005552,11005553,11005554,11005555,11005556,11005557,11005558,11005559,11005560,11005561,11005568,11005569,10927430,11005583,9189473,8864231,9173778,10614573,9190091,9190092,9190093,9174198,8854108,8854109,8854110,8854112,8854113,8854114,8854115,8854116,8854117,8854118,8854119,8854120,8854121,7057631,8542684,9187798,9187799,9187800,9187801,9187802,9187803,9187804,9187805,10612623,8566700,8852090,8852093,7058638,7058646,7058647,9172740,9189046,9169978,9186057,9202084,9912907,9912909,8552495,10119484,9200376,6680684,6680685,10116798,10116799,10116800,10116801,9200672,10428390,10428404,6678505,6678506,6678507,6678508,6678509,9206305,9916657,9916658,9916659,9916660,9916661,9916662,9916663,8569250,8855147,8855148,6680018,6680019,6680020,9199828,9199829,9199830,10124067,10124068,9199915,9175962,9200233,9200280,10888537,10179672,10179673,10179674,10179675,10179676,10179677,10179679,10179680,10179681,10913696,10913697,10913698,10913699,10913700,10913701,10913702,10913703,10913704,10913705,10913706,10913707,10913708,10913709,10179933,10179935,10175048,10175049,10175050,10904463,10904464,10904465,10904466,10904467,10904468,10904469,10904470,10904471,10904472,10904473,10904474,10914794,10914795,10914796,10914797,10914798,10914799,10914800,10914801,10914802,10914803,10629574,10910112,10880202,10186261,10186384,10186385,10186386,10912770,10913269,10627912,10627913,10627915,10627916,10161869,10161870,10161871,10161872,10161873,10161874,10161875,10906358,10906359,10906360,10177417,10177418,10177419,10630958,10891737,10631537,10887112,10646191,10646192,10646193,10653519,10653520,10607494,10607495,10607496,10607497,10607498,10521566,10423564,8562380) 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'