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(8620656,10930279,8574606,8574607,7068675,10846490,10846491,10846497,10846498,8067552,10437570,10437571,10951281,8584129,3227260,3227261,10498108,10498109,10498110,10498111,10498112,10498113,10498114,10498115,10498116,10498117,10498118,10498119,10498120,10498121,10498122,10498123,10498124,10498125,10498126,10498127,10498128,10498129,10498130,10498131,10498132,10498133,10498134,10498135,10498136,10498137,10498138,10498139,10498140,10498141,10498142,10498143,10498144,10498145,10498146,10498147,10498148,10498149,10498150,10498151,10498152,10498153,10498154,10498155,10498156,10498157,10498158,10498159,10498160,10498161,10498162,10498163,10498164,10498165,10498166,10498167,10498168,10498169,10498170,10498171,10498172,10498173,10498174,10498175,10498176,10498177,10498178,10498179,10498180,10498181,10498182,10498183,10498184,10498185,10498186,10498187,10498188,10498189,10498190,10498191,10498192,10498193,10498194,10498195,10498196,10498197,10498198,10498199,10498200,10498201,10498202,10498203,10498204,10498205,10498206,10498207,10498208,10498209,8068493,8068494,8068495,8068496,8068497,8068498,8068499,8068500,8068501,8068502,8068503,8068504,8068505,8068506,8068507,8068508,8068509,8068510,8068511,8068512,8068513,8068514,8068515,8068516,8068517,8068518,8068519,8068520,8068521,8068522,8068523,8068524,8068525,8068526,8068527,8068528,8068529,8068530,8068531,8068532,8068533,8068534,8068535,8068536,8068537,8068538,8068539,8068540,8068541,8068542,8068543,8068544,8068545,8068546,8068547,8068548,8068549,8068550,8068551,8068552,8068553,8068554,8068555,8068556,8068557,8068558,8068559,8068560,8068561,8068562,8068563,8068564,8068565,8068566,8068567,8068568,8068569,8068570,8068571,8068572,8068573,10845342,8068574,8068575,8068576,8068577,8068578,8068579,8068580,8068581,8068582,8068583,8068584,8068585,8068586,8068587,8068588,8068589,8068590,8068591,8068592,8068593,8068594,8068595,8068596,10845372,10845373,10845374,10845375,8838281,8835500,8835501,8835502,8835503,8835504,8835505,8835506,8835507,8835508,8835509,8835510,8835511,8835856,7201904,3899245,8618675,10104054,10104064,10932611,7202600,10932854,7202664,8066498,8066499,8066500,8066501,8066502,8066503,8066504,8066505,8066506,8066507,8066508,8066509,8066510,8836931,8066511,8066512,8066513,8066514,8066515,8066516,8066517,8066518,8066519,8066520,8066521,8066522,8066523,8066524,8066525,8066526,8066527,8066528,8066529,8066530,8066531,8066532,8066533,8066534,8066535,8066536,8066537,8066538,8066539,8066540,8066541,8066542,8066543,8066544,8066545,8066546,8066547,8066548,8066549,8066550,8066551,8066552,8066553,8066554,8066555,8066556,10932936,10932937,11036682,8616957,11036907,11036908,11036909,11036910,11036911,11036912,11036913,11036914,10102409,10102410,10102411,10102412,11037091,11037092,11037093,11037094,11037130,11037131,11037132,8908013,7069014,7069015,10940883,8564811,8564812,8564813,11010293,10841427,10841428,8860657,11019799,8613329,8578011,10966722,8905221,8542003,8542013,8542267,8542268,8569884,8569885,8569886,8569887,8569888,10620565,10952296,10952304,10952310,10930757,10930758,10930759,10930945,8540546,10621375,10621376,10621377,10621378,10621379,10621380,10621381,10621382,10621383,10621384,10621385,10621386,10621387,10621388,10621389,10621390,10621391,10621392,10621393,10621394,10621395,10621396,10621397,10621398,10621399,10621400,10621401,10621402,10621403,10621404,10621405,10621406,10621407,10621408,10621409,10621410,10621411,10621412,10621413,10621414,10621415,10621416,10621417,10621418,10621419,10621420,10979074,10979075,10979076,10979077,10979078,10979079,10979080,10979081,10979082,10979083,10979084,10979085,10979086,10979087,10979088,10979089,10979090,10979091,10979092,10979093,10979094,10979095,10979096,10979097,10979098,10979099,10979100,10979101,10979102,10979103,10979104,10979105,10979106,10979107,10979108,10979109,10979110,10979111,10979112,10979113,10979114,10979115,10979116,10979117,10979118,10979119,10979120,10979121,10979122,10979123,10979124,10979125,10979126,10979127,10979128,10979129,10979130,10979131,10979132,10979133,10426864,10426865,10426866,10426867,10426868,10426869,10426870,10426871,10426872,10426873,10426874,10426875,10426876,10426877,10426878,10426879,10426880,10426881,8904710,8541247,10922441,10922446,10922447,10922448,10922449,9205303,9205304,9205305,9205329,9205330,9205331,9221315,9205347,9221323,9205359,9205361,9205362,9205363,9205372,9205376,9205377,9221375,9221377,9221383,9221384,9181488,9181489,9181490,9181491,9181492,9181493,9181494,8542705,7057808,10120285,10120459,10120460,10120461,9164575,9188597,10564495,10564592,10564636,10564656,10564678,10564679,9196919,10564776,10564777,10564778,8863521,8863522,8863523,8863524,8863525,8863526,8863527,8863528,8863529,8863530,8863531,8863532,8863533,8863534,8863535,8863536,8863537,10564828,8863538,8863539,8863540,8863541,8863542,8863543,8863544,8863545,8863546,8863547,8863548,8863549,8863550,8863551,8863552,8863553,8863554,8863555,8863556,8863557,8863558,8863559,8863560,8863561,8863562,8863563,8863564,8863565,8863566,8863567,8863568,8863569,8863570,8863571,8863572,8863573,8863574,8863575,8863576,8863577,8863578,8863579,8863580,8863581,8863582,8863583,8863584,8863585,8863586,8863587,6677349,10565046,9205248,10513399,9177741,9177742,9177743,9177744,4974667,4974726,4974727,9169914,9210927,7057125,9179119,9179120,9179121,9179122,9179123,9179124,9179125,9179126,9179127,9179128,9179129,9179130,9179131,9179132,9179133,9179134,9179135,9179136,9179137,9179138,9179139,9179140,9179141,9179142,9179143,9179144,9179145,9179146,9179147,9179148,9179149,9179150,9179151,9179152,9179153,9179154,9179155,9179156,9179157,9179158,9179159,9179160,9179161,9179162,9179163,9179164,9179165,9179166,9179167,9179168,9179169,9179170,9179171,9179172,9179173,9179174,9179175,9179176,9179177,9179178,9179179,9179180,9179181,9179182,9179183,9179184,9179185,9179186,9179187,9179188,6672815,6672816,6672830,6672831,6672832,6672833,6672834,6672862,6672863,6672870,6672871,6672872,6672873,6672874,6672875,6672876,6672884,6672885,6672886,6672887,6672888,6672892,4973575,9168876,9168954,7055180,7055184,7055188,10117479,9198403,9198418,9198501,9198553,9198883,4972124,8563206,8550945,8550946,8550947,8550948,9191980,9191981,9168077,10883627,8593842,8593843,8593844,8593845,8593846,8593847,8593848,8593849,8593850,8593851,8593852,8593853,8593854,8593855,8593856,8593857,8593858,8593859,8593860,8593861,8593862,8593863,8593864,8593865,8593866,8593867,8593868,8593869,8593870,8593871,8593872,8593873,8593874,8593875,8593876,8593877,8593878,8593879,8593880,8593881,8593882,8593883,8593884,8593885,8593886,8593887,8593888,8593889,8593890,8593891,8593892,8593893,8593894,8593895,8593896,8593897,8593898,8593899,8593900,8593901,8593902,8593903,8593904,8593905,8593906,8593907,8069036,8069037,10175804,10890175,10627576,10184141,10184142,10184143,10184161,10184245,10184246,10184247,10184282,10184283,10184284,10184285,10184306,10184307,10184308,10184309,10184310,10184320,10184321,10184322,10184323,10184324,10184325,10184326,10184337,10184338,10184339,10184340,10184341,10184342,10184343,10184344,10184345,10184346,10184359,10184360,10184362,10176512,10176513,10630257,10630281,10891108,10949379,10949380,10949381,10949382,10949383,10949384,10949385,10949386,10949387,10949388,10949389,10949390,10949391,10949392,10949393,10949394,10949395,10949396,10949397,10949398,10949399,10949400,10949401,10949402,10949403,10949404,10949405,10949406,10949407,10949408,10949409,10949410,10949411,10949412,10626710,10950095,10950096,10950097,10950098,10580351,10580352,10580353,10580354,10580355,10580356,10580357,10580358,10580359,10580360,10580522,10580523,10649679,10649680,10649681,10649682,10649683,10649684,10649685,10523453,10523454,10523455,10523456,10523457,10523458,10523459,10523460,10539801,10423750,10489947,10481536,10481537,10481538,10481539,10481540,10481541,10481542,10481543,10481544,10481545,10481546,10481547,10473798,10473799,10473800,10473801,10473802,10473803,10473804,10473805,10473806,10473807,10473808,10473809,10473810,10473811,10473812,10473813,10473814,10473815,10473816,10473817,10473818,10473819,10473820,10473821,10473822,10473823,10473824,10473825,10473826,10473827,10473828,10473829,10479953,10479954,10479955,10479956,10479957,10479958,10479959,10479960,10479961,10479962,10479963,10479964,10479965,10479966,10479967,10479968,10479969,10479970,10479971,10479972,10479973,10479974,10479975,10479976,10479977,10479978,10479979,10479980,10479981,10479982,10479983,10479984,10479985,10479986,10479987,10479988) 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'