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(3229130,3229131,3229153,3229171,3229285,7066178,7066265,8609572,8609573,8067943,10939443,7201273,7201274,7201277,7201309,7201335,7201366,7201367,7201377,7201434,7201444,7201454,7201614,7201727,7201756,7201758,7201861,7201862,7201901,7201959,7201974,7201975,10960474,7202100,7202101,7202102,7202103,7202129,7202130,7202137,7202139,7202140,7202162,7202200,7202208,7202219,7202224,7202229,7202237,7202257,7202258,7202259,7202265,7202266,7202273,7202274,7202275,7202277,7202285,7202295,5654588,7202524,5654613,5654651,5654657,5654658,5654660,5654661,5654670,7202585,5654676,5654677,5654682,5654683,7202643,10104638,9794588,9794589,7202769,7200456,7200458,7200469,7200470,10958953,10958954,7200527,7200528,7200529,7200543,7200547,7200548,7200570,7200571,7200572,7200573,7200574,7200575,7200576,7200577,7200578,7200639,7200640,7200641,7200642,7200643,10959088,7200778,7200779,7200780,8910604,8910605,7200903,7200904,7201070,7201071,7201152,10839702,7198682,8908497,8908498,8908499,8908500,8908501,7198694,7198736,7198737,7198738,7198739,7198740,7198742,7198743,7198744,7198745,7198746,7198747,7198748,7198749,7198750,7198751,7198752,7198753,7198754,7198755,7198756,7198757,7198759,7198760,7198762,7198784,7198785,7198891,7199130,7199211,8564678,7199392,7199471,7199480,7199508,7199540,7199541,7199542,7199545,7199569,7199570,7199571,7199573,7199574,7199575,10101491,10101492,11048307,10101564,10101565,10101566,7199739,7199740,7199741,7199742,7199743,7199768,7199775,11048454,8906036,8612892,8906901,7197239,10838801,7197433,7197437,7197446,7197455,7197456,3234660,3234661,3234662,3234663,3234664,3234729,7197805,7197807,10619872,10619874,8541459,8541473,3232382,10617035,8541521,8541549,10617107,10617118,10617123,10617126,10617138,10617139,10617140,10617151,10617157,10617158,10617159,10617171,8541668,10622365,10617378,10617384,10622428,10617436,10617437,10617438,10617439,10617440,10617441,10617442,10617443,10617444,10617445,10617452,10617461,3232910,8542165,8905822,8905844,10425350,10425358,10615075,10615076,10425484,10990815,10990816,10620195,10620196,10620197,10620198,10620199,10620201,10620202,10425573,10425574,10425586,10615352,10615356,10615363,10615389,10615437,10615438,10615439,10615471,10615472,10425910,10425934,10615598,10425939,10425942,10425944,10426008,10426009,10426010,10615674,10426017,10615709,10615710,10615711,10615721,10615722,10615726,10615727,10615728,10615780,10615819,10615820,10615822,10615823,10615824,10426197,10615889,10615890,10615891,10615892,10615893,10615894,10615895,10615896,10615933,10615938,10615939,10615950,10615953,10615956,10615962,10616002,10616003,10616005,10616006,10616044,10616045,10426402,8540593,10426448,10426449,10426450,10426451,10426452,8540612,8540613,8540626,8540631,10616475,8611390,8611466,8611467,8611468,8904796,8904857,10616856,10616862,10616872,10616873,10616874,10616875,10616876,10616877,10616880,10616888,10616906,10610966,10610967,10610971,10610975,10610976,10610977,10610978,10613985,10614048,10614085,10614086,9165550,10614220,10614221,10611252,10611253,10614267,10614268,10614269,10614270,10611338,10611339,10611340,10611341,10611350,10614376,10611444,10611466,10611495,10614565,10614593,10611611,10611676,10611804,10611812,10611830,10611831,10611832,10611833,10611834,10611835,10611954,10611957,10612094,10612095,10612096,10612097,10612268,10609285,10609355,7017673,7017674,7017675,7017676,7017677,7017678,7017679,7017680,7017681,7017682,7017683,7017684,7017685,7017686,7017687,7017688,7017689,7017690,7017691,7017692,7017693,7017694,7017695,7017696,7017697,7017698,10609707,7017699,7017700,7058247,7058248,7058249,7058250,10609839,10609844,10609845,9188248,10612916,10612931,10612987,10612988,10612989,10613018,9196366,9196371,9196372,9196373,10613056,10613057,10613058,10613079,10613089,10613093,10613096,10613097,10613098,10613099,10613102,10613104,10613105,10613106,10613107,10613108,10613109,10613110,10613111,10613112,10613113,10613114,10613115,10613116,10613117,10613192,10610233,10613235,10613337,10610352,10610353,10610376,10613421,10613431,10613432,10613513,10613514,10613524,10613525,10610691,10613696,10613732,10613733,10610901,10610935,6673506,6673538,6673542,6673563,7055541,7055546,9169407,9169475,6673686,6673688,10117679,6673697,6673698,6673699,6673700,9169516,9169520,7055722,7055724,9169570,9169586,10117784,10117785,9169638,9169669,7055836,9169695,9169748,10118130,6674152,9169954,9169955,6674165,6674175,10118171,6674186,6674198,6674236,6674249,6674256,6674276,6674278,6674280,6674281,6674285,6674308,6674309,6674310,6674311,6674312,6674313,6674330,10118357,10118358,10118391,10118392,10118398,10118410,10118440,10118441,10118442,10118443,10118444,10118449,10118451,10118452,10118678,9178490,9178492,8552227,10417221,10417222,10417223,10417224,10417225,6672521,10419256,10419271,10417282,10417296,10417297,10417298,10416298,10417300,10419306,10419307,6672592,10417312,10417313,10417314,10417315,9168393,10417318,10417319,10417320,10417321,10417322,10417323,10417324,10417325,10415325,10417326,10417327,10417331,10417347,10417348,10417349,10419349,10417350,10419350,10419370,10415373,10415374,10417385,10417394,10417395,10417396,10417397,10417398,10417399,10417400,10417401,10417402,10417406,10417407,10417408,10417410,10417411,10417412,10417413,10417414,10417415,10417416,10417417,10417418,10417419,10417420,10417421,10417422,10417423,10417424,6672716,10419437,10419438,10419439,10417443,10417444,10417445,10419468,10419472,10419473,10419474,10419475,10419476,10419477,10419478,10419479,10419480,10419481,10416481,10419482,10419483,10419484,10419485,10419486,10419487,10419488,10419489,10419490,10419491,10419492,6672802,10417531,10417532,10417533,10417534,10417535,10418543,10418544,10418545,10418546,10418559,10418560,10418561,10418562,10418563,10418564,10418565,10418566,6672896,6672897,6672898,6672899,6672900,6672901,6672903,6672904,10417633,10418689,7054936,6673064,6673067,6673081,6673082,6673085,6673086,10417811,10417812,10417814,10417816,10417818,10417820,10417822,10417824,10417826,10417828,10417830,10417832,10417834,10417837,10417839,10417841,10417843,10417845,10417847,10417849,10417850,10417852,10417854,10417856,10417858,10417860,10417862,10417864,10417866,10417868,10417870,10417872,10417874,10417876,10417878,10417881,10417883,10417885,10417887,10417889,10417891,10417893,10417895,10417897,10417899,10417901,10417903,10417905,10417907,10417909,10417911,10417913,10417915,10417917,10417919,10417921,10417922,10417925,10417927,10417930,10417932,10417934,10417938,10418018,10418048,10418109,10418110,10418141,10418142,10418143,10418144,10418145,10418146,10418147,10418149,10418150,9169233,10419172,10419173,10419174,10419175,10419176,10419177,7055445,10417212,10417213,10417214,10417215,10417216,10417217,10417218,10417219,10417220,10471122,10471173,10471174,10469245,8550018,8550097,8550155,8550184,8550188,8916794,10467821,9167324,10470084,10470089,10470090,9167779,9167937,9168102,9168103,10470721,10470722,10888487,10888524,10888552,10888553,10888565,10888566,10888607,10888637,10888638,10888639,10888640,10888641,10888642,10888655,10888656,10888704,10888713,10946563,10946564,10946565,10888829,10628321,10888839,10888840,10888841,10888936,10889019,10889020,10889021,10889052,10884075,10884094,10889162,10889201,10889202,10889210,10889213,10889224,10889225,10889226,10889231,10884324,10884420,10884421,10884423,10889711,10889718,10884723,10889756,10889757,10884764,10879926,10890100,10890101,10890148,10890157,10890158,10890159,10890160,10885313,10885316,10885362,10631994,10632010,10632011,10632012,10632013,10632014,10632018,10887544,10887545,10887546,10887607,10887608,10887724,10627321,10882916,10883067,10883137,10883143,10627793,10883304,10883358,10883359,10883378,10883392,10883396,10883397,10883398,10883407,10883414,10888437,10888457,10883457,10883458,10883459,10883460,10888463,10630026,10630029,10630030,10630033,10630034,10630040,10630043,10630044,10630045,10630047,10630048,10630049,10630050,10630051,10630052,10630053,10630054,10630055,10630056,10630057,10630058,10630059,10630060,10630061,10630062,10630063,10630064,10630065,10630066,10630067,10630069,10630071,10630072,10630073,10630074,10630075,10630076,10630077,10630079,10630080,10630081,10630082,10630083,10630084,10630085,10630086,10630087,10630088,10630090,10630091,10630092,10630093,10630094,10630095,10630096,10630097,10630098,10161705,10885763,10885867,10886057,10886058,10886059,10886060,10886062,10886063,10162081,10162177,10881538,10886589,10886850,10886918,10167934,10168012,10168029,10882061,10887072,10882284,10882353,10585350,10582561,10422688,10422689,10422690,10422691,10422692,10422693,10422695,10422696,10422697,10422698,10422699,10425090,10425091,10425092,10425093,10487111) 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'