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(10939602,10939616,10939735,10939741,10939866,10939867,10939868,10939909,7068326,7068327,4970666,4970667,4970668,4970669,4970744,4970929,4970935,10940332,10940333,10940334,10940335,10940336,10940337,10940338,10940339,10940340,10940341,7068640,7068641,7068642,7068643,7068644,7068645,7068646,7068647,7068648,7068649,7068650,7068651,7068652,7068653,7068654,7068655,7068656,7068657,7068658,7068659,7068660,7068661,7068662,7068663,7068664,7068665,7068666,7068667,7068668,7068669,7068670,7068671,7068672,7068673,7068674,7068675,4971142,4971149,4971150,4971151,7065866,7065867,8066968,7065902,7065903,7065904,7065905,7065906,7065907,7065908,7065909,8067259,10437197,10437198,10437199,10437350,8067474,8067479,8067552,10437437,10437438,10437439,10437440,10437494,10437570,10437571,8067791,8067792,8067813,7066818,7066820,7067251,7067252,7067254,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,7067536,8068519,7067537,8068520,7067538,8068521,7067539,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,8068574,8068575,8068576,8068577,8068578,8068579,8068580,8068581,8068582,8068583,8068584,8068585,8068586,8068587,8068588,8068589,8068590,8068591,8068592,8068593,8068594,8068595,8068596,7067655,7067674,7067795,7067808,6000260,6000261,6000262,6000263,6000264,6000265,6000266,6000267,6000268,6000269,6000270,6000271,7064028,10931541,10931542,10931543,10931544,10931545,7064364,7064365,10932037,10932140,10932257,10932264,10932330,10932331,10932332,10932333,10932334,8065980,8065990,8066010,10932435,10932436,10932437,10932438,10932474,10932611,10932620,10932652,10932660,10932669,10932670,10932682,10932691,10932695,7065282,10932776,10932829,10932854,10932855,8066498,8066499,8066500,8066501,8066502,8066503,8066504,8066505,8066506,8066507,8066508,8066509,8066510,8066511,8066512,10932882,8066513,8066514,8066515,8066516,8066517,8066518,8066519,8066520,8066521,8066522,8066523,8066524,8066525,8066526,8066527,8066528,8066529,8066530,8066531,8066532,10932903,8066533,8066534,8066535,8066536,8066537,8066538,8066539,8066540,8066541,8066542,8066543,8066544,8066545,8066546,8066547,8066548,8066549,8066550,8066551,8066552,8066553,8066554,8066555,8066556,10933031,7065595,4967985,10933192,8860925,8860934,8860935,8860986,8860987,8860988,8860989,8860990,10942895,10942896,10942897,10942898,8861179,8861180,8861310,8861335,8861387,8861391,10943217,8861410,10943222,8861411,10943261,8861471,6000018,6000019,6000020,6000021,6000022,6000023,6000024,3655551,10940747,10940748,3655779,3655780,10944768,8072317,8072461,8072462,3656619,3656620,3656621,8072788,8072789,8072790,8072791,8072792,3656639,3656653,3656671,8072966,8072967,8072968,8072969,8072970,8072971,8072972,8072973,8072974,8072975,8072976,8072977,8072978,8072979,8072980,3656816,8072981,8072982,8072983,3656841,3656842,3656899,3656904,3656918,3656939,10942082,10942083,10942084,10942085,8860319,10942154,10942155,8860344,10942156,10942157,8860349,8860350,10942227,10942228,10942229,10942236,10942237,10942238,10942263,8860488,8860498,8970062,8970063,8860657,10942479,10923472,10923473,10923474,10923475,10923476,10923477,10923478,10923479,10923480,10923481,10923482,10923483,10923484,10923485,10923486,10923487,10923488,10923489,10923490,10923491,10923492,10923493,10923494,10923495,10923496,10923497,10923498,10923499,10923500,10923501,10923502,10923503,10923504,10923505,10923506,10923507,10923508,10923509,10923510,10923511,10923512,10923513,10923514,10923515,10923516,10923517,10923518,10923519,10923520,10923521,10923522,10923523,10923524,10923525,10923526,10923527,10923528,10923529,10923530,10923531,10923532,10923533,10923534,10923535,10923536,10923537,10928552,10928553,10918594,10918595,10918596,10918597,10623395,10623475,10919166,10919167,10919168,10919169,10919170,10919171,10919465,10919466,10919467,8070905,10919810,10919811,10919908,10919941,10919942,8071171,8071172,8071173,8071174,8071195,8071324,8071336,8071352,8071364,10922473,10927488,10927489,10927490,10922494,10922495,10927509,10927510,10927511,10927512,10927513,10927514,10927515,10922575,10622103,10622104,10622105,10917679,10917680,10917681,10917935,10917936,10917937,10917938,10917939,10622533,10622534,10622535,10928061,10928104,10928132,10928133,10928134,10928135,10923395,10923396,10923397,10923398,10923399,10923400,10923401,10923402,10923403,10923404,10923405,10923406,10923407,10923408,10923409,10923410,10923411,10923412,10923413,10923414,10923415,10923416,10923417,10923418,10923419,10923420,10923421,10923422,10923423,10923424,10923425,10923426,10923427,10923428,10923429,10923430,10923431,10923432,10923433,10923434,10923435,10923436,10923437,10923438,10923439,10923440,10923441,10923442,10923443,10923444,10923445,10923446,10923447,10923448,10923449,10923450,10923451,10923452,10923453,10923454,10923455,10923456,10923457,10923458,10923459,10923460,10923461,10923462,10923463,10923464,10923465,10923466,10923467,10923468,10923469,10918469,10923470,10923471,10920495,10920496,10920497,10920498,10920499,10920500,10920501,10920502,10920503,10920504,10920505,10620087,10620088,10620089,10620092,10620093,10620094,10620097,10620221,10921032,10921033,10620565,10921197,10921198,10921199,10926308,10926309,10926354,10926355,10926356,10926357,10926358,10921866,10921867,10921868,10921869,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,10916923,10621413,10621414,10916924,10621415,10916925,10621416,10916926,10621417,10916927,10621418,10916928,10621419,10916929,10621420,10916930,10916931,10916932,10916933,10916934,10916935,10916936,10916937,10916938,10916939,10916940,10916941,10916942,10916943,10916944,10916945,10916946,10916947,10916948,10916949,10916950,10916951,10916952,10916953,10916954,10916955,10916956,10916957,10916958,10916959,10916960,10916961,10921962,10916962,10921963,10916963,10916964,10921965,10916965,10916966,10922295,10922311,10922312,10922313,10922314,10917395,10917396,10917397,10917398,10917399,10917400,10611123,10611128,10611129,10611130,10611131,10611132,10611133,10611134,10611145,10611238,10611242,10611245,10614259,10611359,10614579,10614580,10614583,10614584,10614586,10609241,10609242,10609243,10609244,10609245,10609246,10609247,10609248,10609249,10609250,10609251,10609252,10609253,10609254,10609255,10609256,10609257,10609258,10609259,10609260,10609261,10609262,10609263,10609329,10609343,10609344,10609345,10609346,10612380,10612507,10612508,10612509,10612510,10612558,10612594,10612678,10612723,10609838,10609943,10564124,10564125,10612975,10564126,10612976,10564127,10612977,10564128,10612978,10612982,10609990,10610026,10613138,10558374,10558375,10558376,10558377,10558378,10558379,10558380,10558381,10558382,10558383,10558384,10558385,10558386,10558387,10558388,10558389,10558390,10558391,10558392,10558393,10558394,10558395,10558396,10558397,10558398,10558399,10613295,10558452,10613302,10558470,10558471,10558478,10558479,10610334,10558501,10558502,10558503,10558504,10558505,10610355,10558506,10613443,10564636,10564656,10564674,10613567,10564776,10564777,10564778,10564828,10610791,10610793,10517117,10517118,10517119,10517120,10517121,10517122,10517123,10517124,10517125,10517126,10517127,10517128,10517129,10517130,10517131,10517132,10517133,10517134,10517135,10517136,10517137,10517138,10517139,10517140,10517141,10517145,10517146,10517147,10517148,10517170,10517171,10517172,10517173,10517174,10517175,10517176,10517177,10517178,10517562,10517575,10517576,10517577,10517578,10517579,10517580,10517581,10517582,10517583,10517584,10517585,10517586,10517587,10517588,10517589,10517590,10517591,10517596,10517597,10517598,10517599,10517600,10517601,10517602,10517603,10517604,10555774,10555775,10555776,10512179,10556419,10518981,10518982,10415230,10415321,10419695,10416070,10416071,10416072,10416073,10416074,10416075,10420125,10420126,10420127,10420128,10420129,10420130,10420131,10420144,10471112,8563206,10470095,8563466,10470446,10470573,10470574,10470620) 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'