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(7076188,7076190,7076200,7076207,7076208,10943681,4970668,8569548,8569560,8569626,8569627,8569628,8569629,8569636,10963720,10963721,10963735,7066139,7074237,7074238,7074353,7074354,7074357,7074358,10437497,10437498,10437502,10437513,10437514,10437515,10437516,10437517,10437520,10437523,10437525,10964361,10964362,10437577,10437578,10437579,10437580,10964467,10964468,7067047,7067048,7067049,7067051,11001090,11001091,7075438,7075439,7067461,10939174,7067793,7075931,7072147,7072156,10931539,10960132,10960133,10960134,10960135,10960136,10960137,10960138,10960156,10931927,8065654,8065659,8065664,10960386,10960387,10960388,10960391,10960392,10960393,10960394,10960395,10960396,10932148,10999520,7073125,7073161,7073238,10932647,10932650,10932656,10932699,10932700,10932703,10932704,10932716,10932717,7073370,10932718,10932720,10932723,7073424,7073560,7073589,7073593,7073667,10933058,10933065,10942580,10942612,10942613,10942617,10997708,10997709,11048971,11048993,10942781,11049086,10997875,10997876,10958960,11049228,11049229,11049230,11049231,11049246,7071407,7071411,7071414,7071419,7071421,7071425,7071431,7071441,7071443,7071450,7071456,7071459,10943338,8064863,10995917,10995918,10995923,10995924,10995925,10995926,10995927,10995928,10995930,10995931,10995952,3655843,3655844,3655845,3655846,3655847,3655848,10995963,10995964,10995966,3655853,3655854,10995971,10995972,10995973,3655864,3655865,3655866,3655867,3655868,3655869,3655870,3655871,3655872,3655873,3655878,3655892,3655897,10996185,10996217,10944959,3656125,10996245,10996304,10996305,8073104,8073105,8073106,8073111,8073112,8073119,8073120,8073132,8073133,8073134,8073135,8073136,8073147,8073148,8073149,8073155,8073156,8073163,8073164,8073175,8073176,8073177,8073178,8073179,8073180,8073181,8073187,8073188,8073189,8073194,8073195,8073202,8073203,8073213,8073214,8073215,8073226,8073227,8073228,10942119,10942120,8073233,8073234,8073242,8073243,8073259,8073260,8073261,8073262,11048433,8073272,8073273,8073278,8073279,8073285,8073286,8073296,8073297,8073307,8073308,8073310,8073315,8073316,8073323,11048490,8073324,8073338,8073339,8073340,7070729,10942524,10954892,10618265,10618266,10618270,10618325,10955011,10618364,10968557,8070774,10624203,8071269,8071270,10624579,10624703,10624736,10619835,10619873,10995535,10617142,10617151,10617199,10617211,10966878,10966879,10966880,10617252,10617253,10617263,10617281,10992957,10617332,10954017,10954018,10927889,10617489,10993174,10928080,10928081,10928082,10617626,10928185,10622824,10615105,10615107,10615109,10615113,10615114,10615116,10925627,10925630,10925631,10925634,10925685,10615337,10615398,10925951,8570404,10615467,10615470,8570485,8570493,8570514,10615578,10620643,10620644,10615713,10615720,10991530,10991542,10991543,10615936,10615969,10616049,10616052,10926627,10926628,10926629,10926630,10926631,10926633,10952829,10952830,10952831,10621419,10922010,10922011,10922012,10922013,10992176,10616540,10922066,10616573,10616575,10927091,10953469,10953470,10953471,10992607,10613964,10565125,10565126,10610986,10613994,7059532,10614030,10614031,7059537,10614072,10611095,10611123,10559291,7059748,7059749,9165616,7059858,10611389,9173777,9173788,10614530,10614535,10614536,10559702,10559704,10559705,10559706,10559709,10559710,10559711,10559712,10559715,10559716,10559717,10559718,10559719,10559720,10559721,10559722,10559723,10559724,10559725,10559726,10559727,10559728,10559729,10559735,10559736,10559737,10559738,10559739,10559740,10559741,10559742,10559743,10559744,10559745,10559746,10559747,10559748,10559749,10559750,10611600,10559751,10559752,10559753,10559754,8864471,10559802,10559803,9165991,10611667,10559831,10559832,10559833,10611688,8864548,10559850,10559851,10559852,10559853,10559854,9166044,9166045,10559859,9166046,9166047,10559860,10559861,9166049,8864573,10559873,10559904,10559911,10559912,10559913,10559914,10559915,10559918,10559919,10559920,10611780,10560000,10560001,10560002,10560003,10560004,10614858,10614859,10560060,10560061,10560062,10560063,10560064,10560065,10560066,10560067,10560068,10560069,10560070,9174257,10560071,10560072,10560073,10560074,10560075,10560076,10560077,10560078,10560079,10560080,10560081,10560082,10560083,10560084,10560085,10560086,10560087,10560088,10560091,10560109,10560110,10560111,10560112,10560113,10560114,10560115,10608966,10560119,10560120,10560121,10560122,10560123,10560124,10560125,7057479,10560126,10560127,10560128,7057482,10560129,10560130,10560131,10560132,10560133,7057487,10560134,10560135,10560136,10560137,10560138,10560139,7057493,10560140,10560141,10560142,10560143,10560161,10560162,10560163,10560164,10560165,10560166,10560167,10560168,10560169,10560170,10560171,10560172,10560173,10612074,7057588,10612087,10560258,10560259,10560260,10612133,10560298,10560299,10560300,10560301,10560319,10560320,10560332,10560333,10563347,10563348,10560371,10560372,10609223,10560373,10560374,10560376,10560380,10560381,10560382,10560383,10560387,10560388,10612267,10612279,10612280,10560434,10612290,10560472,10609341,10563491,10609342,10609346,10612353,10563522,9171720,10609390,10612408,10612409,10612410,10612411,9163801,10612493,10612538,9163909,9171957,10612644,10557821,10609725,10560886,10609772,9164175,10612839,10612853,10612883,10612886,10609889,7058411,7058454,10613034,10613039,10613081,9172469,10613141,10613158,10613159,9172497,10613160,10613166,10610167,10610168,10613216,9172558,10613260,10558450,10558451,10613329,10610358,10610362,9164725,10561552,10558558,10558559,10558560,10558561,10564609,10564610,10564611,10564612,10564613,10564623,10564625,10564626,8863341,10564660,10564663,10564665,10564666,10564667,10564668,10564669,10564675,10564676,10564677,10564678,10564679,10564681,10564694,10564725,10613643,10610678,10564832,10564835,10564836,10564842,10564844,10564846,10564853,10564854,10564860,10564861,10564863,10564864,10564873,10564882,10564899,10564900,10564901,10564910,10564926,10564936,10564937,10564938,10564939,10564940,10564941,10564943,10564958,10613825,10564983,10564984,10564985,10564986,10564987,10564992,10564993,10610904,10610905,9169300,9169444,10515308,7055820,9169752,9161857,7056039,10515781,10515782,10515783,9169976,9169977,9169983,10515926,10515927,10515928,10515929,10515930,10515931,10515932,10515933,10515934,10515935,10515936,10515937,10515938,10515939,10515940,10515941,10515942,10515943,10515944,10515945,10515946,10515947,10515948,10515949,9170178,9162348,9162354,2809156,10514486,10512661,10512662,10512753,9171087,10516919,10516920,7057462,10419233,10417293,10417294,10417295,9168386,10416323,10416324,10416329,4973262,4973263,8918070,10418370,10418371,10418375,10416375,10416376,10416377,10416378,10418379,10416379,10416380,10419386,10415388,10418398,10418399,10418402,10417410,10417411,10417412,10417417,10417418,10417419,4973355,10419428,10419429,4973366,4973376,4973377,10416446,4973378,10419451,10418481,9168564,10415503,10415504,9160589,10415511,10419555,10419656,10419657,10419658,10419659,10419660,9168863,7055062,7055067,9168910,7055081,4973773,7055087,4973794,4973795,10418885,10415888,9168972,9168973,10418896,9168976,10418898,10418901,10418903,10418916,7055186,4973951,4973955,4973958,10416189,8864839,10469130,9166848,6666920,10463627,10463630,10465670,8916787,8916788,8916789,8916790,8916791,9167159,8916823,8916826,8916828,6667230,10465967,10465968,6667435,6667438,6667456,6667457,9167526,9167625,4972554,10462307,10468310,8917501,10464432,6667902,8917652,8917656,8917657,8917658,8917659,8917660,8917661,8917666,8917667,8917668,8917669,8917673,8917674,10468621,10464672,10464715,10464720,10464732,10464733,8917806,8917807,6668195,6668213,10159945,10628479,10628599,10628600,10628601,10628602,10628603,10628607,10628658,10628659,10628660,10628663,10628683,10628746,10628751,10628754,10628755,10628760,10628765,10628771,10628780,10628785,10628815,10629006,10629007,10629008,10156155,10156156,10632120,10627328,10627329,10627711,10627729,10627910,10630025,10630100,10630246,10630261,10630262,10630263,10625651,10631055,10626508,10158052,10626756,10626768,10626769,10626783,10568392,10568501,10567169,10567170,10567171,10567172,10567173,10567174,10567175,10567176,10567177,10567178,10567179,10567180,10567181,10567182,10567183,10567184,10567185,10567186,10567187,10567188,10567189,10567190,10567191,10567192,10567203,10567204,10567318,10567319,10567320,10567321,10567322,10567323,10567324,10567325,10567326,10567327,10567328,10521287,10522195,10522531,10524881,10524882,10524883,10524884,10524885,10524886,10524887,10524888,10524889,10524890,10524891,10522891,10524892,10520958,10520959,10520960,10520961,10520962,10520963,10520964,10520965,10525006,10421401,10421402,10421403,10421404,10421405,10421214,10477181,10473372,10477454,10477455,10477459,10473565,10472735,10476853) 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'