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(10962606,10962607,10962608,10962609,10962611,10962612,10962613,10962614,10962615,10962616,10962617,10962618,10962619,10962620,10962621,10962622,10962623,10962624,10962625,10962626,10962627,10962628,10962629,10962630,10962631,10962632,10962633,10939733,10939746,7068113,10943628,7076128,7076290,7076294,7076297,10989096,8569414,10963323,10963324,10963325,10963659,10963831,10963848,10964440,10964441,10964442,10964443,10964444,10964445,10964446,10964447,10964448,10964449,10964450,7066825,8067931,7067196,7067281,11001083,11001084,10962147,7075498,7067586,10962462,10962475,6000114,10959558,10959565,10959568,10959571,6000198,6000199,7072151,10985860,11011910,11011911,10999063,10960065,10960218,10960219,10960220,10960221,10960222,10960223,10960224,10960225,10960226,10960227,10960228,10960229,10960382,8065853,10960474,10986480,10986516,8065932,8065933,8065934,8065935,8065953,8065954,8065955,8065956,8065957,8065958,10960851,11000133,11000134,11000135,11000136,10961222,11010509,11010510,11010742,11010743,11010744,10958955,10958956,10985232,10985233,10985234,10985235,10985236,10998392,10957566,10941695,10941697,10941698,10941702,10941704,10941720,10996691,10941727,10941739,10941741,10941755,10941769,10941770,10941772,10941775,10941780,10941809,10996784,10996794,10942028,8860395,8860420,7070793,10993600,10993601,10967777,10967778,10618265,10618266,10618267,10618268,10618269,10618270,10618271,10618272,10618273,10618274,10618275,10618276,10967821,10618285,10618290,10618291,10967929,10994158,10994231,10968440,10619509,10624632,10995359,10995360,10995379,10995380,10619854,10619871,10619872,10619875,10621982,10992579,10617126,10617157,10617322,10617337,10617340,10617341,10617342,10617343,10617344,10617346,10617372,10617379,10922895,10922896,10922899,10922900,10617407,10617408,10617424,10617425,10617437,10617438,10617439,10922949,10617440,10617444,10617445,10954002,10954003,10954004,10622548,10622549,10954113,10954114,10993363,10993367,10993373,10993379,10993399,10993407,10993423,10614983,10620081,10615108,10990672,10990673,10990674,10990675,10990676,10620187,10620189,10620190,10620191,10620192,10620193,10620194,10620198,10620199,10620200,10620208,10615229,10620303,8570148,10615356,10615471,10930665,10930666,10930667,10930754,10930755,10991487,10991490,10991491,10991492,10991516,10616019,10616033,10991581,10991582,10991583,10991720,10991730,10991732,10991742,10991745,10991863,10991893,10991897,10991898,10991899,10991900,10991901,10991902,10991923,10991924,10991925,10991948,10616417,10991983,10991984,10991989,10991992,10991998,10992005,10992232,10992233,10992235,10992236,10992237,10992240,10992241,10992278,10992281,10992282,10992283,10992284,10992285,10992287,10992288,10992301,10992317,10992321,10992327,10616790,10992377,10992379,10992383,10992395,10953442,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,10611362,9173712,10614376,9173713,9173714,9173715,9173716,9173717,10611380,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,10611413,10611414,10611427,10611440,10611450,10611451,10611491,10559705,10611573,10611579,10611582,10611585,10611587,10611594,10611596,10611597,9173957,10611620,9173958,10611624,10611676,9174081,9174082,9174083,9174084,10611808,9174154,10611832,6666230,6666231,6666232,6666234,6666239,10611925,10611970,8861861,10612059,10612191,10612192,10612201,10612294,10612381,9172147,9172238,9172239,9172240,10612940,10612941,10609944,9172326,8862872,8862873,8862874,8862875,9172360,10613137,9172541,9172746,9172747,9172748,9172749,9172751,9172752,10610434,10558596,9172796,9172805,10613722,10613736,10613760,10613860,10613861,10613862,10613863,10613864,10613865,10613866,9173229,10610954,9161362,10513382,7055824,10513553,10513566,10513567,10513568,10513569,10513570,10513571,10513572,7055956,9169935,9169942,9169944,9169945,9169946,9169947,9169949,9169954,9169955,7056160,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,10518666,10514666,10514667,10518667,10518668,10514668,10518669,10514669,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,10415394,10416411,10416414,10416429,10416431,10416435,10416443,10419469,10419470,10419504,10419508,10419522,10415604,10415605,9168721,10418676,10419683,10419686,10418709,10419716,10415730,10419734,9168816,9168818,10419748,10419749,10419750,10419751,10419752,10419753,10419754,10419802,10419803,10419804,10419805,10419806,10419808,10419809,10418812,10418816,10415821,10419823,10419826,10419832,10419833,10415834,10418850,10418852,9168937,10415883,10419889,9168995,9169036,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,7055457,10417213,7055458,10417214,10417215,10417216,9161295,10417217,10417220,10466955,10463025,10463026,10463027,10463035,10463045,10467068,10467092,10467133,10467136,10467143,10467146,10467172,10467173,10471174,10463311,10463312,10469340,10469341,10469342,10463394,10463395,10463403,9166829,10467407,10463435,10467440,10467472,10467473,10463552,10463553,10467558,10465680,10463689,10463690,10465712,8916798,10463755,10463765,10463771,10465773,10465790,6667222,10465846,10467867,10465894,10463915,10463916,10465918,10465919,8917098,10464043,10464045,10462294,10462305,10462306,10462307,10462326,10462327,10462344,9167770,10466378,10462395,10462396,10462399,10466401,10466424,10466425,10464425,10464426,10466434,10466435,10462439,9167865,10466469,10466470,10462535,10468551,10462577,10462578,10462613,10462614,9168121,10462723,10462724,9168148,10462725,10462728,10462754,10466855,9168293,10628178,10628382,10628510,10628931,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,10631245,10626245,10626246,10626259,10626798,10163475,10568126,10568294,10568295,10568296,10568297,10568298,10568299,10568300,10568301,10568302,10568303,10568304,10568305,10568311,10568312,10567590,10567591,10567592,10567593,10567594,10567595,10567596,10567597,10522165,10522166,10522167,10522173,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,10423919,10423922,10423923,10423924,10421964,10422996,10422000,10423002,10423009,10423015,10423016,10423017,10423019,10423020,10423022,10423024,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'