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(4970689,4970690,4970691,10989240,10989241,7066062,7066142,7066267,7066276,7074679,7074978,7074983,8067906,8067907,8067908,8067910,8067917,10939403,10939405,10960336,11049794,10959115,10959116,8064692,10959614,11048305,11048307,11048427,10618179,10618268,10618270,10618275,10618276,10618278,10618281,10618297,10618316,10618318,10619177,10619862,10616996,10927509,10927510,10927511,10927512,10617035,10617061,10617062,10617079,10617080,10617081,10617086,10617087,10617088,10617089,10617090,10617091,10617116,10617117,10617143,10617163,10617166,10617177,10617252,10617253,10617254,10617255,10617256,10617257,10617258,10617259,10617260,10617261,10617262,10617296,10617297,10617303,10617308,10617309,10617310,10617311,10617312,10617313,10617314,10617324,10953985,10953987,10953988,10953990,10953994,10954017,10954018,10954022,10954023,10954024,10622429,10954097,10954099,10954195,10954199,10954200,10954201,10614985,10614999,10615000,10615086,10615165,10615169,10615195,10615196,10615197,10615198,10615199,10615200,10615201,10615202,10615219,10615220,10615260,10615269,10615272,10615273,10615274,10620301,10615308,10615309,10615315,10615323,10615324,10615343,10615345,10615389,10620491,10615565,10615568,10615569,10615590,10615630,10615769,10615818,10615867,10615868,10615874,10615875,10615876,10615877,10615878,10615920,10615973,10616048,10616049,10616073,10616103,10616105,10616208,10616212,10616213,10616214,10616224,10616232,10616236,10616237,10616238,10616239,10616255,10616256,10616259,10616260,10616261,10616263,10616264,10616266,10616270,10616271,10616277,10616279,10616282,10616283,10616286,10616288,10616291,10616292,10616294,10616296,10616305,10616306,10616308,10616313,10616314,10616315,10616316,10616318,10616319,10616320,10616326,10616333,10616336,10616339,10616340,10616349,10616354,10616368,10616376,10616380,10616382,10616383,10616396,10616413,10616416,10616425,10616433,10616437,10616438,10616439,10616447,10616448,10616452,10616576,10616608,10992335,10992336,10616682,10616683,10616684,10616767,10616810,10616811,10616816,10616823,10616833,10616849,10616850,10616851,10616853,10616854,10966526,10611053,10611054,10614091,10611143,10611144,10611147,10614153,10614159,10614167,10614177,10611187,10611188,10611191,10611226,10614228,10611236,10611249,10614282,10611297,10611298,10611353,10611370,10614400,10614411,10611415,10611417,10614435,10614436,10611439,10611450,10611462,10611464,10614466,10611466,10611469,10611470,10611471,10611472,10614473,10614474,10611475,10611483,10611485,10614486,10611488,10611489,10611490,10611494,10611496,10611497,10611498,10611506,10611508,10611509,10611510,10611519,10611521,10611531,10614542,10559712,10611562,10611563,10611565,10611576,10611583,10614588,10614589,10611591,10614595,10614617,10614618,10614620,10611626,10611666,10614669,10611670,10611675,10611677,10611678,9166051,10614724,10611856,10614861,6666257,6666258,10611960,7057465,10611972,10611973,10611989,10612002,10612018,10612028,10612042,10612084,10612085,10609150,10612191,10612192,10612201,10612226,10609259,10612262,10609265,10612267,10612270,10609285,10609298,10612333,10612344,10612345,10609348,10609362,10609363,10612380,10612381,10612383,10609387,10609397,10609398,10612417,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,10609463,10612465,10612471,10612474,10612482,10609505,10612517,10612519,10612520,10612522,10612523,10612525,10609527,10612541,10609543,10612544,10609544,10612545,10609549,10609550,10612565,10609590,10609607,10609609,10612613,10612614,10612617,10609625,10609626,10612627,10609630,10612632,10609636,10609637,10609654,10612657,10609666,10609668,10612691,8862556,8862557,10609707,10609708,10609715,10609716,10612746,10612757,10609817,10612821,10557973,10612825,10612841,10609842,10612849,10612867,10612886,10612887,10612888,10612889,10612890,10609898,10612904,10612905,10612958,10610006,10610022,10613025,10610041,10610044,10610046,10610054,10610068,10613078,10613089,10610106,10610236,10610271,10610306,10610307,10613318,10610327,10613350,10610366,10613405,10613470,10613471,10613490,10610493,10613540,10613562,10613578,10613584,10613593,10613594,10613595,10613596,10613643,10613646,10610675,10613691,10613694,10610701,10610705,10613741,10610765,10610766,10610767,10610768,10610769,10610770,10610771,10610772,10610773,10610774,10610775,10610776,10610777,10610778,10613802,10610826,10610834,10610850,10610860,10610862,10610868,10610870,10610906,10610958,9169393,9169551,9169700,9169870,9169871,9161891,9161892,9161893,9169985,10419266,10416281,10416282,10417290,10419298,10418300,10418301,10418305,10418306,10418308,10417311,10415315,10415316,10418316,10418317,10418319,10419338,10418349,10416359,10419370,10417371,10419371,10418374,10419376,10419377,10419382,10419383,9168463,10415395,10418424,10415427,9168508,10418436,10418438,10416444,10418444,10418451,10415451,10415452,10415453,10416453,10415455,10415458,10416458,10415459,10416459,10416466,10418470,10418473,10416478,10416488,10419497,10416517,10416518,10419524,10417531,10415532,10416543,10417545,10415548,10416550,10418555,10417565,10416573,10416574,10418579,10418581,10418582,9168670,10417599,10415603,10416610,10416611,10416612,10416613,9168696,9168697,9168698,10416639,9168721,10415643,10415644,10415645,10415648,10416649,10415650,10416650,10415651,10416651,10415654,10419654,10416656,10417658,10416658,10416659,10416660,10415661,10415665,10416673,10416674,10415682,10416692,10416693,10415694,10416694,10416696,10415701,10416702,10415704,10415706,10415716,10415719,10415722,10415724,10417725,10416728,10416729,10417743,10415747,10418756,10416773,10416774,10416775,10416780,10416782,10416785,10416786,10416789,10416796,10416798,10416801,10416802,10416803,10416804,10416805,10418816,10418817,10418818,10418819,10418820,10416822,10416823,10416824,10416825,10418843,10418844,10419852,10418866,10419869,10419870,10416875,10416876,10416877,10416878,10418920,10418924,10418926,10418930,10418931,10418934,10418935,10418936,10415937,10418937,10418938,10418941,10418944,10418945,10416946,10417946,10416947,10418947,10416948,10418949,10417949,10417950,10418953,10417953,10417954,10417958,10417960,10417961,10418962,10418963,10418964,10417964,10418965,10417965,10417966,10417967,10418969,10418970,10418971,10418972,10417972,10418973,10417973,10418974,10416977,10418977,10416978,10417979,10417980,10418986,10417989,10418991,10418992,10417996,10417001,10417002,10418002,10418003,10419004,10418005,10418007,10417008,10418008,10418012,10418013,10417017,10417018,10418018,10417019,10417020,10418020,10417021,10418021,10417022,10419023,10417023,10417024,10419024,10418024,10417025,10419025,10417026,10419027,10418027,10416028,10419029,10418029,10419033,10419034,10419035,10418036,10419037,10419038,10419039,10418040,10417041,10419041,10417042,10419042,10416043,10419044,10417046,10417047,10418047,10419048,10419049,10419051,10419054,10416056,10419058,10419059,10419060,10418060,10419061,10417062,10419062,10419063,10419065,10419066,10417068,10418068,10419069,10419070,10419072,10419073,10419074,10419075,10416076,10419076,10418076,10417077,10417078,10419078,10416079,10419079,10419080,10419081,10419084,10419085,10419086,10419087,10419088,10419089,10419090,10419091,10419092,10419094,10419095,10419097,10419098,10416113,10418114,10419117,10416118,10418118,10418122,10419123,10418123,10418124,10419125,10418125,10418126,10418127,10418128,10418129,10419130,10418130,10419131,10418131,10418132,10419133,10418133,10419134,10418134,10418135,10419136,10418136,10419137,10418137,10418138,10418139,10419141,10418141,10418142,10418143,10418144,10418145,10418146,10419150,10419151,10419152,10418152,10419154,10419155,10419166,10419168,10419171,10419175,10419177,10416183,10419194,10419196,10419198,10419200,8864959,10471108,10471111,10471114,10471117,10471119,10469285,10469286,10469311,10463361,10469395,10467504,10467613,10469942,10469966,10470092,4972395,4972396,10464213,10470217,10464231,10464235,10470236,10470262,10470267,10470278,10470284,10470286,10470287,10470288,10470305,10470307,10470312,10470317,10470318,10470320,10470321,10468336,10470341,10470342,10464343,10470344,10470345,10470346,10470347,10464354,10470355,10470356,10470358,10470371,10470372,10470374,10470377,10470380,10470381,10470382,10470384,10470385,10470386,10468395,10470420,10470442,10470443,10470445,10470447,10470477,10470478,10470489,10470588,10470592,10468670,10468671,10468672,10468673,10468674,10468675,10468676,10468677,10468678,10468679,10468680,10468681,10468682,10468683,10468684,4972999,10462752,10462753,10468771,10468772,10468775,10468847,9160273,10468850,10628157,10628321,10628851,10628853,10632010,10632011,10632012,10632013,10632014,10632018,10627321,10627712,10631886,10631887,10626954,10521187,10521188,10421495,10477405,10477418,10477425,10477502,10477542,10476340,10476345) 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'