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(11001620,11014781,11014782,11014783,7068138,8838685,8838686,8838698,8838699,11002019,11002020,11002021,11002022,11002023,11002024,11002025,7076353,10939989,10963432,10963433,11002456,11002457,11002458,11002459,11002594,11002595,7074112,7074113,8067204,8067205,11002913,11002914,7074252,11003014,11003118,11003119,11003120,11042332,11042333,11042334,11003348,11042361,11003482,11003483,11003589,11029589,11003590,11029590,11029591,11029592,11016593,11029593,7074910,11016594,11029594,11029595,11016595,11016596,11029596,11016597,11029597,11029598,11029599,11029600,11029601,11029602,11029603,11029604,11029605,11029606,11029607,11029608,11029609,7074988,7074989,11013702,11013703,10961749,10961750,10961751,8837625,8837701,11013933,11013934,11013935,11013936,11013937,11013938,11013939,11013940,11013941,11013942,8837757,10988059,11040108,11040109,11040118,11040176,7075499,11014219,11014220,11014221,11014222,11014223,11027258,11027259,11027260,11027261,11027262,11027263,11027264,11027265,11027266,11027267,11027268,11027269,11027270,11027271,11001495,11001496,11024718,11024719,11024720,10972720,11024721,11024722,11024723,11024724,11024725,11024726,11024727,11024728,11024729,11024730,11024731,11024732,11024733,11024734,11024735,11024736,11024737,10972852,7072194,10972947,10986125,11012184,10973189,8836035,8065537,7072594,7072605,7072606,10999337,10999338,10999339,11012446,11012447,11012448,11012449,11012450,8836288,7072805,7072806,7072857,7072900,7072901,8836439,7073015,8065996,8066072,11012860,11012861,8836729,8836730,11012930,10961072,10961073,10961074,10961079,10961080,10961081,10961110,10961291,10961292,10961293,10961294,10961295,10961391,10961392,10961393,11013446,10961486,11013613,11023656,11023657,11023658,11023659,11023660,11023661,11010736,11010739,11023810,11023811,11023812,11023813,11010953,11010954,7071704,10943418,11021647,11021648,11021649,11021650,11021651,11021652,11021653,11021654,11021655,11034758,11034759,11034760,11034843,11034899,10969999,11035021,11035064,11035065,10996189,10996190,10996191,10996192,11035218,11035219,10996266,10996267,10996268,10996316,3656230,11035355,11035356,11035357,11035358,10970388,10970389,10970390,10970391,11022495,11022496,11022497,11022498,10970712,10970713,10970714,11035721,11035722,7070078,11035821,11035822,11035823,3656722,10997067,10997068,10971086,11023107,11023108,10997195,10997196,10997197,11023280,10997371,10997372,10971408,10942459,11023575,11006620,11006621,11006622,11006623,11006624,11006625,11006626,11006627,11006628,11006629,11006630,11006631,11006632,11006633,11006634,11006635,11006636,11006637,11006638,11006639,11006640,11006641,11006642,11006643,11006644,11006645,11006646,11006647,11006648,11006649,11006650,11006651,11006652,11006653,11006654,11006655,11006656,11006657,11006658,11006659,10918511,10918512,11006660,10918513,11006661,10918514,11006662,11006663,11006664,11006665,11006666,11006667,11006668,11006669,11006670,11006671,11006672,11006673,11006674,11006675,11006676,11006677,11006678,11006679,11006680,11006681,11006682,11006683,11006684,11006685,11006686,11006687,11006688,11006689,11006690,11006691,11006692,11006693,11006694,11006695,11006696,11006697,11006698,11006699,11006700,11006701,11006702,11006703,11006704,11006705,11006706,11006707,11006708,11006709,11006710,11006711,11006712,11006713,11006714,11006715,11006716,11006717,11006718,10918611,11019809,11019810,10918700,11019912,11019913,11019914,11019915,11019916,11019917,10918850,10918851,10918857,10918858,10918859,10918860,10918861,10918862,10918863,10918864,10918865,10918866,11033065,10623493,10994380,10919252,10919253,10919254,10919255,10919256,10919257,11033591,11033592,11033593,10968609,10919513,10994674,10994675,10994676,10994677,11020685,10619033,10619034,10619035,10619036,10619037,10619038,10619039,10619040,10919574,10919575,10919576,10919577,10919578,10919579,11033728,10919580,11033729,10919581,11033730,10919582,10919583,10919584,10919585,10968798,10994821,10994822,10919846,10969108,10969109,10969110,10969111,10969112,10969113,10969114,10969115,10969116,10969117,10969118,10969119,10969120,10969121,10969122,10969123,10969124,10969125,11034195,11034196,10920110,11034354,11034355,11034356,11034411,11034412,11034413,10917487,10917488,10617044,11005750,10617125,11018826,11018827,11018828,11032025,11032026,11032027,10918025,10918026,11006213,11006214,10918155,10918156,11032398,11032404,11032405,11019437,11019438,11006606,11006607,11006608,11006609,11006610,11006611,11006612,11006613,11006614,11006615,11006616,11006617,11006618,11006619,11003674,10920559,8570022,11003785,10920653,10920654,10920655,11003835,10920876,11004051,11004052,11004053,10920982,10921054,10921055,10921078,10921079,10921080,10921081,10921082,10965291,11004469,10615829,10620863,11004530,11004531,10615878,10965660,10965661,10965662,10965663,11004679,11004680,10921571,10921572,11030768,11004792,10921676,10965883,10965884,10921737,10921738,10921755,10921756,10921757,11030907,11030908,11030909,11030910,11030911,11030912,11030913,11030914,11030915,10917070,11005223,11005224,10966313,11031450,11031451,11031452,11005545,11005546,10559392,9190002,9174131,9166142,9166143,9166147,9166148,9190151,9190184,9195437,9195438,9187482,10612194,9195627,9195628,9195629,9195630,9195709,9195710,9187794,9187795,9187797,10609594,9187985,10609681,9196035,10612745,9188122,7058290,9188125,9196161,9196162,9196163,9188258,10612937,10612938,10613083,10613110,7058719,7058720,7058721,7058725,9196767,10558613,9172965,10610727,10610769,9189135,8863804,9193371,9193385,9193386,9193444,9193544,10555359,10555360,10555361,10555362,10555363,10555364,7055760,9193606,10555430,10555431,10555432,10555433,10555434,10555435,9193708,7055889,9193739,4974650,4974651,4974652,7056109,10515823,9194052,9194053,9194054,9194055,9194090,9194091,9194092,10513953,10516059,10516060,9194476,10556295,10556296,10556297,9194594,9194595,9194596,9170633,9170634,9186816,9194847,9194848,9194849,9194850,9194851,9194852,9194853,9194854,9194855,9194856,10556705,9171025,9171026,10517001,10517002,9160373,9176466,9184516,10419458,9184555,9176603,9176604,9176605,9176619,9176692,9176711,9176892,9177207,6666463,4971338,10471181,10463429,10463430,10463431,10463432,10463433,10463434,10463435,10463436,10463437,10463438,10463439,10467439,6666974,10469590,10469605,9191251,9191252,9191253,9191254,9191255,9175326,9175354,10469984,10469985,9175618,9175619,10470382,9175827,10470486,10470491,6667978,10164507,10164508,10164509,10164510,10164511,10164512,10164513,10164514,10164515,10174875,10174876,10174877,10174878,10174879,10174880,10174881,10174882,10174883,10174884,10174885,10179886,10174886,10174887,10174888,10174889,10174890,10174891,10174892,10174893,10174894,10174895,10174896,10179959,10179988,10179989,10165007,10180048,10180049,10165057,10180127,10180128,10180129,10165200,10165201,10165202,10165203,10165204,10180538,10180539,10180540,10180541,10180542,10165554,10165555,10165690,10165858,10170868,10180879,10180880,10180881,10180882,10180926,10180927,10180928,10629581,10629609,10181169,10181210,10181211,10181212,10629690,10181213,10181430,10181431,10629914,10629915,10629916,10629917,10181473,10181474,10168767,10168768,10168769,10168770,10163801,10627294,10163969,10164235,10174448,10166858,10166979,10166980,10166981,10167005,10167084,10167281,10167308,10172313,10172314,10177433,10177438,10162543,10626111,10172868,10172869,10172899,10177973,10177978,10177979,10177980,10177981,10163275,10571418,10577444,10574625,10586626,10574626,10568637,10568638,10568639,10580672,10580673,10571732,10571733,10574759,10574793,10574816,10574817,10574818,10574819,10571821,10571822,10571823,10571824,10571825,10571826,10577852,10577853,10577854,10577855,10577856,10577857,10577858,10577859,10577860,10577861,10577862,10578065,10578066,10578067,10578068,10584107,10584108,10584109,10584110,10575120,10575164,10575165,10575166,10572266,10572267,10572268,10572269,10572270,10572271,10572272,10572273,10572306,10575368,10575422,10575423,10575424,10575425,10575426,10575427,10575428,10575429,10575430,10575431,10578436,10578437,10578438,10569500,10569501,10566534,10566535,10572537,10569539,10569540,10569541,10569542,10575548,10575549,10575550,10575551,10584565,10575757,10575827,10581883,10569886,10569887,10569888,10584918,10584919,10584920,10573012,10570084,10570085,10579089,10579090,10579091,10579092,10579093,10579094,10579095,10579096,10570103,10576174,10570288,10579433,10570557,10570558,10570559,10570560,10579601,10579602,10573686,10573687,10571082,10571083,10521268,10525326,10529679,10529680,10529681,10522036,10522037,10528564,10528565,10528566,10522624,10528696,10526903,10526904,10526905,10526906,10526907,10526908,10526909,10526935,10526936,10527094,10527095,10527096,10529099,10420399,10477276,10477277,10477325,10477388,10473612,10477955,10477956,10478120,10478121,10480153,10480154,10480155,10476298,10478555,10476604) 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'