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(7066021,10950729,10951078,8575843,10929246,10929247,10929248,10929249,3227394,10929250,10929251,10929252,10929253,7201533,7201534,7201769,7201770,7201771,7201772,7201773,7201774,8911587,8911588,7201975,7202187,7202189,7202194,7202682,8910239,8910240,7200536,7200736,7200934,7201170,10995654,10995655,10995662,10995663,10995664,10995665,10995666,10995667,10995668,10995669,10995670,10995671,7198332,7198691,7198695,7198696,7198697,7198698,7198702,7198710,7198711,7198712,7198716,7198718,7198721,10996308,10996309,10996310,10996390,10996400,10996401,10996402,10996403,10996404,10996405,10996407,10996408,10996409,10996410,10996411,8909072,7200088,7070863,7070864,3233597,7196574,7197275,7197281,10838834,10838836,10838943,10838944,10838946,10838947,10838949,10838950,10838952,8907408,3235083,11047379,7198001,7198002,7198003,10616994,10927510,10617221,8905372,8905373,8612186,8905553,8905555,8905807,8905953,8612746,10614973,10614974,10615129,10615133,3230579,10615202,10425569,10425577,10615315,10615560,10615561,10615562,10615563,10615564,10615565,10615566,10615567,10615571,10991661,10426341,10991662,10616073,10616074,10991767,10991768,10991769,10991770,10991771,10991772,10991773,10991774,10426458,10426459,8611322,8611335,10616740,10616772,10616774,10614079,10614089,10614160,10559318,10559319,10614275,10559471,10559472,10559473,10559474,10559475,10559477,10714145,10614354,9214058,9214068,10611826,10611827,10611828,10611829,10611836,10612054,10612228,10612320,7017375,7017376,7017377,7017378,7017379,7017380,7017381,7017382,7017383,7017384,7017385,7017386,7017387,7017388,7017389,7017390,7017391,7017392,7017393,7017394,7017395,7017396,7017397,7017398,7017399,7017400,7017401,7017402,7017403,7017404,7017405,7017406,10612723,10612725,10612735,10612736,10612738,10612761,10612762,10612773,10612774,10612775,10612805,10609817,10609951,10612962,10612966,10612967,10612972,10612974,10612976,10612978,10612986,10612991,10612993,10612996,10612998,10613020,10613021,10613022,10613028,10613034,10613037,10613038,10613040,10613043,10613044,10613045,10613046,10613047,10613048,10613049,10613050,10613051,10613056,10613058,10613061,10613062,10613080,9188479,9188481,9188482,9188483,9188484,9188486,9188487,9188488,9188508,9188510,9188512,9188521,9188523,9188525,9188526,9188527,9188534,9188535,9188536,9188537,9188540,9188543,9188544,9188565,10610228,9188567,9188579,9188580,9188581,10613247,10613438,10613464,10613699,10613736,9173077,9173078,9173079,9173080,9173081,9173082,9173083,9173086,9173087,9189156,9189165,9189245,10610908,10610909,9189250,9189252,9189255,9189256,9189258,9189264,10610931,10610942,6673508,6673511,6673512,6673513,6673514,6673517,6673518,6673551,6673552,6673553,6673555,6673558,10117655,10117754,6673819,6673821,6673826,6673828,6673829,6673832,6673834,6673835,6673837,6673839,6673840,6673842,6673846,6673847,6673853,6673858,6673860,6673861,6673863,6673864,6673868,6673871,6673873,6673874,6673876,6673879,6673882,6673886,6673892,6673899,6673903,6673905,6673909,6673911,6673912,6673914,6673915,6673917,6673926,6673927,6673929,6673931,6673933,6673935,6673940,6673941,6673944,6673948,6673953,6673955,6673957,9169752,6673959,6673963,6673966,6673972,6673974,10117971,6673983,6673985,6673992,6673994,6673995,6673996,6673998,6674001,9169797,6674004,6674006,6674010,6674014,6674015,6674016,6674017,6674018,6674022,10118018,6674028,6674031,6674033,6674035,6674038,10118032,10118033,6674042,10118034,4974691,6674044,10118037,10118038,10118039,10118040,6674049,10118041,6674051,4974698,10118044,10118049,6674059,4974706,6674061,6674063,4974714,10118058,6674069,6674077,6674087,9169883,6674093,6674095,6674096,6674117,6674118,6674144,10118139,10118140,10118177,10118216,10118217,10118407,10118415,10118416,10118417,10118491,10118503,10118551,10118582,9187265,8542438,8542439,9187267,9187268,7013963,7013964,7013965,7013966,7013967,7013968,7013969,7013970,7013971,7013972,7013973,7013974,6672597,6672605,10417355,10416375,10416378,10416381,6672711,6672712,6672735,6672738,6672740,6672741,6672744,6672745,6672751,6672752,6672754,6672755,6672757,6672759,6672760,6672762,6672763,6672764,6672765,6672766,10419501,10419502,10419503,6672807,10417529,6672814,10419604,10419608,10419611,10415615,10419615,10419624,10419630,10417634,10419634,10419643,10419653,10419654,9168733,10419655,10419656,10419660,10419661,10419662,10419663,10419664,10419665,9168764,9168765,6672992,6672993,9168787,6672994,6672996,6672997,6672998,6672999,6673000,6673001,6673002,6673003,6673011,7014552,7014553,7014554,7014555,7014556,7014557,7014558,7014559,7014560,7014561,7014562,7014563,7014564,7014565,7014566,7014567,7014568,7014569,7014570,7014571,7014572,7014573,7014574,7014575,7014576,7014577,7014578,7014579,7014580,7014581,7014582,7014583,7014584,7014585,7014586,7014587,7014588,7014589,7014590,7014591,7014592,7014593,7014594,7014595,7014596,7014597,7014598,7014599,7014600,7014601,7014602,7014603,7014604,7014605,7014606,7014607,7014608,7014609,7014610,7014611,7014612,7014613,7014614,7014615,7014616,7014617,7014618,7014619,7014620,7014621,7014622,7014623,7014624,7014625,7014626,7014627,7014628,7014629,7014630,7014631,9169028,9169111,6673330,10117323,6670687,6670853,8550055,8550057,8550058,8550068,8550105,9175035,8550207,8550208,9175455,9175457,9175458,10115982,10115983,10115984,10115985,10115986,10115987,10115988,10115989,10468510,10468511,10468513,10468514,10468515,10468516,10468517,9168026,10116224,10116225,10116226,10116227,10116228,10116229,10116230,10116236,10468839,10468843,10468846,10468849,9168291,10888607,10888614,10888615,10888624,10888625,10888626,10888627,10888628,10888629,10888630,10883945,10889017,10889018,10884259,10884495,10884531,10884653,10889673,10889844,10170923,10170924,10889924,10889925,10889926,10889927,10889928,10889929,10889930,10874992,10875004,10875005,10875006,10875007,10875008,10875009,10875010,10875011,10875012,10875014,10875015,10875016,10875017,10875018,10875019,10875020,10875021,10875022,10875023,10875024,10875025,10875026,10875027,10875032,10875033,10875034,10875035,10875036,10875037,10875038,10875039,10875040,10875041,10875042,10875043,10875044,10875045,10875046,10875047,10875048,10875057,10890073,10885203,10885370,10885374,10885376,10885377,10885400,10885405,10885419,10885420,10885445,10885446,10885464,10885465,10885466,10885467,10885468,10885469,10877480,10877481,10877482,10877483,10877484,10877485,10877579,10882686,10882687,10887861,10882884,10882998,10888289,10888327,10888443,10885516,10885526,10885527,10885644,10162026,10162028,10886081,10876480,10876593,10876600,10887183,10887357,10601145,10601156,10601160,10601163,10601166,10580339,10580340,10647511,10647625,10533112,10533113,10533121,10533122,10533125,10533126,10539129,10537408,10537409,10537410,10537411,10537425,10537427,10537428,10537431,10537432,10537433,10537434,10537435,10537436,10537437,10537438,10537439,10537440,10537441,10537442,10537443,10537444,10537445,10537446,10537447,10537448,10537449,10537450,10537451,10537452,10537453,10537454,10537455,10537456,10537457,10537458,10537459,10537460,10537461,10537462,10537463,10537464,10537465,10537466,10537467,10537468,10537469,10537470,10537471,10537472,10537473,10537474,10537572,10537573,10537574,10521840,10521841,10521842,10521843,10534188,10534189,10534190,10534191,10534192,10534193,10534194,10534201,10534203,10538309,10544310,10538311,10538315,10538317,10538318,10538319,10538320,10538321,10538322,10538323,10538324,10538325,10538326,10538334,10538335,10538336,10538337,10534388,10538405,10538406,10538408,10538409,10538410,10538411,10538412,10538415,10538422,10538423,10538424,10538425,10538463,10538468,10538469,10538470,10538477,10538487,10538489,10538497,10538498,10538499,10538500,10538501,10538502,10538503,10538504,10538505,10538506,10538507,10538508,10538510,10538511,10538512,10538513,10538514,10538515,10538516,10538517,10538518,10538519,10538520,10538521,10538522,10536577,10538725,10538726,10538727,10536749,10536750,10536751,10536752,10527002,10533105,10533111,10421509,10421545,10421548,10505529,10407448,10407603,10407604,10407605,10407606,10407607,10407608,10407609,10407610,10407611,10407612,10488267,10407613,10488268,10407614,10488269,10407615,10488270,10407616,10488271,10407617,10488272,10407618,10488273,10407619,10488274,10407620,10488275,10407621,10488276,10407622,10488277,10488278,10407623,10407624,10407625,10407626,10407627,10407628,10407629,10407630,10407631,10407632,10407633,10407634,10407635,10407636,10407637,10407638,10407639,10407640,10407641,10407642,10407643,10407644,10407645,10407646,10407647,10407648,10407649,10407650,10407651,10407652,10407653,10407654,10407655,10407080) 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'