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(7076141,10939919,10846420,10846421,10846422,10846423,8622179,8622181,8622371,8622372,8622373,7066720,7066721,8609720,8609721,7067000,7067665,10447618,8620592,8620593,8620594,8620595,8838266,8838267,8838268,8838269,8838270,8838271,10939425,10103176,10103177,7072261,7072262,10985951,10985952,10985953,10985954,10985955,10985956,10843033,10843048,10843049,10999052,10999053,10999054,10999061,10960363,8618623,10104009,8066083,8066084,8066085,10999882,10999883,10843983,10843986,10844164,10844165,10844166,7073434,11000196,11000209,11000211,11000212,11000213,11000214,11000215,11000216,7073555,7073556,11000307,11000319,11000320,10842300,8910741,10998413,10102863,10998418,10998423,10998424,10998428,10998429,10998433,10998434,10998435,10998436,10998437,10998438,10998439,10998440,8835245,8835246,8835247,8835248,8835249,8835250,8835251,10998463,10998464,6000096,6000097,8835319,8835320,10103037,10944362,10839734,10839784,3656298,3656299,3656300,3656301,3656347,3656348,3656349,3656350,3656351,3656352,3656353,3656354,3656355,3656356,3656357,3656358,3656359,10840668,10840669,10840670,10840671,10840672,11009953,11009955,11009956,11009957,11009958,11009959,11009960,11009961,11009962,11009978,11009979,11009980,11009981,11009982,11009983,11009984,11009985,11009986,11009987,11009988,11009989,11009990,11009992,11009993,11009994,11009996,8616220,10942315,11045895,11045896,11045897,10967988,11046555,11046556,11046557,11046558,10838692,8070824,8614537,8614538,8614539,8614540,10966620,10966621,10966622,10966623,10966624,10966625,10966626,10966627,10966628,10966629,10966630,10966631,10966632,10966633,10966634,10966635,10966636,10966637,10966638,10966639,10966640,10966641,10617028,10617029,10617030,10617031,10617113,10617121,10617122,10617127,10617136,8611956,10617157,10617175,8612253,10928170,10928171,10928172,10928173,10928174,10928175,11045442,10617803,8612761,10619975,10619976,10619977,10619978,10620138,8570091,11042900,11042901,11042902,11042903,10951896,10951926,10952135,10952290,10426248,10930863,10952638,10426406,8611239,10922162,10922163,10922164,10922165,10922166,10922167,10922168,10992374,10992375,10992402,10992403,10966530,10966531,10966532,10966533,10966534,10966535,10966536,10966537,10966538,8611690,10966539,10966540,10966541,10966542,10966543,10966544,10966545,10966546,10966547,10966548,10966549,10966550,10966551,10966552,10966553,10966554,10966555,10966556,10966557,10966558,10966559,10966560,10966561,10966562,10966563,10966564,10966565,10966566,10966567,10966568,10966569,10966570,10966571,10966572,10966573,10992573,10992574,10966574,10966575,10992575,10992576,10966576,10966577,10992577,10966578,10966579,10966580,10966581,10966582,10966583,10966584,10966585,10966586,10966587,10966588,10966589,10966590,10966591,10966592,10966593,10966594,10966595,10966596,10966597,10966598,10966599,10966600,10966601,10966602,10966603,10966604,10966605,10966606,10966607,10966608,10966609,10966610,10966611,10966612,10966613,10966614,10966615,10966616,10966617,10966618,10966619,7059777,10614487,10614491,10714486,10614773,10614775,10614777,10614778,10614780,10614783,10614784,10614785,10614786,10614787,10614789,10614790,10614792,10614793,10614794,10614796,10614797,10614799,10614802,10614803,10614805,10614807,10614809,10614814,10614816,10614817,9198217,9198236,9198237,9198238,9198239,9198240,8864780,8864782,8864783,8864784,9211299,9211300,9211301,9211305,9211313,9211317,9211321,9211322,9211324,9211325,9211327,9211328,9211329,9211330,9187421,9187422,9187423,9187424,9187425,10119648,10119649,9171694,9171695,9211811,9212059,9212060,9212061,9212062,9212063,9212064,10609748,9212203,10564130,10564131,10564132,10564133,10564134,10564135,10564136,10564137,10564138,10564139,10564140,10564141,10564142,10564143,10564144,10564145,10564146,10564147,10564148,10564149,10564150,10564151,10564152,10564153,10564154,10564155,10564156,10564157,10564158,10564159,10564160,10564161,10564162,10564163,10564164,10564165,10564166,10564167,10564168,10564169,10564170,10564171,10564172,10564173,10564174,10564175,10564176,10564177,10564178,10564179,10564180,10564181,10564182,10564183,10564184,10564185,10564186,10564187,10564188,10564189,10564190,10564191,10564192,10564193,10564194,10564195,10564196,10564197,10564198,10564199,10564200,10564201,10564202,10564203,10564204,10564205,10564206,10564207,10564208,10564209,10564210,10564211,10564212,10564213,10564214,10564215,10564216,10564217,10564218,10564219,10564220,10564221,10564222,10564223,10564224,10564225,10564226,10564227,10564228,10564229,10564230,10564231,10564232,10564233,10564234,10564235,10564236,10564237,10564238,10564239,10564240,10564241,10564242,10564243,10564244,10564245,10564246,10564247,10564248,10564249,10564250,10564251,10564252,10564253,10564254,10564255,10564256,10564257,10564258,10564259,10564260,10564261,10564262,10564263,10564264,10564265,10564266,10564267,10564268,10564269,10564270,10564271,10564272,10564273,10564274,10564275,10564276,10564277,10564278,10564279,10564280,10564281,10564282,10564283,10564284,10564285,10564286,10564287,10564288,10564289,10564290,10564291,10564292,10564293,10564294,10564295,10564296,10564297,10564298,10564299,10564300,10564301,10564302,10564303,10564304,10564305,10564306,10564307,10564308,10564309,10564310,10564311,10564312,10564313,10564314,10564315,10564316,10564317,10564318,10564319,10564320,10564321,10564322,10564323,10564324,10564325,10564326,10564327,10564328,10564329,10564330,10564331,10564332,10564333,10564334,10564335,10564336,10564337,10564338,10564339,10564340,10564341,10564342,10564343,10564344,10564345,9172532,10564346,10564347,10564348,10564349,10564350,10564351,10564352,10564353,10564354,10564355,10564356,10564357,10564358,10564359,10564360,10564361,10564362,10564363,10564364,10564365,10564366,10564367,10564368,10564369,10564370,10564371,10564372,10564373,10564374,10564375,10564376,10564377,10564378,10564379,10564380,10564381,10564382,10564383,10564384,10564385,10564386,10564387,10564388,10564389,10564390,10564391,10564392,10564393,10564394,10564395,10564396,10564397,10564398,10564399,10564400,10564401,10564402,10564403,10564404,10564405,10564406,10564407,10564408,10564409,10564410,10564411,10564412,10564413,9205118,9205120,9205121,9205122,9205135,9205136,9205137,9205138,9205139,9205140,9205141,10515341,10515342,10515343,10515344,10515345,9209588,9209589,7023425,7023426,7056089,10517753,9186152,10516140,10516141,10516811,10516812,9211273,9211274,9211275,9211279,9211280,9211281,9211282,9211283,9211284,9211285,9211289,9211290,9211291,9211294,9211295,9211296,9211297,10418326,10419378,10419379,10419380,10419381,10419384,10419386,10419387,10419388,10419389,10419390,10419392,10419394,9192516,9192521,9192522,10416447,10416452,10416457,10416458,10416468,10416471,10416472,10416473,10416474,10416475,10416476,10416478,10416479,10416480,10416484,10416485,10416486,10416487,10416488,9192568,9192569,9192587,9192588,10417539,10417540,10417541,10418987,9169210,4971360,4971361,4971362,6666850,9191122,9191133,9191135,9191149,9191158,9191159,9191160,9191162,9191163,9191164,9191165,9191166,9191168,9191176,9191180,9183181,9191182,9183182,9191183,9183183,9191184,9191185,8550395,8916960,9175465,9175466,9175467,9175468,9175469,9175470,9175471,9175472,9175473,9175474,9175475,9175476,9175477,9175478,9175479,9175480,9175481,9175483,9167594,9167595,8550782,6667703,6667704,6667705,6667706,6667707,6667708,6667709,6667710,6667711,6667712,6667713,6667714,6667715,6667716,6667717,6667718,6667719,6667720,8917432,8917433,9176126,9168169,9192173,9192174,9192175,9192176,9192177,9192178,9192179,9192180,9192181,9192182,8917849,8917850,8594469,10632035,10632036,10632037,10632038,10632039,10882763,10882764,10882765,10882766,10163905,10163906,10163907,10163908,10163909,10163910,10163911,10163912,10163913,10163914,10163915,10163916,10163917,10163918,10163919,10163920,10163921,10163922,10173951,10164041,10627680,10630187,10630188,10626151,10580119,10580120,10580121,10580122,10580123,10580124,10580125,10580126,10580127,10589533,10589534,10589535,10589536,10589537,10589538,10589539,10589544,10589545,10589551,10589552,10589553,10589559,10589560,10589570,10589571,10589572,10589573,10589574,10586596,10586597,10586598,10591086,10591087,10591088,10591089,10591090,10591091,10591092,10591093,10527386,10527387,10527388,10527389,10527390,10527391,10527392,10527393,10527394,10527395,10527396,10527397,10527398,10527399,10527400,10521850,10521851,10534277,10534278,10534279,10542441,10522637,10522638,10530932,10530933,10527005,10527007,10420247,10420478,10420479,10498385,10420754,10420755,10420756,10420781,10420782,10420783,10420798,10420799,10420804,10420807,10420808,10420819,10420820,10420821,10420822,10420823,10420832,10420833,10424991,10424992,10424993,10424994,10422016,10486195,10477291,10487537,10487538) 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'