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,10939589,10939590,10939591,11001668,11001669,11001676,10939811,7076337,7076339,7076341,7076342,7076344,7076345,7076349,7076350,7076353,7068361,7076366,10940163,10940171,10963415,7068744,7068762,7068763,7068764,7068876,10977182,10977187,10977189,10977217,10977248,10977252,10977300,10977301,10977305,10977306,10977307,10977308,10977309,10977310,10977311,10977312,10977313,10977314,10977315,10977316,10977317,10977352,10977353,10977354,10977355,10977356,10977357,10977358,10977359,10977360,10977361,10977362,10977363,10977364,10977365,10977366,10977367,10977368,10977369,10977370,10977371,10977372,10977373,10977374,10977375,10977376,10977377,10977378,10977379,10977380,10977381,10977418,10977423,10977424,11000687,11000694,11000744,11000778,7075170,8068065,10961923,10961924,10961926,10961932,10961934,10961936,10961937,10961938,10961939,10961940,10961942,10961951,10961952,10961953,11001153,7075475,11001201,11001202,11001203,11001204,11001205,11001206,11001207,11001208,10975351,7067698,10962421,10962422,10962428,10962474,11001483,10939456,7075873,10962568,10972657,10972658,10972659,10972660,10972661,10972662,10972663,10972664,10972665,10972666,10972667,10972668,10972669,10972670,10972671,10972672,10972673,11011743,10985948,10985949,10985951,10985952,10985953,10985954,10985955,7072300,10973060,10999061,10973061,10973062,10973065,10973067,10973068,10973070,10973071,10999087,10973180,10973181,10999350,10960424,7072797,7072806,7072824,10932194,7072848,10932196,10999609,10999610,10999611,10999612,10999613,10999614,10999615,10999616,10999617,10999618,10999619,10999620,10999621,10999622,10999623,10999624,10999625,10999626,10999627,10999628,7073065,7073066,7073072,7073091,11012790,11012791,11012792,11012793,7065119,10960823,10960826,7073163,7073226,8066295,11000120,11000215,7073780,4968029,7071003,7071025,11010709,11010726,11010736,11010742,11010743,11010744,7071245,7071246,11010969,10972016,10972048,10972180,10972287,10972288,10972289,11049536,11049546,11049547,10998422,10998423,10998424,10998425,10998426,10998427,10998430,10943380,10943381,10943385,10943389,10943391,10943392,10943393,10943394,10943395,10972456,10943401,10998463,10998464,10998465,10943404,10998466,10998467,10998468,10943408,10943415,10998516,10998517,10998518,10998520,10998521,10998522,10998523,10998524,10998525,10998526,10998527,10940687,10940691,10982837,10996177,7069643,10941407,3656366,3656654,3656655,11009820,10942031,10942032,11048363,11048364,10971184,10984198,11010342,11010447,10971616,10971617,10971618,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,11006660,11006661,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,10928610,10928618,10928626,10928650,10618146,10623185,10623186,10623187,10623188,10623189,10623191,10623192,10623193,10623194,10623195,10623196,10623197,10967860,10967861,10623205,10618219,10618294,10618295,10618296,10618297,10618305,10618306,10928816,10618307,10618308,10618309,10618310,10618311,10618312,10618313,10618314,10618315,10618316,10618317,10968010,10623653,10981584,10619894,10995565,10995585,10995591,10617141,10954250,10993403,10993404,10993405,10967477,8569913,10920475,10920476,10920477,10920478,10920479,10920480,10915616,10915617,10620123,10977786,10977787,10977788,10977794,10977795,10977796,10977807,10977808,10977809,10977810,10977811,10977812,10977813,10977814,10977815,10920693,10920694,10920695,10920696,10920698,10920699,10920701,10920703,10920704,10920706,10920708,10920710,10920711,10920713,10920714,10920718,10920720,10920723,10920724,10920725,10920726,10920727,10920728,10920729,10920731,10620383,10620384,10620385,10620386,10620387,10620414,10915930,10915931,10915932,10915961,10921054,10921055,10921078,10921079,10921080,8570521,10921081,8570522,10921082,8570523,10921165,10921166,10921167,10921168,10921169,10930646,10926255,10978433,10978434,10978435,10978436,10978437,10978438,10965457,10978606,10978611,10978612,10978613,10978614,10921527,10921530,10916877,10922027,10927066,10992305,10992315,10992316,10966360,10966364,10992398,10992411,7059604,7059854,7059855,7059856,7059857,7059858,7059859,7059860,7059861,7059862,10562551,10559708,9173907,10565891,10565959,10614952,10612091,10612092,7057754,7057761,9171658,10557475,10557476,10557477,10557479,10557480,10557483,10557484,10557490,10557492,10557494,10557497,10557498,10612408,10612409,10612410,10563564,10563565,10563566,7057947,9171825,9171853,10557719,10557720,7058109,7058110,9172041,7058256,10563948,10563950,10563971,10563990,10564001,10564002,10564003,10564005,10564006,10564007,10564012,7058374,10564024,9172212,10564026,9172214,10564027,9172215,9172216,10564030,9172218,10564031,9172219,10564035,9172223,10564037,10564046,10612899,9172252,10564074,10564081,10564084,10564091,10564092,10564095,10564096,10564097,10564105,10564106,10564107,10564108,10564109,10564112,10564113,10564121,10613074,10613110,10613114,10613163,9172679,10610408,9172884,8863458,8863496,9173055,10558948,10558949,10558950,10558954,10515133,10513227,10513228,10513229,10513230,10513231,10513232,10511234,10511281,10511282,10511301,10511333,10511353,10511354,10513354,10511355,10513367,10511388,10511389,10511390,10515439,10511454,10511460,10511461,10511519,10511609,10517614,10517615,10517616,10515631,10515632,10517673,10517674,10517675,7056170,9170049,9170092,10511922,9170175,9170176,7056386,7056387,7056413,9170248,7056414,7056415,7056416,9170253,9170254,9170292,9170305,10514145,10514146,10514162,10514163,10514182,10516195,10516197,10516203,10516205,10516210,10516211,10514215,10514216,10514217,10516242,10514243,10514492,10514494,10514495,10514496,10514500,10514502,10514503,10514504,10514508,10514509,10514511,10514512,10514513,10514517,10516518,10514518,10514519,10514520,10514521,10514528,10514530,10514532,10514533,10514534,10514535,10514536,10516539,10514541,10514542,10514543,10514545,10514547,10514549,10514550,10514551,10514552,10514553,10514558,10514560,9170749,10514566,7056937,7056938,10514621,10514632,10514633,10514634,10514635,10556646,10556656,10556658,10516659,10556673,10556684,10556695,10556698,10556702,10556704,10556705,10514705,10556709,10556715,10556724,10514742,10556755,10556759,10556761,10556768,10514769,10556773,10556774,10556781,10556783,10556795,10556809,10556816,10556818,10556819,10556820,10556834,10556841,10556845,10556850,10556867,10556886,10514886,10556887,10514887,10514888,10514889,10556891,10556899,10556904,9171124,10416224,10416225,10418232,10418235,9160320,10416260,10416261,9168353,10416403,8918219,8918220,9168752,7054934,9168775,10416814,10416815,10415822,10416863,10416864,10416865,9169275,10467108,10467109,10467110,10467114,10467115,10467116,10467117,10467120,10467123,10467124,10467130,10467131,10467132,10467133,10467145,10469288,10463396,10463397,10463398,10463431,10463432,10463439,4971938,4971939,4971941,4971964,4971965,4971966,4971967,4971977,10469915,10463996,8917388,10468334,10470351,10470352,10468357,10470647,9168070,9168077,6668238,10628290,10628646,10632245,10632246,10632247,10627680,10631015,10631016,10631017,10162602,10162603,10162604,10162606,10162610,10162611,10162612,10162613,10162615,10162616,10162618,10162619,10162621,10162626,10162628,10162629,10162631,10162634,10162635,10162636,10162638,10162642,10162645,10162649,10162650,10162651,10162652,10162733,10162738,10162739,10162743,10162745,10162746,10162771,10162772,10162777,10162778,10162780,10162781,10162782,10162791,10162792,10162793,10162796,10162798,10162800,10162803,10162804,10162805,10162806,10162812,10162813,10162814,10162816,10631296,10162819,10162823,10162824,10162825,10162826,10162829,10162832,10162836,10162840,10626641,10574397,10572195,10569552,10569563,10569564,10569565,10566666,10566667,10566669,10575763,10575764,10572867,10572868,10572869,10572870,10569912,10569913,10567330,10570450,10567463,10573718,10573720,10573721,10570974,10570975,10521148,10523257,10521281,10521282,10521283,10521284,10521288,10523482,10523483,10523485,10523491,10523510,10521594,10523655,10523657,10523662,10523667,10523672,10523692,10523693,10523694,10523695,10523696,10519796,10519811,10519816,10519828,10519838,10519840,10519844,10522023,10524189,10524243,10524387,10524389,10524518,10524526,10522532,10524534,10522624,10522639,10522643,10522648,10524721,10524725,10522726,10524734,10524735,10524738,10524740,10524745,10524757,10520771,10520868,10423228,10420400,10420653,10420852,10423025,10423026,10421087,10423143,10479777,10478049) 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'