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(10198145,10250154,10250155,10250156,7068113,10943628,7076128,10237390,7076290,7076294,7076297,10198541,10198554,8569414,10198708,10198709,10198710,10198711,10198713,10198714,10198715,10198716,10198717,10198718,10198719,10198720,10198721,10198722,10198723,10198724,10198725,10198726,10198727,10198728,10198729,10198730,10198731,10198732,10198733,10198734,10198735,10199386,10199387,10199388,10251479,10251480,10225631,10238692,10238693,10238694,10238695,10199791,10199972,10199989,7066825,8067931,10197279,7067196,7067281,10236582,7075498,7067586,10249854,10249855,6000114,6000198,6000199,7072151,10247604,10221692,10221693,10221694,10221695,10221696,10234787,10234788,10234789,10234790,10234896,10234906,10195959,10196190,10196191,10196192,10196193,10196194,10196195,10196196,10196197,10196198,10196199,10196200,10196201,10222305,10196394,10196489,10248662,10248663,10248667,10196886,10222921,10222959,10233359,10233360,10233379,10233380,10194861,10194862,10231142,10231148,10231154,10231160,10231180,10231192,10231208,10231416,10231417,10232052,10232109,10941695,10941697,10941698,10941702,10941704,10941720,10941727,10941739,10941741,10941755,10941769,10941770,10941772,10941775,10941780,10941809,10193449,10942028,8860395,8860420,7070793,10229126,10229129,10229130,10229131,10229158,10229223,10229224,10229225,10618265,10618266,10618267,10229359,10618268,10618269,10618270,10618271,10618272,10618273,10618274,10618275,10618276,10229369,10229371,10618285,10229382,10618290,10618291,10229385,10229506,10229537,10229541,10229542,10229543,10229544,10229545,10229546,10229567,10229568,10229569,10229595,10229634,10229635,10229640,10229643,10229649,10229650,10229651,10229660,10229911,10229912,10229914,10229915,10229916,10229919,10229920,10229962,10229965,10229966,10229967,10229968,10229969,10229971,10229972,10229985,10230001,10230005,10230011,10230073,10230075,10230079,10230097,10204186,10204188,10204231,10230299,10204355,10619509,10624632,10204936,10204937,10204938,10619854,10619871,10619872,10619875,10621982,10228145,10228146,10228147,10228148,10228149,10189205,10617126,10617157,10617322,10617337,10617340,10617341,10617342,10617343,10617344,10617346,10617372,10617379,10922895,10922896,10922899,10922900,10617407,10617408,10617424,10617425,10617437,10617438,10922949,10617439,10617440,10617444,10617445,10622548,10622549,10189909,10189910,10189911,10190017,10190018,10614983,10620081,10615108,10620187,10620189,10620190,10620191,10620192,10620193,10620194,10620198,10620199,10620200,10620208,10615229,10620303,8570148,10615356,10615471,10200643,10200644,10200645,10200646,10200647,10200648,10200649,10200650,10200651,10200652,10200653,10200654,10200655,10200656,10200657,10200658,10200659,10200660,10200661,10239749,10239750,10930665,10930666,10930667,10930754,10930755,10616019,10616033,10188373,10616417,10188598,10188662,10188663,10616790,10616905,10562116,10562117,10562150,10562151,10562152,10562153,10562154,10562155,10562156,10562157,10562158,10562159,10562160,10562161,10562162,10562163,10562164,10562165,10562166,10562167,10562219,10562220,10562221,10562222,9165414,10565234,10565235,10614085,10614086,10565236,10565237,10565238,10565239,10565240,10565241,10565242,9189549,9173712,9173713,10614376,9173714,9173715,9173716,9173717,9173718,9173719,9173720,9173721,9173722,9173723,9173724,9173725,9173726,9173727,9173728,9173729,9173730,9173731,9173732,9173733,9173734,9173735,9173736,9173737,9173738,9173739,9173740,9173741,9173742,9173743,9173744,9173745,9173746,9173747,9173748,9173749,10559705,9173957,9173958,9174081,9174082,9174083,9174084,9174154,6666230,6666231,6666232,6666234,6666239,10611970,8861861,10612059,10612191,10612192,10612201,10612294,10612381,9172147,9172238,9172239,9172240,10612940,10612941,9172326,8862872,8862873,8862874,8862875,9172360,9188364,9188365,9188366,9188379,9188394,10613137,9172541,9188597,9172746,9172747,9172748,9172749,9172751,9172752,10558596,9172796,9172805,10613722,10613736,10613760,10613860,10613861,10613862,10613863,10613864,10613865,10613866,9173229,9161362,10513382,9185605,9185621,9185622,7055824,9185717,9185718,10513553,9185742,10513566,10513567,10513568,10513569,10513570,10513571,10513572,7055956,9185796,9185804,9185828,9185829,9185830,9185831,9185832,9185853,9185854,9185863,9185864,9185892,9185908,9185915,9185922,9169935,9185938,9185939,9169942,9185943,9169944,9169945,9169946,9169947,9169949,9169954,9169955,7056160,9186012,9170036,10516139,9170736,10516576,10516577,10516578,10516579,10516580,10516581,10516582,10516583,10516584,10516585,10516586,10516587,10516588,10516589,10516590,10516591,10516592,10516593,10516594,10516595,10516596,10516598,10516606,10516607,10516608,10516609,10516610,10516611,10516612,10518648,10518649,10518650,10518651,10518652,10518653,10518654,10518655,10518656,10518657,10518658,10518659,10518660,10518661,10518662,10518663,10518664,10518665,10514666,10518666,10514667,10518667,10514668,10518668,10514669,10518669,10518670,10518671,10518672,10518673,10518674,10518675,10518676,10518677,10518678,10518679,10518680,10518681,10518682,10518683,10518684,10518685,10518686,10518687,10518688,10518689,10518690,10518691,10518692,10518693,10518694,10518695,10518696,10518697,10518698,10518699,10518700,10518701,10518702,10518703,10518704,10518705,10518706,10518707,10518708,10417221,10417222,10417224,10416364,10416366,10416367,10416384,10416385,9160472,10416411,10416414,10416429,10416431,10416435,10416443,10419469,10419470,10419504,10419508,10419522,9168721,10418676,10419683,10419686,10418709,10419716,10419734,9168816,9168818,10419748,10419749,10419750,10419751,10419752,10419753,10419754,10419802,10419803,10419804,10419805,10419806,10419808,10419809,10418812,10418816,10419823,10419826,10419832,10419833,10418850,10418852,9168937,10419889,9168995,9169036,9177085,10420038,10420039,10420054,10417054,10420055,10420057,10417059,10420060,10417060,10417083,10420086,10420089,10417091,10420092,10417101,10417102,10417104,10419113,10419114,10417115,10417116,10417119,10417120,10417121,10417122,10417124,10417155,10417159,10419191,10420202,10417213,7055457,10417214,7055458,10417215,10417216,10417217,9161295,10417220,10466955,10467068,10467092,9174515,10467133,10467136,10467143,10467146,10467172,10467173,10471174,10469340,10469341,10469342,9166829,10467407,10467440,10467472,10467473,10467558,10465680,10465712,8916798,10465773,10465790,6667222,10465846,10467867,10465894,10463915,10463916,10465918,10465919,8917098,9175466,10464043,10464045,9167770,10466378,10466401,10466424,10464425,10466425,10464426,10466434,10466435,9167865,10466469,10466470,10468551,9168121,9168148,10466855,9168293,10628178,10628382,10628510,10628931,10171233,10632018,10632046,10632049,10632054,10632106,10632109,10632110,10632161,10632162,10632163,10632164,10632165,10632166,10632300,10632301,10632302,10164081,10164082,10164083,10164084,10164085,10164086,10164087,10627728,10627729,10627730,10627731,10627732,10627733,10627734,10627735,10627736,10627737,10627738,10627739,10627740,10627741,10627742,10627743,10627744,10627745,10627746,10627747,10627748,10627793,10630146,10162083,10162246,10162247,10631232,10631233,10626241,10626242,10626245,10631245,10626246,10626259,10167941,10168026,10168027,10168040,10626798,10163475,10568126,10568294,10568295,10568296,10568297,10568298,10568299,10568300,10568301,10568302,10568303,10568304,10568305,10568311,10568312,10580417,10580418,10580419,10580420,10580446,10567590,10567591,10567592,10567593,10567594,10567595,10567596,10567597,10579795,10527912,10528105,10528110,10528111,10528112,10528113,10528114,10528138,10528139,10528143,10528151,10528160,10522165,10522166,10522167,10522173,10528213,10522346,10522347,10522384,10522388,10522413,10524418,10524419,10524420,10522599,10522600,10522614,10522615,10524867,10524868,10520901,10520904,10520905,10520909,10420248,10420251,10420253,10420257,10420261,10420265,10422279,10422320,10422321,10422381,10422382,10422403,10422404,10422405,10420428,10420429,10420430,10420432,10422544,10420562,10421577,10422585,10422588,10420598,10422599,10420647,10420717,10420753,10421767,10421768,10421779,10421780,10421781,10421782,10421783,10421784,10421789,10422818,10422819,10422822,10422823,10420848,10420849,10420851,10420861,10420862,10420873,10420877,10420878,10420879,10420880,10420881,10420882,10420883,10420884,10420885,10420886,10421889,10421890,10424909,10423919,10423922,10423923,10423924,10421964,10424965,10424966,10424967,10422996,10422000,10423002,10423009,10423015,10423016,10423017,10423019,10423020,10423022,10423024,10425034,10425050,10425055,10423152,10423155,10422219,10422220,10477102,10478008,10478009,10478014,10478027,10478031,10478032,10476267,10476268,10476270,10476271,10476273,10476281,10476282,10476283,10476284,10476285,10476286,10476287,10476288,10476289,10476290,10476291,10476292,10476293,10476458,10476459,10478492,10478493,10476506,10476507,10476514) 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'