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(10447715,8630498,10447778,10447794,10447801,10447803,8630736,8630751,8630755,7076128,8630885,8630920,8630923,8630924,8630925,8630926,8630966,8630973,8574513,8631009,8631055,10989095,8631060,8631066,3228951,3228952,3228957,8631231,8631232,8631233,8631234,8631235,8631236,8631237,8631240,8631241,8631242,8631243,8631244,8631245,8631246,8631247,10950305,8621516,3229203,8583440,10950606,10950652,10950674,10963827,10963833,10963838,10963841,7074350,7074351,8632050,8632051,8632052,8632053,8067527,8632124,8632131,8632139,8632140,8622408,8622468,8622469,8622470,7066784,7066822,10437774,3227262,3227263,8067943,8837489,7067236,7075498,11001272,10939443,10962463,10845543,10930065,7201214,7201215,10842809,7201330,7201374,7201605,7201607,10960068,10960069,7201683,7201728,7201729,7201898,11038487,10103965,10104022,3899414,7202165,7202168,7202171,3899586,4967460,8836618,7073283,11000166,7202767,10104659,3227184,3227186,3227207,11010592,11010593,11010597,11010605,11036623,11036624,11036625,11036626,11036627,11036628,11036629,11036630,11036631,11036632,11036633,11036634,11036635,8616854,7200506,7200507,7200508,10958957,10958958,7200529,10958979,10958980,7200547,10959210,7200786,7200817,11011437,10998476,7201041,11047501,11047502,11047505,10839683,7198366,7198374,7198395,10839909,7198459,7198460,7198461,7198462,7198679,7198702,7198703,7198704,7198713,7198721,7198723,7198725,7198728,7198729,7198742,7198743,7198744,7198745,7198746,7198747,7198749,7198759,7198762,7198764,7198769,7198770,7198772,11009407,11009408,11009409,11009410,10941692,10941757,10941763,10941773,10941782,8616099,8860405,8860499,8860500,10942410,8905934,10993602,7196189,7196192,7196198,7196220,8612822,3233407,3233418,11045730,7196380,7196381,10618282,7196382,10618283,10618284,10618285,7196404,10618360,10618361,10618362,10618363,8613074,11045976,7196554,11046102,11007190,3233953,3233954,3233956,10623723,7196890,10968343,7196906,7196955,7196956,7196963,10838527,10838529,10838543,10838552,10968571,8907037,8907067,10838980,10838981,10838982,10838983,3234705,3234706,7197609,7197611,7197613,11008054,8907434,7197643,7197646,7197649,7197650,7197651,7197652,7197655,7197687,7197689,7197690,7197691,7197725,7197726,7197727,7197728,7197729,7197745,7197770,3234959,3234960,3234961,3234962,3234963,3234964,3234965,3234979,3234980,3234981,7197846,7197849,7197850,10619885,10619886,10619887,10619895,10619906,11047498,11047499,3232240,3232243,3232246,3232247,3232292,3232297,3232313,3232318,3232319,3232333,3232382,8541571,8541572,8541573,8541581,8541592,11044797,11044798,11044799,11044803,11044804,11044807,11044808,11044809,11044810,11044811,11044812,11044813,8905209,10992846,10992847,10992848,10992849,10992850,10992851,10992852,8612004,10992853,10992854,8612005,10992855,10617338,10617372,10617375,10617376,10617377,8612107,10617426,10617444,10617445,10617446,10622447,10617447,8612449,10993360,10993361,10993374,8542204,8542252,8542253,10614984,10614986,10614987,10614991,10614993,10615167,10425486,10425487,3230662,3230663,3230664,10848001,10848002,10848003,10848007,10425933,10425937,10425938,10425941,10426014,10615819,10615896,10426151,10991493,10615956,10991499,10991500,10426194,8540359,8540360,8540362,8540364,8540365,8540370,8540401,10426253,8540402,10426254,8540408,8540409,8540411,8540412,8540413,8540414,10991589,10952581,10426339,10991660,10991733,10991734,8611003,8904234,8904290,10991935,10991956,10991957,10991958,3231700,3231702,3231704,3231760,10922135,10922136,10922137,10922138,10922205,10992234,10922206,10922207,10922208,10922209,8611462,8611464,10922304,10922305,10992397,3232165,3232166,10616905,7059524,10611252,10611253,7059757,10611339,9173739,10611445,9173901,9214000,10122201,9166217,9206288,10612107,9211554,9211555,9211567,8542801,10612320,10612321,10609369,9211916,9211936,9211937,10609749,9172146,10612939,8862829,8862830,10612972,9212321,9196360,10613104,9172464,9172465,9172466,6676843,10613350,10613369,7018646,7018647,7018648,7018649,7018650,7018651,7018652,7018653,7018654,7018655,7018656,7018657,7018658,7018659,7018660,7018661,7018662,6677269,6677364,10515134,10515135,10515136,10117529,9209501,6673789,9185606,9185607,9185609,9185630,9185737,9185738,9185744,7055922,10118016,9185856,9185857,9185866,9185879,9185896,9185897,9169903,9185944,9185945,9185946,9169946,9169947,9169948,10118247,10118248,10118294,10118295,10118298,6674331,6674332,10516136,10118606,10118607,10118676,10118677,9186755,9170757,9186804,10518668,8552226,10512782,9171102,10119336,10515061,7057449,10416255,10416256,10416260,10416261,4973195,10416264,10416265,10416266,10416272,10416298,10419307,9192413,10416358,6672657,10417385,6672670,9192475,10416411,6672698,10116700,10116701,10116702,10116703,10116704,10116705,10116706,10116707,10116708,10116709,10419469,9192597,9192612,9192613,9168733,7054903,9168765,9168775,10419705,10419713,10419729,10419740,10418799,10418800,10418801,10418802,10418803,10418826,10415837,10418847,10418848,9168939,10415885,10415886,10419995,10420009,9193121,10420094,10420098,10417118,10417125,10462939,10462940,7020058,7020059,7020060,7020061,7020062,7020063,7020064,7020065,7020066,7020067,7020068,7020069,7020070,7020071,10463006,10463023,10122662,10463046,10463049,10463050,10463051,10463052,10467118,10467120,10467130,10471172,10471173,10471174,10467224,10463399,9166826,9166828,10467432,10463433,10463434,10463436,10463439,9166869,7020586,7020587,7020588,7020589,7020590,7020591,7020592,7020593,7020594,7020595,7020596,7020597,9183002,8550263,8550264,8550265,10463732,10465763,10465770,10465795,10463800,10463802,10465804,9175234,10463811,10463812,10465813,10463813,10463817,10463819,10465819,10465835,10465840,10465910,9167472,8550648,9175497,9175498,9175561,9175564,9175565,9207637,9207713,9207732,10466311,9207749,10466332,10466334,10466341,9207772,10466353,10466364,10466366,10466382,10466384,10462413,10462432,10462441,10466443,10462451,9183876,9183877,9183878,9167896,10462530,10462531,10462731,10466856,10466858,10888487,10884086,10884088,10889997,10885074,10890130,10890133,10890135,10890136,10890139,10890140,10890141,10890142,10890143,10890144,10890145,10890146,10890147,10890149,10890168,10880207,10880208,10880209,10885347,10885349,10632051,10632312,10888013,10888018,10888019,10627710,10630023,10630024,10630025,10630027,10630028,10630031,10630032,10630035,10630179,10172076,10891115,10162243,10886250,10891354,10891355,10886377,10886378,10886379,10886380,10886381,10886382,10886383,10886384,10886385,10886386,10886387,10886388,10886389,10886390,10881537,10626235,10631237,10631279,10631280,10631281,10631282,10631283,10631284,10631285,10631286,10631287,10631288,10631443,10882010,10168058,10887096,10887097,10892200,10892201,10892202,10892203,10892204,10892205,10892206,10892207,10892357,10892358,10631896,10631909,10631910,10887464,10580181,10580182,10580183,10580184,10580185,10580186,10580187,10568313,10568314,10568315,10601359,10601360,10601400,10598680,10598681,10598682,10598683,10598684,10598685,10598686,10598687,10598688,10598689,10598690,10598691,10598692,10598693,10598694,10598695,10598696,10598697,10598698,10598699,10598700,10598701,10598702,10598703,10598704,10598705,10598706,10598707,10598708,10598709,10598710,10598711,10598712,10598713,10598714,10598715,10598716,10598717,10598718,10598719,10598720,10598721,10598722,10598723,10598724,10598725,10598726,10598727,10598728,10598729,10598730,10598731,10598732,10598733,10598734,10598735,10598736,10598737,10598738,10598739,10598740,10598741,10598742,10598743,10598744,10598745,10598746,10598747,10598748,10598749,10598750,10598751,10598818,10598819,10598820,10598843,10598844,10598845,10598857,10598865,10598866,10590274,10590277,10590279,10590280,10590299,10590300,10590301,10590302,10590303,10590304,10590305,10590306,10590310,10590311,10590484,10590485,10590486,10590487,10590488,10590489,10590490,10590491,10591929,10591930,10591931,10591932,10591933,10591934,10591935,10591936,10545367,10545392,10529409,10529412,10529413,10541443,10541447,10541448,10525564,10527840,10527841,10528108,10528115,10528116,10528117,10528142,10528146,10528162,10528176,10528177,10522283,10522284,10520781,10520782,10520783,10520784,10520785,10526866,10543042,10539077,10422222,10420314,10420315,10420317,10420323,10421426,10421427,10420438,10422520,10420573,10423626,10423923,10506819,10506824,10506825,10425043,10425044,10425052,10425057,10423157,10407345,10407353,10407459,10407526,10490316,10483438,10486570,10407956,10473691,10495008,10495010,10495014,10478015,10495016,10487109,10487112,10493297,10493298,10497400,10406888,10406889,10406890,10406891,10406892,10476553,10408980,10408985,10408986,10408987,10408988,10476652,10409049) 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'