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(10943628,4970674,4970689,4970690,4970691,8569558,7065863,7065968,7065972,7065981,7065995,7065997,7065998,7066000,7066021,7066050,7066062,7066142,7066163,7066249,7066267,7066276,7074673,7074674,7074679,7074698,7074777,7074855,7074913,8067910,8067921,8067930,7074978,7074983,7074997,7075010,7075018,7072286,7064547,7064548,8859502,8860263,8860265,8860385,8860417,8860418,8860419,8860420,10623065,8070779,10927509,10927510,10927511,10927512,10622405,10622408,10622429,10622453,10620121,10620301,10620487,10620491,10614048,10614050,10614084,10614117,10614152,10614153,10614159,10614167,10614177,10614210,10614228,10614234,10614236,10614237,10614240,10614241,10614400,10614411,10614421,10614427,10614435,10614466,10614487,10614488,10614494,10614512,10614513,10614516,10614524,10614532,10559710,10559712,10614588,10614589,10614595,10559766,10614618,10614620,10614634,10614669,10614724,10614749,10614864,10611973,10611989,10611995,10611996,10611997,10612018,10612028,10612029,10612042,10612080,10612084,10612085,10612086,10612089,10612093,10612138,10612139,10612181,10612182,10612183,10612184,10612189,10612202,10612226,10612259,10612262,10612265,10612267,10612270,10612294,10612333,10612344,10612345,10612380,10612381,10612383,10612433,10612434,10612435,10612436,10612437,10612438,10612439,10612440,10612441,10612442,10612443,10612444,10612445,10612446,10612447,10612448,10612449,10612450,10612451,10612452,10612453,10612454,10612455,10612456,10612457,10612458,10612459,10612460,10612461,10612462,10612463,10612464,10612465,10612471,10612490,10612491,10612492,10612493,10612506,10612519,10612520,10612521,10612522,10612524,10612525,10612542,10612544,10612545,10612546,10612580,10612599,10612602,10612605,10612606,10612607,10612608,10612609,10612610,10612613,10612615,10612616,10612617,10612627,10612632,10612638,10612660,10612691,10612757,10612769,10612781,10612810,10612821,10557973,10612823,10612825,10612835,10612841,10612843,10612845,10612848,10612850,10612852,10612854,10612856,10612858,10612859,10612885,10612886,10612887,10612888,10612889,10612890,10612891,10612892,10612893,10612894,10612895,10612896,10612897,10612898,10612899,10612900,10612955,10612956,10612957,10612958,10613019,10613025,10613078,10613085,10613087,10613088,10613089,10613091,10613119,10613139,10613157,10613166,10613168,10613187,10613192,10613318,10613342,10613350,10613440,10613470,10613471,10613490,10613540,10613541,10613544,10613562,10613578,10613584,10613599,10613600,10613601,10613606,10613643,10613646,10613693,10613741,10613750,10613752,10613802,10613899,10419228,10419229,10419232,10419233,10419234,10416237,10416253,10419253,10419255,10416258,10416261,10419261,10419266,10416275,10416281,10416282,10417283,10416283,10417287,10419288,10417290,10417291,10416301,10417311,10416322,10416328,10419338,10417347,10416347,10416356,10416357,10416358,10417358,10419358,10416359,10417359,10416360,10419360,10416361,10416362,10419362,10416363,10419365,10419366,10417369,10419370,10417370,10419371,10419372,10417375,10416376,10417376,10419377,10416379,10416382,10419382,10419383,10416384,10419385,10416385,10416386,10416387,10417391,10417392,10417393,10419410,10419412,10419414,10419416,10419417,10419418,10419420,10419427,10419429,10419431,10419434,10419435,10419437,10419438,10419439,10416444,10416445,10416446,10416447,10417448,10416453,10416454,10419458,10416458,10419459,10416459,10416463,10419465,10416466,10416468,10416469,10416470,10416481,10416487,10419497,10416498,10416499,10416501,10416503,10416505,10416509,10419511,10416513,10419514,10416517,10416518,10416522,10416523,10419524,10416524,10419528,10419529,10417531,10416533,10417537,10416540,10416541,10416542,10416543,10416545,10416547,10416548,10417549,10419556,10419557,10419564,10417565,10419565,10419566,10419567,10416568,10416569,10416570,10419570,10416571,10416572,10416573,10416574,10416576,10416577,10416578,10416579,10416580,10417589,10417599,10417600,10419604,10419605,10419608,10417609,10417610,10416610,10419611,10416611,10419612,10416612,10416613,10419615,10419616,10416616,10416617,10416618,10416619,10416620,10417621,10416621,10416622,10416623,10419624,10416624,10419625,10416625,10416626,10419630,10419635,10419638,10419639,10416639,10416640,10416641,10417643,10419643,10419644,10417645,10417646,10419648,10417649,10419649,10416649,10417650,10416650,10416651,10419652,10416652,10416653,10419654,10416654,10416655,10419656,10416656,10419657,10417658,10416658,10416659,10419660,10416660,10416661,10416662,10417663,10419663,10419664,10417666,10416673,10416674,10416677,10416695,10417700,10417701,10416702,10416703,10417715,10417724,10417725,10417743,10417757,10416757,10416758,10416759,10417763,10417768,10419768,10419770,10416770,10416771,10419771,10419773,10416773,10419775,10419777,10417778,10419778,10416779,10419780,10416780,10416782,10417784,10416785,10416786,10416787,10416788,10417788,10416789,10417792,10416798,10419801,10419804,10419811,10416811,10416812,10416813,10416827,10416828,10416829,10416830,10419856,10419857,10419858,10419869,10419870,10419871,10417946,10417947,10417948,10417949,10416949,10417950,10416950,10416951,10417951,10416952,10417953,10416953,10417954,10416954,10417955,10416955,10416956,10417956,10417957,10416957,10417958,10416958,10417959,10417960,10417961,10417962,10417963,10417964,10417965,10417966,10417967,10417968,10417969,10417970,10417971,10417972,10417973,10417974,10417975,10417976,10417978,10417979,10416979,10417980,10416980,10417981,10416981,10417982,10416982,10417983,10417984,10417985,10417986,10417987,10417988,10417989,10417990,10417991,10417992,10417993,10417994,10417995,10417996,10417997,10417998,10417999,10418000,10418001,10418002,10418003,10418004,10418005,10418006,10418007,10418008,10418009,10418010,10418011,10418012,10417012,10418013,10417013,10418014,10418015,10418016,10418017,10418018,10417018,10418019,10418020,10417020,10418021,10418022,10417022,10418023,10418024,10417024,10418025,10417025,10418026,10417026,10418027,10417027,10418028,10417028,10418029,10417029,10418030,10417030,10418031,10417031,10418032,10417032,10418033,10417033,10418034,10417034,10418035,10418036,10418037,10418038,10418040,10417041,10417042,10417043,10417044,10418045,10417046,10418047,10417047,10417048,10417049,10417053,10417054,10417055,10417056,10417057,10417058,10417059,10418060,10417060,10417061,10417062,10417063,10417064,10417065,10417066,10417067,10418068,10417068,10417069,10417070,10417071,10417072,10417073,10417074,10417075,10418076,10417076,10418077,10417077,10418078,10417078,10418079,10417079,10417080,10417081,10417082,10417083,10417084,10417085,10418086,10417086,10417087,10417088,10417089,10417090,10417091,10417092,10417093,10417094,10417095,10417096,10417097,10417098,10417099,10417100,10417101,10417102,10417103,10417104,10417105,10417106,10417107,10417108,10417109,10417110,10417111,10417112,10417113,10417114,10417115,10417116,10417117,10418118,10417118,10418119,10417119,10417120,10417121,10417122,10417123,10417124,10417125,10417126,10417127,10417128,10417129,10417130,10417131,10417132,10417133,10417134,10417135,10417136,10417137,10417138,10417139,10417140,10418141,10417141,10418142,10417142,10418143,10417143,10418144,10417144,10418145,10417145,10418146,10417146,10417147,10417148,10417149,10417150,10417151,10417152,10417153,10417154,10418155,10417155,10418156,10417156,10418157,10417157,10418158,10417158,10418159,10417159,10418160,10417160,10418161,10418162,10471109,10471110,10471112,10471113,10471115,10471120,10471128,10467498,10467504,10467508,10467512,10467531,10467532,10467536,10467537,10467539,10467613,10467814,10469910,10469931,10469933,10469934,10469935,10469938,10469939,10469940,10469941,10469942,10463995,10463996,10470094,10470112,10470113,10470155,10470168,10470175,10464213,10470218,10464231,10464235,10470236,10464238,10470244,10470262,10470267,10470272,10470278,10470284,10470286,10470287,10470288,10470305,10470307,10470312,10470317,10470318,10470320,10470321,10470324,10470328,10470329,10470333,10470334,10470336,10470337,10470339,10470341,10470342,10464343,10470344,10470345,10470346,10470347,10470348,10470349,10470350,10470351,10470352,10470353,10464354,10470354,10470355,10470356,10470357,10470358,10470359,10470360,10470361,10470362,10470363,10470364,10470365,10470366,10470367,10470368,10470369,10470371,10470372,10470374,10470377,10464378,10470380,10470381,10470382,10470384,10470385,10470386,10470388,10470390,10470391,10470392,10470394,10470395,10470396,10470397,10470399,10470401,10470402,10470405,10470406,10470407,10470409,10470411,10470413,10470415,10470417,10470418,10470420,10470421,10470423,10470425,10470427,10470428,10470430,10470432,10470434,10470436,10470438,10470440,10470442,10470443,10470445,10470453,10470454,10470455,10470456,10470457,10470477,10470478,10470489,10470499,10470500,10470510,10470511,10470512,10470513,10470553,10470566,10470568,10470577,10470578,10470588,10470592,10470597,10470600,10470601,10470616,10470617,10470631,10470643,10470647,10470648,10470669,10470670,10470705) 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'