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(4970773,8583431,8583432,8583433,10950674,8067921,8067922,8067923,8573231,8573232,8573233,8573234,8573235,8573236,8573237,8573238,10939393,7201382,7201447,7201455,3899090,7201959,5654561,5654617,9794574,9794575,9794576,9794577,9794587,9794588,9794590,9794591,7065910,7200722,7200724,7200727,7200729,10944444,3235763,3235785,7198660,7198780,7198785,7198800,7198802,7198806,7198807,7198810,7198813,7199069,10101450,10101521,11048365,7197114,7197115,7197116,7197117,7197118,7197119,7197120,7197121,7197122,7197123,7197124,7197125,8906979,8906980,8906981,8906982,8906983,8906984,8906985,8906986,8906987,10838834,7197848,8905663,8905677,8905680,10930629,10426206,8540671,8611282,8611283,8611284,8611285,8611286,8611287,8904920,8904921,8904922,8904923,8904924,8904925,8904926,8904927,8904928,8904929,8904930,8904931,8904932,8904933,8904934,8904935,8904936,8904937,8904938,8904939,8904940,8904941,8904942,8904943,8904944,8904945,8904946,8904947,8904948,10616938,10614177,10714109,10714110,10611371,10611778,10609400,10609401,10609402,10609403,10609404,10609405,10609406,10609407,10609408,10609409,10609410,10609411,10609412,10609413,10609414,10609415,10609416,10609417,10609418,10609419,10609420,10609421,10609422,10609423,10609424,10609425,10609426,10609427,10609428,10609429,10609430,10609431,10609432,10609433,10609434,10609435,10609436,10609437,10609438,10609439,10609440,10609441,10609442,10609443,10609444,10609445,10609446,10609447,10609448,10609449,10609450,10609451,10609452,10609453,10609454,10609455,10609456,10609457,10609458,10609459,10609460,10609461,10609462,10609463,10609464,10609465,10609466,10609467,10609468,10609469,10609470,10609471,10609472,10609473,10609474,10609475,10609476,10609477,10609478,10609479,10609480,10609481,10609482,10609483,10609484,10609485,10609486,10609487,10609488,10609489,10609490,10609491,10609492,10609493,10609494,10609495,10609496,10609497,10609498,10609499,10609500,10609501,10609502,10609503,10609504,10609505,10609506,10609507,10609508,10609509,10609510,10609511,10609512,10609513,10609514,10609515,10609516,10609517,10609518,10609519,10609520,10609521,10609522,10609523,10609524,10609525,10609526,10609527,10609528,10609529,10609530,10609531,10609532,10609533,10609534,10609535,10609536,10609537,10609538,10609539,10609540,10609541,10609542,10609543,10609544,10609545,10609546,10609547,10609548,10609549,10609550,10609551,10609552,10609553,10609554,10609555,10609556,10609557,10609558,10609559,10609560,10609561,10609562,10609563,10609564,10609565,10609566,10609567,10609568,10609569,10609570,10609571,10609572,10609573,10609574,10609575,10609576,10609577,10609578,10609579,10609580,10609581,10609582,10609583,10609584,10609585,10609586,10609587,10609588,10609589,10609590,10609591,10609592,10609593,10609594,10609595,10609596,10609597,10609598,10609599,10609600,10609601,10609602,10609603,10609604,10609605,10609606,10609607,10609608,10609609,10609610,10609611,10609612,10609613,10609614,10609615,10609616,10609617,10609618,10609619,10609620,10609621,10609622,10609623,10609624,10609625,10609626,10609627,10609628,10609629,10609630,10609631,10609632,10609633,10609634,10609635,10609636,10609637,10609638,10609639,10609640,10609641,10609642,10609643,10609644,10609645,10609646,10609647,10609648,10609649,10609650,10609651,10609652,10609653,10609654,10609655,10609656,10609657,10609658,10609659,10609660,10609661,10609662,10609663,10609664,10609665,10609666,10609667,10609668,10609669,10609670,10609671,10609672,10609673,10609674,10609675,10609676,10609677,10609678,10609679,10609680,10609681,10609682,10609683,10609684,10609685,10609686,10609687,10609688,10609689,10609690,10609691,10609692,10609693,10609694,10609695,10609696,10609697,10609698,10609699,10609700,10609701,10609702,10609703,10609704,10609705,10609706,10609707,10609708,10609770,10612907,10612910,10612911,10612912,10612913,10612914,10612945,10610006,10613287,10613288,10613381,10613387,10613390,10613393,10613420,10613421,10613430,10613431,10613432,10613433,10613524,10613525,10613563,10613564,7055669,7055675,8552159,8552160,8552161,8552162,8552163,8552164,8552165,8552166,8552167,8552168,8552169,8552170,8552171,8552172,6672565,6672566,6672567,6672568,6672569,10415616,10417649,10415684,10418734,9168888,9168890,9168891,9168987,10117320,10117440,10117441,10117442,10117443,10117444,10117445,10117446,10117447,10117448,10117449,10117450,10117451,10117452,10117453,10117454,10117455,10117456,10117457,10117458,10117459,10117460,10117461,10117462,10117463,10117464,10117465,10117466,10117467,10117468,10117469,10117470,10117471,10117472,10117473,10117474,10117475,10117476,10117477,10117478,10117479,10117480,10117481,10117482,10469159,10469160,10469161,10471167,10469190,10469191,10469193,10469195,10469198,10469200,10469201,10469203,8549928,8549929,10467486,10467487,10467488,10467489,10467490,10467491,10467492,10467493,10467494,10467495,10467496,10467497,10467498,10467499,10467500,10467501,10467502,10467503,10467504,10467505,10467506,10467507,10467508,10467509,10467510,10467511,10467512,10467513,10469514,10467514,10467515,10467516,10467517,10467518,10467519,10467520,10467521,10467522,10467523,10467524,10467525,10467526,10467527,10467528,10467529,10467530,10467531,10467532,10467533,10467534,10467535,10467536,10467537,10467538,10467539,10467540,10467541,10467542,10467543,10467544,10467545,10467546,10467547,10467548,10467549,10467550,10467551,10467552,10467553,10467554,10467555,10467556,10467557,10467558,9167684,9167685,9167686,9167687,9167688,9167689,9167690,9167691,9167692,9167693,9167694,9167695,9167696,9167697,9167698,9167699,9167700,9167701,9167702,9167703,9167704,9167705,9167706,9167707,9167708,9167709,9167710,9167711,9167712,9167713,9167714,9167715,9167716,9167717,9167718,9167719,9167720,9167721,9167722,9167723,9167724,9167725,9167726,9167727,9167728,9167729,9167730,9167731,9167732,9167733,9167734,9167735,9167736,9167737,9167738,9167739,9167740,9167741,9167742,9167743,9167744,9167745,9167746,9167747,9167748,9167749,9167750,9167751,9167752,9167753,9167754,9167755,9167756,9167757,9167758,9167759,9167760,9167761,9167762,9167763,9167764,9167765,9167766,9167767,9167768,9167769,9167770,9167771,10116203,10889490,10890177,10882472,10882473,10882474,10882475,10882476,10882477,10882478,10882479,10882480,10882481,10882482,10882483,10882484,10882485,10882486,10882487,10882488,10882489,10882490,10882491,10882492,10882493,10882494,10882495,10882496,10882497,10882498,10882499,10882500,10882501,10882502,10882503,10882504,10882505,10882506,10882507,10882508,10882509,10882510,10882511,10882512,10882513,10882514,10882515,10882516,10882517,10882518,10882519,10882520,10882521,10882522,10882523,10882524,10882525,10882526,10882527,10882528,10882529,10882530,10882531,10882532,10882533,10882534,10882535,10882536,10882537,10882538,10882539,10882540,10882541,10882542,10882543,10882544,10882545,10882546,10882547,10882548,10882549,10882550,10882551,10882552,10882553,10882554,10882555,10882556,10882557,10882558,10882559,10882560,10882561,10882562,10882563,10882564,10882565,10882566,10882567,10882568,10882569,10882570,10882571,10882572,10882573,10882574,10882575,10882576,10882577,10882578,10882579,10882580,10882581,10882582,10882583,10882584,10882585,10882586,10882587,10882588,10882589,10882590,10882591,10882592,10882593,10882594,10882595,10882596,10882597,10882598,10882599,10882600,10882601,10882602,10882603,10882604,10882605,10882606,10882607,10882608,10882609,10882610,10882611,10882612,10882613,10882614,10882615,10882616,10882617,10882618,10882619,10882620,10882621,10882622,10882623,10882624,10882625,10882626,10882627,10882628,10882629,10882630,10882631,10882632,10882633,10882634,10882635,10882636,10882637,10882638,10882639,10882640,10882641,10882642,10882643,10882644,10882645,10882646,10882647,10882648,10882649,10882650,10882651,10882652,10882653,10882654,10882655,10882656,10882657,10882658,10882659,10882660,10882661,10882662,10882663,10882664,10882665,10882666,10882667,10882668,10882669,10882670,10882671,10882672,10882673,10882674,10882675,10885693,10885694,10885750,10885751,10161774,10161775,10161776,10885765,10161777,10161778,10885767,10161779,10161780,10161781,10161782,10161783,10161784,10161785,10161786,10161787,10161788,10161789,10161790,10161791,10161792,10161793,10161794,10161795,10161796,10161797,10161798,10161799,10161800,10161801,10161802,10161803,10161804,10161805,10161806,10161807,10161808,10161809,10161810,10161811,10161812,10161813,10161814,10161815,10161816,10885867,10885871,10162058,10882438,10882439,10882440,10882441,10882442,10882443,10882444,10882445,10882446,10882447,10882448,10882449,10882450,10882451,10882452,10882453,10882454,10882455,10882456,10882457,10882458,10882459,10882460,10882461,10882462,10882463,10882464,10882465,10882466,10882467,10882468,10882469,10882470,10882471,10421397) 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'