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,8067910,8067921,8067930,10939401,10939403,10939407,10939426,10939442,8065840,8065843,8064692,10623065,10622405,10622408,10622429,10622453,10620121,10620301,10620487,10620491,10614048,10614050,10611053,10611054,10611055,10614084,10614117,10611147,10611150,10614152,10614153,10614159,10614167,10614177,10611187,10611188,10611191,10614210,10611226,10614228,10614234,10614236,10611236,10614237,10614240,10614241,10611246,10611249,10611297,10611298,10611334,10611370,10611399,10614400,10614411,10611415,10611417,10614421,10614427,10614435,10611450,10611451,10611462,10611464,10611465,10614466,10611466,10611469,10611470,10611471,10611472,10611475,10611483,10611485,10614487,10611488,10614488,10611489,10611490,10614494,10611494,10611496,10611497,10611498,10611506,10611508,10611509,10611510,10614512,10614513,10614516,10611519,10611521,10614524,10614532,10611563,10611568,10611576,10614588,10614589,10614595,10614618,10614620,10614634,10611666,10614669,10611670,10611671,10611673,10611675,10611677,10611678,10611694,10614724,10611738,10611739,10611740,10611741,10614749,10611754,10611755,10611761,10611763,10611785,10611856,10614864,10611871,10611893,10611894,10611895,10611896,10611897,10611943,10611952,10611973,10611989,10611995,10611996,10611997,10612018,10612028,10612029,10609036,10612042,10612080,10612084,10612085,10612086,10612089,10609093,10612093,10612138,10612139,10609150,10609154,10612181,10612182,10612183,10612184,10612189,10612202,10612226,10609230,10609246,10609259,10612259,10612262,10609265,10612265,10612267,10612270,10609276,10609285,10609287,10612294,10609298,10609329,10612333,10612344,10612345,10609362,10609363,10609367,10612380,10612381,10612383,10609387,10609397,10609398,10609411,10609414,10609420,10612433,10612434,10612435,10612436,10612437,10612438,10612439,10612440,10612441,10612442,10612443,10612444,10612445,10612446,10612447,10609448,10612448,10612449,10612450,10609451,10612451,10609452,10612452,10612453,10612454,10612455,10612456,10612457,10612458,10612459,10609460,10612460,10609461,10612461,10612462,10612463,10612464,10612465,10612471,10612490,10612491,10612492,10612493,10609504,10609505,10612506,10609506,10609507,10609508,10609509,10612519,10612520,10612521,10612522,10612524,10612525,10609527,10609535,10609537,10612542,10609543,10612544,10609544,10612545,10609545,10612546,10609548,10609549,10609550,10609551,10609562,10609575,10609576,10609577,10612580,10609590,10612599,10612602,10612605,10612606,10609607,10612607,10612608,10612609,10612610,10612613,10612615,10612616,10612617,10609617,10609624,10609625,10609626,10609627,10612627,10609630,10609631,10609632,10612632,10609633,10609635,10609637,10612638,10609640,10609654,10609657,10612660,10609666,10609668,10609669,10609675,10609676,10612691,10609707,10609708,10609715,10609716,10612757,10612769,10609772,10612781,10612810,10609817,10612821,10612823,10612825,10609834,10612835,10609835,10612841,10612843,10612845,10612848,10612850,10612852,10612854,10612856,10612858,10612859,10612885,10612886,10612887,10612888,10612889,10612890,10612891,10612892,10612893,10612894,10612895,10612896,10612897,10609898,10612898,10609899,10612899,10612900,10609942,10612955,10612956,10612957,10612958,10609976,10609990,10610006,10613019,10610025,10613025,10610041,10610044,10610053,10610054,10610068,10613078,10613085,10613087,10613088,10613089,10613091,10610106,10613119,10613139,10613157,10613166,10613168,10613187,10613192,10610233,10610260,10610271,10610306,10610307,10613318,10613342,10613350,10610351,10610366,10610367,10610423,10613440,10613470,10613471,10610477,10613490,10610493,10613540,10613541,10613544,10613562,10613578,10613584,10613599,10613600,10613601,10613606,10613643,10613646,10610668,10610675,10613693,10610700,10610701,10610705,10610708,10613741,10613750,10613752,10610773,10610784,10613802,10610812,10610822,10610825,10610826,10610829,10610834,10610835,10610846,10610850,10610851,10610862,10610868,10610870,10613899,10610906,10610915,10610926,10610927,10610928,10610931,10610958,10415224,10419228,10419229,10419232,10419233,10419234,10416237,10416253,10419253,10419255,10416258,10416261,10419261,10419266,10416275,10416281,10416282,10416283,10419288,10416301,10415313,10415314,10415315,10415316,10415321,10416322,10415327,10415328,10416328,10419338,10415344,10416347,10416356,10416357,10416358,10419358,10416359,10416360,10419360,10416361,10416362,10419362,10416363,10419365,10419366,10419370,10415370,10419371,10419372,10416376,10419377,10416379,10416382,10419382,10415383,10419383,10416384,10416385,10419385,10416386,10416387,10415395,10415406,10419410,10419412,10419414,10419416,10419417,10419418,10419420,10419427,10415427,10419429,10419431,10419434,10419435,10419437,10419438,10419439,10416444,10416445,10416446,10416447,10415451,10415452,10415453,10416453,10416454,10415455,10415456,10415457,10415458,10419458,10416458,10415459,10416459,10419459,10416463,10419465,10416466,10416468,10416469,10416470,10416481,10415482,10415484,10415485,10416487,10419497,10416498,10416499,10416501,10416503,10416505,10416509,10419511,10416513,10419514,10416517,10416518,10416522,10416523,10419524,10416524,10415524,10419528,10419529,10416533,10416540,10416541,10416542,10415543,10416543,10416545,10415546,10415547,10416547,10415548,10416548,10415552,10415553,10419556,10415557,10419557,10415563,10419564,10419565,10415566,10419566,10419567,10416568,10415569,10416569,10416570,10419570,10416571,10416572,10415573,10416573,10416574,10416576,10416577,10416578,10416579,10415580,10416580,10415583,10415584,10415585,10415586,10415602,10415603,10419604,10419605,10419608,10415609,10416610,10416611,10419611,10419612,10416612,10416613,10419615,10416616,10419616,10415616,10416617,10416618,10416619,10416620,10416621,10416622,10416623,10416624,10419624,10416625,10419625,10416626,10419630,10415634,10419635,10419638,10416639,10419639,10416640,10416641,10419643,10415643,10419644,10415644,10415645,10419648,10415648,10416649,10419649,10415649,10416650,10415650,10416651,10415651,10416652,10419652,10416653,10416654,10419654,10415654,10416655,10416656,10419656,10419657,10416658,10415658,10416659,10416660,10419660,10415660,10416661,10415661,10416662,10419663,10419664,10416673,10416674,10416677,10415682,10415693,10415694,10416695,10415701,10416702,10416703,10415704,10415706,10415708,10415716,10415717,10415718,10415719,10415722,10415724,10415725,10415743,10415747,10415753,10416757,10415757,10416758,10416759,10419768,10416770,10419770,10416771,10419771,10419773,10416773,10419775,10419777,10419778,10416779,10416780,10419780,10416782,10416785,10416786,10416787,10416788,10416789,10415790,10416798,10419801,10419804,10416811,10419811,10416812,10416813,10415822,10416827,10416828,10416829,10416830,10419856,10419857,10419858,10419869,10419870,10419871,10415877,10415886,10415937,10415938,10416949,10416950,10416951,10416952,10416953,10416954,10416955,10416956,10416957,10416958,10416979,10416980,10416981,10416982,10417012,10417013,10417018,10417020,10417022,10417024,10417025,10417026,10417027,10417028,10416028,10417029,10417030,10416030,10417031,10417032,10416032,10417033,10417034,10416034,10417041,10417042,10417043,10416043,10417044,10417046,10417047,10417048,10417049,10417053,10417054,10417055,10417056,10416056,10417057,10417058,10417059,10417060,10417061,10417062,10417063,10417064,10417065,10417066,10417067,10417068,10417069,10417070,10417071,10417072,10417073,10417074,10417075,10417076,10416076,10417077,10416079,10416113,10416115,10416118,10416119,10416182,10416183,10416185,10416186,10416187,10416189,10416190,10416191,10416192,10416193,10471109,10471110,10471112,10471113,10471115,10471120,10471128,10469910,10469931,10469933,10469934,10469935,10469938,10469939,10469940,10469941,10469942,10470094,10470112,10470113,10470155,10470168,10470175,10470218,10470236,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,10470344,10470345,10470346,10470347,10470348,10470349,10470350,10470351,10470352,10470353,10470354,10470355,10470356,10470357,10470358,10470359,10470360,10470361,10470362,10470363,10470364,10470365,10470366,10470367,10470368,10470369,10470371,10470372,10470374,10470377,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,10462752,10462753) 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'