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(10962695,10962696,10962697,10939712,10939716,10939736,10939737,10939738,10939739,10939740,10939741,10939742,7076289,7076296,10963081,10943878,10943879,10943880,10943881,10963305,7068734,7068735,7068736,7068737,4971139,4971140,4971141,4971142,8066954,10963806,10963820,7066281,10977289,10977290,10977291,10977292,10977293,10977294,10977295,10977296,10977297,10977298,10977299,8067649,8067652,8067653,10964549,10964550,10964559,10964583,10964584,10964606,7075185,10961947,7067277,7067278,7067279,7075283,7075287,7075288,7075289,7075290,7075292,10962089,11001092,10962115,10962116,10975148,10975184,10975186,10975188,8068515,10975335,10975345,10975356,7075685,7067686,10975384,10975386,10975389,7075867,10931470,10931472,10931477,10931478,7064325,8065363,8065393,10999125,10999126,10999127,10999128,10999129,10999130,10999131,10999132,10999133,10999134,10999135,10986452,10932299,10999673,10999674,10999676,10999677,10960693,8065991,7065054,7065055,7065056,7065057,7065058,7065060,7065061,7065062,7065064,7065065,7065067,10960838,10999927,8066262,8066394,11000159,10974173,10974174,8066507,10932924,10932949,7073626,8066637,8066826,10984674,10997695,10984701,10984708,10984716,10984717,10984718,8064011,11049072,10942932,10942937,10942938,7071365,8064396,11049322,11049323,11049324,11049325,11049341,11049342,11049385,10943135,10943136,10943143,10943147,10943148,10943149,10943150,10943166,8064530,10943176,10943230,10943249,8064677,10998414,10998551,10998552,8064856,10959615,10982663,10956722,10956723,10956724,10956736,10956743,10956753,10956754,10956755,10956763,10956764,10956765,10956766,10956767,10982795,10982819,10982820,10982821,10983034,10983108,10983164,10983166,10983196,10996241,10970247,10996272,10983300,10983301,10983302,10983303,10983304,10983305,10983306,10970307,10970308,10983364,10983365,10983366,10983497,10983501,3656451,3656452,3656453,3656454,3656455,3656456,3656470,3656625,3656626,3656629,3656661,3656667,3656668,10983786,10983787,10941762,11048387,11048388,11048389,10958283,10984338,10984339,10984371,11048596,11048597,11048598,11048599,11048604,11048605,10984402,10971407,10997524,10997525,10971551,10954788,10954792,10923669,10967841,10967842,10967843,10967844,10923700,10923710,10923732,10923761,10923804,10618299,10618300,10618301,10923830,10618321,10923831,10923832,10923833,10923834,10923835,10923836,10923837,10923838,10923839,10618330,10923840,10618331,10923841,10923842,10923851,10923853,10923859,10923877,10923885,10923917,10955114,10923972,10923991,10924010,10994169,10924021,10924045,10924063,10924064,10924065,10924066,10924067,10924068,10924069,10924070,10924074,10924087,10924093,10994243,10924100,10924107,10924108,10924155,10924210,10924221,10924222,10924223,10924224,10924225,10924226,10924227,10924228,10924229,10924230,10924231,10924232,10924233,10924234,10924235,10924236,10924237,10924238,10924239,10924240,10924241,10924242,10924243,10924244,10924245,10924246,10924247,10924248,10924249,8070730,8070734,10981703,10924556,10619208,10968979,10968983,10968991,10619336,10969000,10969009,10619357,10619358,10969018,10619394,10969091,10982113,10982123,10982124,10982531,10982543,10619894,10982602,10927491,10922500,10622000,10622001,10622002,10622003,10622014,10617023,10927547,10922700,10922701,10922702,10922703,10922704,10922705,10922706,10922707,10922708,10922709,10922710,10922711,10922712,10922713,10922714,10922715,10922716,10922717,10922718,10922719,10922720,10922721,10922722,10922723,10922724,10622280,10927911,10927912,10927913,10927914,10927915,10927923,10927925,10954399,10614987,10920598,10920599,10920635,10615139,10615209,10615210,10920755,10977982,10620355,10620356,10978018,10925873,10925874,10925875,10978067,10978072,10920957,10920958,10920969,10920970,10920971,10920972,10920973,10920974,10921008,10921016,10926028,10620550,10921065,10926065,10926085,10926086,10926087,10965287,10926184,10926185,10926198,10926199,10921240,10926240,10921257,10926281,10926282,10926283,10991486,10991494,10978544,10991580,10620992,10616055,10616089,10991753,10991754,10991777,10991778,10621152,10926713,10952867,10952921,10616469,10616471,10616512,10616513,10966234,10621581,10616699,10616700,10621705,10922324,10979522,10979542,10979563,10979564,10979570,10979586,10979592,10616955,10611184,10611185,10611186,10611187,10611188,10559339,10611191,7059720,10559400,10559401,10559402,10559403,10559404,10559405,10559406,10559407,8864292,10614441,10614447,8864307,10614449,10611452,8864317,9173867,9173868,9173869,10614554,10614620,10562798,10562799,10562800,10562801,10562802,9174013,9174014,9174015,9174046,9174047,9174048,9174049,9174050,9174051,9174052,9174053,9174054,9174055,9174056,9174057,9174058,9174059,9174060,9174061,9174062,9174063,9174064,9174065,9174066,9174067,9174068,9174069,9174070,9174074,9174075,9174083,9174087,8864808,10612050,8861970,7057962,10609715,10609716,10609732,10612747,10612748,9172145,9172175,10609841,9172250,9172261,8862850,8862851,8862852,8862853,8862854,8862855,8862856,8862857,8862858,8862859,8862860,8862861,8862862,8862866,8862867,10613066,10610106,9164549,9164553,10610242,10610243,10610244,10610271,9172661,7058854,7058855,7058856,7058857,7058858,7058859,7058860,7058864,7058865,7058866,10613369,10558674,10558675,10558676,10558677,10610878,10515335,10513386,10511472,10511473,10511474,10511475,10511476,10511497,10511498,10511581,4974621,4974622,10511582,10511583,4974623,10511584,4974624,10511585,10511586,4974629,10511604,7055963,10511688,9169982,4974865,4974866,4974867,4974868,4974869,4974870,4974871,4974872,4974873,4974874,4974875,4974876,4974877,4974878,4974879,4974880,10511866,10511867,10511868,10511869,10511870,10511871,10511872,10511873,10511874,10511875,10511876,10511877,10511878,10511879,10511880,10511881,10511882,10511883,10511884,10511885,10511886,10511887,10511888,10511889,10511890,10511891,10511892,4975072,10512057,10512058,10514117,10514118,10514131,10514132,10514133,10514134,10514135,10514136,10516142,10514160,10514168,10514169,10514174,10514213,10514214,10514239,10514260,10514261,10514264,10514280,10514324,10514325,7056927,7057093,10514797,10514798,10514799,10514809,10515005,10515085,10418259,9168377,10417333,9160473,10419457,8918201,9168568,10415656,10415692,9168791,9168815,10417742,10416782,9161157,10417089,10417101,8864864,8864865,8864868,8864923,8864924,8864925,8864926,8864927,8864928,8864942,10463002,8865038,8865039,8865185,10463315,10463345,10463361,10469529,10469636,10463728,8916908,10465867,8916991,10468395,9167963,10464639,10462724,10462725,10462756,10628088,10159729,10159785,10628274,10159803,10159817,10628311,10628394,10160054,10160286,10628925,10160624,10155854,10155855,10155856,10155925,10155941,10629604,10166177,10166426,10163535,10163536,10163537,10158704,10163784,10163785,10163786,10163787,10158792,10158843,10158884,10153990,10154016,10627724,10630101,10630297,10630298,10630299,10630300,10630301,10630302,10630303,10630304,10630305,10630306,10630310,10630311,10630312,10630313,10630314,10625646,10626211,10631328,10626395,10158245,10158246,10158247,10158248,10158249,10158250,10158251,10158260,10158267,10158268,10158269,10158270,10158271,10158272,10158273,10158274,10158275,10158276,10158294,10158295,10158296,10158297,10158298,10158299,10158300,10158301,10158302,10158303,10158304,10158305,10158306,10158307,10158334,10158335,10158336,10158337,10158338,10158342,10631820,10158343,10631821,10158344,10631822,10158345,10631823,10158346,10631824,10158347,10631825,10158348,10631826,10158349,10631827,10631828,10631829,10631830,10631831,10631832,10626832,10631833,10626833,10631834,10626834,10631835,10626835,10631836,10626836,10626837,10626841,10566113,10566115,10566116,10566117,10567348,10567349,10567350,10567351,10567352,10567353,10567354,10567355,10521661,10521662,10523664,10523665,10521852,10522100,10522334,10522335,10522336,10522503,10522726,10522727,10520763,10520764,10520765,10520766,10520767,10520768,10520769,10520856,10520857,10520858,10520859,10520860,10520861,10520862,10520863,10520864,10520865,10520866,10520867,10520868,10520869,10520870,10520871,10520872,10520873,10520874,10520875,10520876,10520877,10520878,10520879,10520880,10520881,10520882,10520883,10520884,10520885,10520886,10520887,10520888,10520889,10520890,10520891,10520892,10520893,10520894,10520895,10520901,10520904,10520905,10520908,10520909,10524917,10524918,10524926,10524927,10520931,10422337,10420424,10422454,10422473,10420568,10420572,10420573,10420583,10420584,10420585,10420586,10420587,10420588,10420589,10420590,10420591,10420592,10420676,10422703,10421961,10421962,10423029,10422213,10472923,10477234,10477235,10477236,10477237,10477386,10473910,10473912,10474043,10474075,10474249,10474251,10472303,10472305,10472306,10472308,10472317,10472325,10472326,10472327,10472328,10476535,10476536,10476537,10476538,10476548,10476552,10476596,10476597,10476598,10474651) 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'