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(8574118,8574133,8574143,10939641,10845789,10845790,3228480,10930338,10845838,10845839,3228672,10939896,8621132,8621160,10943811,11041087,10448284,8569461,10943917,8839018,10963218,8574712,8574713,10943966,10943993,8569557,8569580,10944024,8569583,8569592,8569593,3229079,10950291,10950292,10944110,10944111,3229158,3229159,3229160,8621614,3229276,10944284,8583493,10950886,7066383,10951059,11042128,8622297,8622298,7074552,8584123,10951332,3230166,3230167,3230177,3230178,10847513,3230288,3230289,3230290,3230291,3230292,8609755,10844710,8573148,3227393,3227426,3227427,3227428,8067909,10929438,10929439,8620059,10929564,10929577,8573493,10929605,10929606,4969588,7075676,7067711,8620556,8620656,7075832,8620679,10930159,10845656,10845657,7201183,7201184,11011635,11011636,11011637,11011638,11011639,11011640,11011641,8617863,11024722,3238518,8617990,11011879,11011880,8065187,10103385,10103399,10843073,7201596,10960063,8835875,10931744,8618242,10931764,11012106,7201772,7201778,7201795,8075330,7201841,7201926,10960453,8618606,8618607,4967030,7202074,10960623,10932301,8618791,10843741,10960676,7065064,10843838,3899593,10986786,8618988,10932516,7073200,10932730,10844307,10844353,8572838,10844423,10928976,10929027,10929041,10929042,10929050,10844531,10929072,3227328,10929186,10841697,10942572,3237405,3237406,3237407,8834560,10942721,7200468,11036955,3237719,10985091,3237834,10842259,10959206,10959232,7200793,10943258,3238226,10100076,10839766,8563769,8563862,7069159,3235675,3655846,10944721,3235798,10944829,3235970,3236032,3656191,3656192,3236108,8564480,8564528,8564578,10101040,7069935,7199319,7199324,3236522,8564816,3236550,11009856,11009894,11009895,11009920,10841070,8565100,8565144,11048393,11048394,11048395,11048404,10958284,10958285,3237024,8834118,7199897,10101781,10101788,10841597,10841602,8612833,8612834,8612835,8612836,8612860,8612863,8612864,10967806,10837902,10837913,10837968,7196482,10837992,10837996,10837997,10838003,10618300,10618301,10618317,10967984,11007134,11007205,10618618,10618692,10618693,10618694,10618695,8907059,11046720,11007732,10838829,10838849,10838850,11046806,7197567,8614275,8614282,7197846,3235027,3235351,4938658,10927474,10927475,10617072,10836828,10836833,10836834,10836835,10836836,10836837,10836838,10836839,10617183,8905294,10953989,11045033,10927894,10927895,10927906,10927936,10927941,3232840,3232841,10617458,10927972,10927973,10927981,10928017,10928027,10928066,8905825,8905855,10615092,10951706,8570119,10620175,3230580,8576390,8570226,8570227,10615289,10848086,10848087,10848088,11004086,10926022,10926023,10926024,11043194,11043195,8570487,10926052,10926063,10926073,10926074,10926075,10926089,10930510,10926090,10926091,10930512,10926098,10926099,10926106,10926107,10926124,10926125,10926136,10926137,10926138,10926139,10926154,10926155,10926156,8610456,10926187,10926188,10930617,10926247,10952352,10926273,10926274,10848517,10965468,10848555,3231245,3231246,3231247,3231248,3231249,3231250,8540348,8610723,3231344,3231345,10616002,10952607,8610852,3231436,10952764,10952765,8540639,8540640,10926696,10426527,10926701,10926705,10926714,10926729,10926742,8540972,10927071,8577774,8541145,10927193,10927194,10927195,10927197,10927203,8541265,10616804,8541318,8541335,11044535,11044555,11044556,10927433,10927444,10927456,10927457,10927458,9173333,9221366,10614060,9221393,9197455,9197456,10611157,10559327,10559328,10559329,10559330,10614200,10611232,9213584,7059768,10611416,9197812,10611483,10614496,10611496,9173854,9197861,10614565,10565838,10565839,10565840,10565841,10565842,8864559,8864616,10614765,10611785,8864652,10565949,10565950,10565951,10565952,8864662,9214146,8864695,8864696,9214175,9198187,10611857,9174196,9174200,9198202,9166214,10611907,10611924,9174276,10611970,10119515,10609102,9171440,9171441,9171442,9171443,8542675,9211506,9179519,9163573,9163583,10609315,10563532,9211787,9211788,9211789,9211790,10612599,7017683,7017684,7017695,7017696,9164054,9164106,10612820,9172225,10612909,10564149,10564150,10613023,10610027,10613027,10613036,7058552,7058553,10613074,10120616,7058616,8862980,8862981,7058642,10610170,8863034,8863036,8863040,10610189,10610272,8863362,9164852,10613562,8863485,9212965,8863545,6677231,9197029,8863566,8863575,10125541,9161489,10517303,10517304,10517305,10117695,6673723,10125748,9209589,10125839,10117846,10511470,10511493,9169691,9161692,9169696,10511546,10511547,10511570,10511571,10511572,10125985,7055962,10118043,10511678,10511768,10511807,10511808,10511809,10126193,10511810,10511811,10511812,10511813,10511814,10511815,10511816,10511817,10511818,10511819,10511820,10511821,10511822,10511823,10511824,10511825,10511826,10511827,10511828,10511829,10511830,10118386,10514022,10512041,6674441,10512050,10512051,10512052,9170275,9170299,6674507,10118513,9178366,9170378,9178393,9178413,9178414,9178493,10118737,10118744,9202554,10118754,10118764,9170645,9170650,10514502,10514503,10514504,9170694,10118970,10119066,10512755,2809652,9171049,9179070,9179143,9179145,9179148,9179152,9179153,9179155,9179156,9179157,9179161,9179169,9179172,8861698,9211209,10415231,10415263,6672551,6672562,10415281,10415282,10415283,10415284,10124570,10417379,10417387,10419401,10419435,10415448,9160538,9160551,10416475,10415478,10419503,10419514,10419520,10418540,10116828,9184642,10116847,10419574,7054874,10418679,10117004,10117005,10419765,9160843,10415799,10415800,10415809,10415823,10415841,10125208,9161012,10417006,4974015,10416124,10416125,10416143,10416144,4974078,10416147,4974079,10416148,4974080,10416149,4974081,10416154,10416155,10417169,10416187,10416193,7055442,8549592,6670687,9166515,8549809,9174662,9166662,3963032,8549881,8865257,9198841,9166855,10123082,8550080,8550254,10469705,10469706,8550312,6667176,6667179,10469783,10469784,10469785,6667238,10123516,8917037,8917038,8917039,8917059,8917060,9199432,10123656,9199553,9175683,9175684,8550850,8563596,10123901,10123902,10123903,9175731,10123962,10462344,10462345,10115984,10115991,10123993,10123994,6667801,9199837,6672085,6672099,9200055,8917709,9168107,10116406,9192237,9160265,9160266,10888502,10893518,10883553,10893647,10893668,10883670,10628182,10893739,10893740,10893742,10893745,10893746,10628580,10628665,10628666,10175204,10628700,10628701,10628704,10628705,10628706,10628793,10884336,10884376,8594408,10628911,10628912,10628913,10628914,10884425,10884427,10884473,10884474,10884497,10175545,10175546,10175547,10175548,10160761,10160762,10947666,10947667,10889876,10889877,10170918,10170919,10629428,10629429,10889985,10890037,10890145,10877485,10877486,10887521,10892600,10887617,10877724,10887782,10632304,10632305,10627314,10627315,10163983,10888146,10888147,10627730,10627782,10627783,10627787,10627804,10627805,10627806,10627807,10627808,10627809,10627810,10627811,10627812,10627813,10627814,10627815,10627816,10627817,10627818,10627819,10627820,10627897,10627898,10627899,10627900,10893417,10893418,10893419,10627919,10627920,10627921,10627928,10627929,10627930,10893445,10893453,10630039,10630040,10630041,10630042,10630100,10176649,10176650,10167010,10886028,10167126,10167147,10167158,10167164,10891219,10891220,10891221,10891222,10891223,10891224,10891248,10891254,10891260,10625806,10891390,10891430,10891437,10891569,10891581,10891582,10891583,10187718,10887051,10168102,10188290,10646241,10589204,10589205,10589206,10589207,10589208,10589209,10589286,10589287,10589288,10589289,10589290,10589291,10589292,10589293,10589294,10589295,10589358,10589359,10643465,10643466,10589479,10568521,10646592,10598943,10598944,10598945,10599042,10599124,10599125,10587143,10587144,10584226,10590592,10579772,10579773,10579774,10579775,10579776,10579777,10588832,10588833,10588834,10588835,10588836,10588837,10588838,10588839,10588840,10588841,10588842,10588843,10588844,10588845,10588846,10588847,10588848,10588849,10588850,10588851,10588852,10588853,10588854,10588855,10588856,10588857,10588858,10588859,10588860,10588861,10588862,10588863,10588864,10588865,10588866,10588867,10588868,10588869,10588870,10588871,10588872,10579906,10579907,10600979,10527947,10528070,10522080,10522092,10534370,10522499,10522500,10544516,10522612,10522613,10522614,10522615,10522616,10522617,10423321,10498243,10420353,10498244,10498245,10498246,10498247,10498248,10422358,10498249,10420361,10424441,10424444,10424445,10424446,10424447,10423467,10423468,10423480,10498414,10498415,10423575,10420694,10423098,10483057,10483058,10488145,10477342,10477358,10486613,10486614,10496769,10496774,10492926,10492927,10492959,10492977,10492978,10493002,10493128,10493160,10493161,10493162,10493163,10493164,10493165,10493166,10493167,10493168,10476217,10476247,10493250,10493269,10493270,10493295,10476339,10476344,10406891,10406980) 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'