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(8068814,8559309,8559310,8559378,10859052,10859053,10103895,10859054,10859055,10859056,10859057,10859058,7076249,10843598,10843729,10872374,10872375,10872385,10872409,10250857,10250858,10872497,8619092,8619093,7073828,7073829,7073867,7073868,7073869,7073870,7073871,7073874,8837016,10251379,10251380,10251381,10251382,10860029,10251457,10251458,10251459,10251460,10251461,10251462,10251463,10251464,10251465,10251466,8619808,8837727,8837728,8837729,8837730,8837764,8837765,8837766,4430344,10102859,10102860,4430368,8558750,4430506,8911101,10843055,10843056,10843058,10931814,10234658,10101562,3926919,3926920,3926921,3926922,3926923,3926924,3926925,3926944,10857047,10870134,7073615,10870499,7073687,10870515,10870516,10870517,8626944,10870594,10285089,10285090,10285091,10285092,10942579,10285203,10942700,10867919,3235080,10285384,10285390,10839444,10943221,10943369,10270059,10270060,10270061,10270062,10270063,10270064,10270065,10270066,10270067,10270068,10270069,10270070,10270071,10270072,10270073,10231098,10231188,10231189,10283215,10231221,10231222,10231223,10270228,10270229,10270230,10270231,10270232,10270233,10270234,10270235,10270236,10270237,10270238,10270239,10270362,10270418,10270419,10270420,10270421,10270422,10270423,10270424,10270425,10270426,10270427,8905881,7069358,7069361,7069363,10866195,10283916,10283917,10866721,3923972,10941797,10941881,10941959,10284689,10284691,10284734,10284751,10284752,8907102,10284771,10284780,8073481,8073482,10284911,10284912,10284913,10284914,10284915,10284916,10284917,10284918,10284942,7070738,10460920,10460950,10460960,10460964,10460967,10460970,10460974,10460976,10928617,10433114,10229319,10229320,10618299,10618302,10848472,3231187,3582194,10864164,10229662,9217655,10864418,10229929,10229930,10229931,10229932,10229933,10229934,10229935,10229936,10229937,10229938,10229939,10229940,10229941,10229942,10229943,10229944,10229945,10229946,10229947,10229948,10229949,10229950,10229951,9218027,10230163,10230164,10230165,10230166,10230167,10230168,10230169,10230236,10230237,10230238,10230290,10230291,10230344,10230345,10230350,8541379,8904989,10230666,10230764,10230765,10230766,10230767,10230768,10230769,10230770,10230771,10230820,10230856,10230877,10230896,10230897,10270022,8584005,10617223,10850053,10432554,10432575,10460712,10460718,10460724,10460730,10460736,10460742,10460748,10460754,10460760,10460766,10460772,10460778,10460784,10460790,10460796,10460802,10460808,10460814,8576426,10460820,8576427,10460826,10460832,10460838,10920541,10615037,10845214,10845215,10920620,10920621,10920622,10920623,10920637,10920638,10920639,10920658,10920659,8570250,8570251,8570252,8570253,8570254,8570255,8570256,8570257,8570267,8570268,10930232,10845759,10845806,10845807,10845808,10845814,10845866,10845943,10845944,10845945,10845946,10845947,10845981,10458857,10448288,10279170,9215147,10459096,10459100,10459109,10459116,9215895,10927438,10927439,10562116,10562117,10559211,10559212,10559213,10559214,9213538,9213569,9189589,9189590,9213598,9213623,9213652,9213653,10559481,10559482,7059857,9213758,9213781,9213782,10559610,10559611,10559612,10559613,10559615,9213828,9213836,9213855,9213856,9213894,9213922,9213923,10714425,10122147,9213959,9213960,10122176,8853855,10122287,8854046,6678490,9203299,7057473,7057523,8542674,8542675,8542676,10563530,9211822,9195884,8067654,9212116,9196460,9188501,9220499,7058743,9188654,9188655,9204769,9188978,9173255,10428786,6673647,9185536,9185680,9185693,9185694,9185695,8849534,4974611,9161768,4974633,9185793,8592939,8592945,10513620,10126025,10126026,10515725,10126140,10126194,10126195,9186023,9186027,9186028,9186029,9186277,9186331,9186381,9186451,10118693,9186508,9186512,9186513,9202522,9186553,9186635,9202712,9186730,9186827,9203202,9203203,9203204,9203205,9203260,9203261,9203262,9203263,9203264,10419304,8848210,10116697,6680858,10419591,10417729,8848925,10428493,4974011,4974012,4974013,4974014,8854396,9916828,9916829,3656102,9198909,6671133,3963467,3963468,3963469,10123540,6667489,6473840,6473841,6473842,6473843,6667585,9199723,9199724,9199725,10124005,9207842,10470456,10470457,976676,8917749,8917750,10116416,10903681,10903690,10903691,10903719,10903720,10629209,10629256,10629327,10629328,10629329,10629337,10629338,10629583,10629592,10629593,10629594,10171121,10171122,10171123,10880306,10880307,10912488,10174361,10181787,10181788,10181789,10181865,10181866,10181867,10181868,10181869,10181870,10181920,10181921,10181922,10181923,10181984,10177039,10177040,10172100,10172113,10177264,10177265,10177266,10177267,10172769,10911826,10949854,10949855,10626732,10626733,10626739,10626740,10626741,10580119,10646185,10568311,10568312,10601334,10568389,10568390,10568393,10568394,10568396,10611321,10568483,10568506,10568517,10568518,10568519,10568521,10646587,10568532,10652687,10652826,10652827,10598951,10599039,10599084,10599085,10599086,10599189,10599190,10599191,10599192,10599245,10599259,10599340,10599341,10599342,10599343,10599344,10599345,10599346,10599501,10599502,10599503,10599504,10599505,10599506,10599507,10599508,10599509,10599510,10599511,10599512,10599513,10599514,10599515,10599516,10599517,10599518,10599519,10599520,10599521,10599993,10599994,10599995,10599996,10599997,10599998,10600122,10600123,10600124,10604037,10600255,10600256,10600257,10600258,10600259,10576298,10576299,10576300,10576301,10576302,10576303,10576304,10576305,10576306,10576307,10576308,10576309,10576310,10576311,10576382,10576383,10576384,10576385,10576386,10576387,10576388,10576389,10576390,10576391,10591407,10591408,10591430,10591431,10576455,10600456,10600457,10600458,10600459,10600460,10600461,10591470,10591471,10567481,10567482,10610346,10601409,10600606,10607462,10607463,10600624,10600633,10600694,10600695,10600729,10600730,10600731,10600732,10600733,10600734,10567787,10567796,10567798,10567799,10567808,10567809,10567810,10567811,10567812,10567813,10567814,10567815,10567816,10567817,10567818,10567819,10567820,10567829,10567830,10567831,10567832,10600833,10567833,10600834,10567834,10600835,10567835,10600836,10567836,10567837,10600900,10600953,10600956,10600957,10600958,10600972,10601068,10531112,10531113,10531114,10531115,10531116,10531117,10521253,10521254,10531417,10531418,10531419,10531559,10531560,10531561,10531562,10531563,10531564,10531565,10531566,10531567,10531568,10531569,10531570,10531571,10531572,10531573,10531579,10531580,10531581,10531582,10531583,10531584,10531585,10531586,10531587,10531588,10531589,10531590,10531591,10531592,10531593,10531594,10531595,10531596,10531597,10531607,10531608,10531609,10531610,10531611,10531612,10531613,10531634,10521652,10527828,10531848,10545849,10545850,10545852,10545853,10529871,10529981,10529982,10529983,10532026,10532027,10532028,10532029,10532030,10522084,10522086,10522090,10530100,10530122,10530127,10530128,10530129,10530137,10530138,10530142,10530143,10532198,10532199,10532242,10532243,10532244,10532338,10532393,10532394,10532395,10532396,10532397,10544522,10530589,10530590,10530599,10530600,10530601,10530602,10530603,10530604,10530646,10530647,10530648,10544649,10530649,10544650,10530650,10544651,10544652,10544653,10530654,10532672,10530753,10522785,10522786,10532793,10532794,10532795,10532796,10532797,10532798,10532799,10532800,10532801,10532802,10532803,10532804,10538849,10520849,10532881,10532882,10546941,10530951,10530969,10530978,10531021,10531022,10531023,10531108,10531109,10531110,10531111,10507117,10507118,10507119,10507120,10507121,10507122,10507129,10507130,10507131,10507132,10507133,10507134,10507135,10507139,10507142,10507143,10507144,10507145,10507147,10422256,10507149,10508271,10508272,10508339,10423511,10423512,10423522,10423544,10423592,10507485,10507486,10507495,10422195,10422202,10407488,10488171,10413554,10413555,10413556,10413557,10413558,10413559,10413560,10413561,10483402,10486518,10411902,8563166,8563167,8563168,10492918,10414423) 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'