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(8595281,8595282,8595283,4970761,10859571,8573331,8067940,7201271,7198770,10857130,10857131,7200255,7200256,7200257,7200258,7200259,7200260,7200261,7200262,7200263,7200264,7200265,7200266,7200267,7200268,7200269,7200270,7200271,7200272,7200273,7200274,7200275,7200276,7200277,7200278,7200279,7200280,7200281,7200282,7200283,7200320,10865696,10865697,10865698,10865699,10865700,10865701,10865702,10865703,10865704,10865705,10865706,10865707,10865708,10865709,10865710,10865711,10865712,10865713,10865714,10865715,10865716,10865717,10865718,10865719,10865720,10865721,10865722,10865723,10865724,10865725,10865726,10865727,10865728,10865729,10865730,10865731,10865732,10865733,10865734,10865735,10865736,10865737,10865738,10865739,10865740,10865741,10865742,10865743,10865744,10865745,10865746,10865747,10865748,10865749,10865750,10865751,10865752,10865753,10865754,10865755,10865756,10865757,10865758,10865759,10865760,10865761,10865762,10865763,10865764,10865765,10865766,10865767,10865768,10865769,10865770,10865771,10865772,10865773,3923523,8906742,8906743,8906744,8906745,8906746,8906747,8906748,8906749,8906750,8906751,8906752,8906753,8906754,8906755,8906756,8906757,8906758,8906759,8906760,8906761,8906762,8906763,8906764,8906765,8906766,8906767,8906768,8906769,8906770,8906771,8906772,8906773,8906774,8906775,8906776,8906777,8906778,8906779,8906780,8906781,8906782,10838927,10426205,10426409,10426410,10426411,10426412,10426413,10426440,10426441,10426442,10426443,10623965,7155310,10615332,10615931,10615932,3228944,3228945,10616579,10616580,10616581,10616582,10616583,10616584,10616585,10616586,10616587,10616588,10616589,10616590,10616591,10616592,10616593,10616594,10616595,10616596,10616597,10616598,10616599,10616600,10616601,10616602,10616603,10616604,10616605,10616606,10616607,10616608,10616609,10616610,10616611,10616612,10616613,10616614,10616615,10616616,10616617,10616618,10616619,10616620,10616621,10616622,10616623,10616624,10616625,10616626,10616627,10616628,10616629,10616630,10616631,10616632,10616633,10616634,10616635,10616636,10616637,10616638,10616639,10616640,10616641,10616642,10616643,10616644,10616645,10616646,10616647,10616648,10616649,10616650,10616651,10616652,10616653,10616654,10616655,10616656,10616657,10616658,10616659,10616660,10616661,10616662,10616663,10616664,10616665,10616666,10616667,10616668,10616669,10616670,10616671,10616672,10616673,10616674,10616675,10616676,10616677,10616678,10616679,10616680,10616681,10616682,10616683,10616684,10616685,10616686,10616687,10616688,10616689,10616690,10616691,10616692,10616693,10431692,10616744,10616755,10616761,10616764,10616767,10616768,10616772,8853528,10714193,10714194,10714195,10714196,10714197,10612075,8851393,8851395,8566747,10613034,8852314,10613207,10613488,8852690,8852691,8852692,8852693,8852694,8852695,8852696,10613534,9169668,10117905,9169766,9169767,9169768,9169769,9169770,9169771,9169772,9169773,9169774,9169775,9169776,9169777,9169778,9169779,9169780,9169781,9169782,9169783,9169784,9169785,9169786,9169787,9169788,9169789,9169790,9169791,9169792,9169793,9169794,9169795,9169796,9169797,9169798,6674107,6674255,6674256,6674257,6674258,6674259,6674260,6674261,6674262,6674263,10118552,10118553,10118554,10118555,10118556,10118557,10118558,10118559,10118560,10118561,10118562,10118563,10118564,10118565,10118566,10118567,10118568,2809285,9913047,8850692,8850742,8850786,9913217,9913218,9913219,9913220,9913221,9913222,9913223,9913224,9913225,9913226,9913227,9913228,9913229,9913230,9913231,9913232,9913233,8850954,8851042,10418335,10418336,10418920,10418921,10418922,10418923,10418924,10418925,10418926,10418927,10418928,10418929,10418930,10418931,10418932,10418933,10418934,10418935,10418936,10418937,10418938,10418939,10418940,10418941,10418942,10418943,10418944,10418945,10418946,10418947,10418948,10418949,10418950,10418951,10418952,10418953,10418954,10418955,10418956,10418957,10418958,10418959,10418960,10418961,10418962,10418963,10418964,10418965,10418966,10418967,10418968,10418969,10418970,10418971,10418972,10418973,10418974,10418975,10418976,10418977,10418978,10418979,10418980,10418981,10418982,10418983,10418984,10418985,10418986,10471040,10471041,10471042,10471043,10471044,10471045,10471046,10471047,10471048,10471049,10471050,10471051,10471052,10471053,10471054,10471055,10471056,10471057,10471058,10471059,10471060,10471061,10471062,10471063,10471064,10471065,10471066,10471067,10471068,10471069,10471070,10471071,10471072,10471073,10471074,10471075,10471076,10471077,8550210,8550230,8550231,10469948,976576,9168190,9168191,10888607,10888966,10884436,10889499,10889500,10889501,10889502,10889503,10889504,10889505,10889506,10889507,10889508,10889509,10889510,10889511,10889512,10889513,10889514,10889515,10889516,10889517,10889518,10889519,10889520,10889521,10889522,10889523,10889524,10889525,10889526,10889527,10889528,10889529,10889530,10889531,10889532,10889533,10889534,10889535,10889536,10889537,10889538,10889539,10889540,10889541,10889542,10889543,10889544,10889545,10889546,10889547,10889548,10889549,10889550,10889551,10889552,10889553,10889554,10889555,10889556,10889557,10889558,10889559,10889560,10889561,10889562,10889563,10889564,10889565,10889566,10889567,10889568,10889569,10889570,10889571,10884694,10885074,10627332,10888372,10888373,10888374,10888375,10885543,10885946,10885947,10162208,10162209,10162210,10162211,10162212,10162213,10162214,10162215,10162216,10162217,10887434,10647681,10647682,10647683,10647684,10647685,10647686,10604606,10494380,10494381,10494382,10494383) 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'