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(10447778,10447794,10447801,10447803,7076128,7076287,8574466,8574467,8574468,7076292,8574473,8574475,8574478,8574495,8574498,11041454,4971143,10933336,7065936,4968330,4968331,4968332,4968333,4968334,4968335,4968336,4968337,4968338,4968339,10950659,10950673,10950773,10951115,10951125,8575733,8622471,10951337,10951338,8573336,7067302,10102995,10959556,10959559,10959560,10959561,10959562,10959563,10959567,10103481,8911496,7064652,8911755,10103986,10932350,10960858,10999972,11010507,10984556,10984557,10984558,10984559,10997566,10984597,10984598,10984599,10984600,10984601,10984602,10102114,10102115,10997842,10997846,10958957,10958958,8910452,10959087,10985141,11047501,11047502,8907880,10995579,8907961,10995711,10995716,10995720,8615017,10940929,8908289,8908290,8908503,8908518,11009405,11009407,11009408,11009409,11009410,11009411,10996416,10941757,10941763,10941773,10941782,3656993,8612652,10928556,10623065,10954692,10954693,10954694,11045728,11045729,10618265,10618266,10618267,10618268,10618269,10618292,10618294,10618295,10618296,10618297,10618305,10618306,10618307,10618308,10618309,10618310,10618311,10618312,10618313,10618314,10618315,10618316,10618317,10618318,10618319,10618320,10618321,10618322,10618323,10618324,8613073,8613074,10954938,11045994,11046099,11046102,11046107,11007150,10994159,8906887,10968571,10968572,10968573,10968574,11046617,11046618,8907034,8907048,11007719,11007720,11007721,11007722,11007723,11007724,11007725,11007726,11007727,11046768,10619384,10619385,10619386,11046948,11047031,11047032,11047141,11047142,11008157,11008159,11008160,11008161,11047268,11047364,11047365,10995382,10619865,10619885,11047471,11047472,11047473,11047474,11047475,11047476,11047492,11044572,10992578,11044803,10617343,10617347,10617353,10617354,10622405,10617426,10617452,10617457,10617458,10927986,10993200,8612408,10622818,10622819,10622820,10993403,10993404,10993405,10993416,10614998,10990543,10990544,10990545,10990548,10990549,10990550,10990551,10990552,10990553,10990554,10990619,10990623,10951575,10951590,10951625,10951667,10951668,10620202,10615222,10990791,10990793,10990794,10990795,10990796,10990797,10990798,10990799,10990807,10990808,10990809,10615352,8576394,11043196,10991258,10991259,10991260,10991261,10991262,10991263,10991264,10991265,10991272,10991273,10991274,10991275,10991276,10991277,10991279,10991280,10991281,10991282,10991283,10991284,10991285,10991286,10991291,10991292,10991293,10991294,10991295,10991296,10991297,10991298,10991392,10930720,10930731,10991493,10991499,10991500,10930777,10616044,10616045,10991589,10991605,10991733,10991734,10952691,10952692,10991753,10991754,10991767,10991768,10991769,10991770,10991771,10616295,10616298,8904273,8904285,10991935,10991956,10991957,10991958,10991967,10991970,8904405,8611260,8611455,10610964,7059524,9189360,9189363,9189364,10562230,10562231,9213505,10559321,10559322,10614203,10714024,7059718,7059719,7059855,7059859,10611362,9173723,9173724,9197737,9197738,10611455,10559622,10559626,10559627,10614495,10614496,9173875,9181891,10559706,10559722,10559723,10559724,10559725,10559726,10559744,9173980,9214038,10611830,10611832,10611833,9214180,9214198,9174283,9174284,10611952,10611957,10612050,9211565,9211566,8862099,9211649,9211650,10609355,10609369,9211815,9211824,8862558,7058374,7058375,7058377,10609913,9212322,10610015,10613018,9196371,10558297,7058687,7058800,7058801,10613369,7018489,9172840,9172859,9172860,7018578,7018579,7018580,7018581,7018582,7018583,7018584,7018585,7018586,7018587,7018588,7018589,7018590,7018591,7018592,7018593,7018594,9189077,9197096,9197097,9197098,9197101,9197102,9197103,9197106,10613875,10613876,10613877,10610954,10513118,10513119,9161492,9209501,10515327,10515328,10515329,10513386,9185606,9185607,9185609,9185630,7055824,9185737,9185738,9185744,9169748,9185795,9185856,10517670,9185857,9185866,9185879,9185896,9185897,9185909,9169935,9169939,9169940,9185944,9185945,9185946,9186050,10516123,10516124,10516125,10516126,10516127,9186357,10516193,9178716,9178723,9178733,9186771,9178778,9178789,9178794,9186800,9186804,10512782,10516928,9211250,4973195,10419307,9176407,10415342,9176428,9176429,10416368,10416387,9192468,10416432,10416433,10419454,10419455,10419477,10419478,10419479,10419501,10419502,10419503,10419504,10419505,10419506,10419507,10419508,10419509,10419510,10419511,10419512,10419513,10419514,10419515,10419516,10419517,10419518,10419519,10419520,10419521,10419522,10419523,10419568,9168728,9168752,10415685,10418819,10419829,10419831,10419832,10419833,10419894,10419904,9169001,9177036,9209094,10420039,9193119,10420056,10420058,10420059,10417061,10417062,10417063,10417064,10417065,10417066,10417097,10417099,9193180,9193181,10417107,10419108,10419111,10417111,10417119,10417121,10417129,10417150,10417152,10417154,10417156,10417160,9169275,8549455,7020002,7020003,7020004,7020005,7020006,7020007,7020008,7020009,7020010,7020011,7020012,7020013,7020014,7020015,10463023,10463031,10463053,10463054,10463055,10463056,10463059,10467108,10467109,10467110,10467115,10467120,10467123,10467124,10467130,10467131,10467145,10467151,10467155,10467159,9190692,10469289,8549884,8549888,8549894,8549957,10463396,10463398,10467431,10467435,10467438,10463439,10467456,10467460,7020538,10467461,7020539,7020540,7020541,7020542,7020543,7020544,7020545,7020546,7020547,7020548,7020549,8550100,10469573,7020668,9199042,9199043,7020761,7020762,7020763,7020764,7020765,7020766,7020767,7020768,7020769,7020770,7020771,7020772,7020773,7020774,10465697,7020807,7020808,7020809,10463732,7020810,7020811,7020812,7020813,7020814,7020815,7020816,10463742,10463752,10463758,10463769,10465783,10463791,10465794,10465799,10463802,9175225,10463803,10463810,10463811,10463812,10463813,10465816,10465817,10465818,10463819,10463820,10465820,10465821,10463823,10465823,10465828,10465832,10465833,10465834,10465837,10465887,10465895,10465896,10465911,9207335,10465914,10463919,10463920,10469949,10464042,10464046,8550648,8550696,10466319,10466321,10466322,10466325,10466327,10466341,10466342,10466345,10466355,10466356,10466366,10466367,10466375,10466379,10462416,10462417,10462418,10468420,10466426,10466432,10462432,10462433,10466433,10462434,10462435,10462437,10466439,10466440,10466442,10466444,10462458,10462462,10462463,10462501,10462502,10462519,10462529,10462544,10464581,9192026,6668125,9192208,9176234,10466858,10946563,10628321,8594165,10171195,10171196,10171197,10163491,10163492,10163547,10632051,10632053,10632055,10632163,10632164,10632165,10632169,10632189,10632300,10632301,10632302,10877911,10627775,10172076,10162201,10162249,10949057,10626143,10626144,10626235,10626241,10626298,10168040,10168050,10626602,10626815,10626842,10163479,10583440,10598547,10598548,10598549,10598550,10598551,10598552,10598553,10598554,10598595,10598596,10598597,10598598,10598599,10598600,10598601,10598602,10598603,10598604,10598605,10598606,10598607,10598608,10598609,10598610,10598611,10598612,10598620,10598630,10598653,10598654,10598655,10598656,10598657,10598658,10598659,10598660,10598661,10598662,10598668,10598669,10598673,10598674,10598675,10598676,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,10598728,10598729,10598747,10598748,10598749,10598750,10598753,10598755,10598762,10598763,10598764,10598765,10598766,10598767,10598768,10598769,10598770,10598771,10598795,10598796,10598797,10598798,10598799,10598808,10598817,10598819,10598820,10598823,10598824,10598825,10598826,10590269,10590270,10590272,10590273,10590274,10590275,10590279,10590280,10590297,10591364,10591365,10582565,10582571,10579778,10579779,10579780,10579781,10591910,10591911,10591928,10580000,10580001,10580002,10525294,10525295,10525569,10521873,10528106,10528107,10528108,10528115,10528116,10528117,10528118,10528119,10528120,10528121,10528122,10528123,10528124,10528125,10528126,10528127,10528128,10528129,10528130,10528131,10528132,10528133,10528142,10528146,10528162,10528176,10528177,10522323,10522441,10522442,10522443,10522444,10522445,10522446,10522447,10522448,10522449,10522450,10522452,10522453,10522454,10522456,10520776,10520777,10524778,10532856,10532857,10532858,10532859,10524895,10420247,10420258,10420262,10420266,10420268,10420427,10420432,10498367,10421486,10421487,10424487,10424488,10420570,10420571,10422597,10498499,10423614,10423618,10421785,10421786,10498692,10498693,10424910,10424941,10424967,10422997,10423003,10423010,10425036,10425042,10425051,10425056,10483067,10483076,10483089,10483092,10486567,10475757,10475758,10475809,10482014,10482020,10476460) 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'