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(10939537,7067840,7067841,10943453,4970450,10940075,4970699,10943898,4970724,10940293,8569558,10940434,7065856,7066017,7066141,7066250,7066260,7066481,10938599,10938692,10938697,10938943,10938959,10938960,10938983,10939126,10939149,10939150,10939240,10939297,10939300,10939306,10939314,10939322,10939324,10939336,10939417,10939507,10939511,10939524,10959615,10931546,10931547,7072154,8065567,7064546,8065624,8065640,8065804,7065177,10986956,7065342,8860816,10942777,10958949,10958961,8064520,10940674,10941009,8859543,10941367,10941406,10941443,7070156,7070322,8860263,8860272,8860329,8860372,8860389,8860445,10942264,10623053,10623060,10623067,10623176,10618178,10618179,10618180,10618181,10928736,10618276,10618281,10618294,10618295,10618297,10618330,10618331,10618332,10619928,10621964,10621965,10616984,10617021,10617022,10617043,10617109,10617112,10617119,10617160,10622196,10617208,10617455,10954220,10954221,10954222,10617777,10617805,10954397,10954398,10620116,10620117,10615118,10620118,10615120,10615121,10615123,10615124,10615126,10615142,10620200,10620201,10620202,10615202,10615295,10615296,10615298,10615299,10615302,10615303,10615304,10615305,10615548,10615581,10620584,10620587,10620588,10615623,10615689,10615693,10615695,10615700,10615701,10615702,10615705,10615706,10615724,10615754,10615926,10615946,10620978,10615981,10616048,10616049,10616050,10616052,10621359,10616419,10616435,10616548,10616781,10616782,10616783,10616790,10616840,10616841,10621951,10621956,10611053,10611054,10611095,10611098,10611102,10611103,9165459,9165460,10611162,10614250,10614252,10614253,10614254,10611267,10614274,10614282,10614289,7059798,10611319,10611328,10611334,10611336,10611353,10614355,10611372,10614450,10614518,10614521,10614529,10614530,10614533,10614538,10614543,10614549,10614552,10614553,10614554,10614556,10614558,10614560,10614563,10614566,10614567,10614568,10614572,10614573,10559766,10611696,10611708,10614718,10614733,10614742,10614749,10611823,10611856,10614858,10614859,10611864,10611868,10611870,6666285,6666286,6666287,10611999,10609020,10612041,10612069,10612073,10612074,10612075,10612076,10609081,10609082,10609088,10609095,10612221,10612240,10612241,10612254,10609265,10609273,10612286,10609336,10612381,10609389,10612399,10612400,10612401,10612402,10612403,10612428,10609469,10612483,10612484,10612485,10612486,10612487,10612488,10612489,10612490,10609490,10612491,10612492,10609492,10612493,10609493,10612496,10612497,10612498,10612499,10612506,10612513,10612516,10612517,10612518,10612519,10612520,10612521,10612522,10612523,10612524,10612525,10612526,10612527,10612529,10612535,10612539,10612542,10612546,10612547,10612551,10612552,10612553,10612554,10612556,10612557,10612558,10612562,10609564,10612565,10609565,10612566,10612567,10612570,10612571,10612573,10612579,10612580,10612583,10612584,10612585,10612586,10612587,10612588,10612589,10612592,10612596,10612597,10609597,10612599,10609599,10612601,10609601,10609602,10612604,10609604,10609605,10612608,10612609,10612611,10612618,10612623,10612625,10612626,10612631,10612637,10612639,10612641,10612644,8862503,10612645,7058150,10612647,10612648,10612651,10612655,10612657,10612660,8862522,10612663,10612664,10612666,10612667,8862526,10612668,10612673,10612678,10612679,10612680,10612682,10612683,10612684,10612685,10612688,10612689,10612690,8862554,10612697,10612698,10612699,10612700,10612701,10612702,10612703,10612704,10612705,10612706,10612707,10609709,10612711,10612715,10612717,10612718,10612720,10612721,10612722,10612723,10612753,10612758,10612772,10609772,10609774,10609775,10609782,10612791,10612792,10612809,10609823,10609828,10612833,10612834,10612836,10609836,10612837,10612838,10612841,10612842,10612843,10612844,10612846,10612853,10612862,10612863,10609865,10612865,10609866,10612866,10612867,10612868,10612869,10612870,10612871,10612872,10612873,10612874,10612875,10612876,10612877,10612878,10612879,10612881,10612889,10612897,10612907,10612914,10612916,10609967,10609999,10610006,10613023,10610023,10610026,10610054,10613055,10610175,10610176,10610177,10610178,10610180,10610190,10610197,10610233,10613264,10610282,10613292,8863159,10610318,10610319,10610334,10610339,10610340,10610341,10610342,10610343,10610344,10610345,10613388,10613393,10613421,10613422,10613430,10613431,10613432,10613434,10613445,10613455,10613478,10613481,10613484,10613488,10613503,10613504,10613505,10613507,10613512,10613513,10613514,10613520,10613521,10613522,10613525,10613526,10613527,10613528,10613530,10613531,10613550,10613554,10613555,10613559,10613561,10613562,10613563,10613676,10610678,10610723,10610725,10610728,10610740,10610742,10610747,10610748,10610750,10610751,10613753,10613754,10610778,10610836,10613838,10610844,10610847,10610848,10610849,10613857,10610878,10610879,10613879,10610880,10610901,10610942,10515113,10515114,7055538,7055539,7055542,7055586,7055596,2809210,2809239,2809302,10516919,10516920,10419254,10419257,10419259,10419262,10419269,10419270,10419273,10419274,10419275,10419276,10419286,10417286,10415323,10415326,10419342,10416378,10416379,10416380,10419382,10419383,10419385,10415472,10415473,10419473,10419474,10419477,10419479,10419480,10419481,10419484,10419485,10419487,10416488,10419489,10419491,10417529,10415549,10415561,10415575,10415576,10415579,10415584,10415587,10415588,10415589,10415590,10419602,10419603,10419607,10419610,10419614,10415617,10415618,10415619,10415621,10419622,10415623,10419623,10415626,10419627,10415628,10415630,10415631,10419632,10419633,10416638,10416639,10419641,10417641,10419642,10419651,10416652,10419652,10416653,10416654,10419663,10415664,10415665,10415666,10415667,10415668,10415669,10415670,10415671,10415672,10415673,10415675,10415676,10415677,10415678,10415679,10415680,10418746,10416783,10416787,10417811,10416811,10417812,10416812,10417813,10417814,10417815,10417816,10417817,10417818,10417819,10417820,10417821,10417822,10417823,10417824,10417825,10417826,10417827,10417828,10417829,10417830,10417831,10417832,10417833,10417834,10417835,10417836,10417837,10417838,10417839,10417840,10417841,10417842,10417843,10417844,10417845,10417846,10417847,10415848,10417848,10417849,10417850,10417851,10415852,10417852,10415853,10417853,10415854,10417854,10417855,10417856,10415857,10417857,10415858,10417858,10415859,10417859,10417860,10417861,10417862,10415862,10417863,10415863,10417864,10415864,10417865,10415865,10417866,10417867,10415867,10417868,10417869,10417870,10417871,10417872,10415872,10417873,10417874,10417875,10417876,10417877,10417878,10417879,10417880,10417881,10417882,10417883,10417884,10417885,10417886,10417887,10417888,10417889,10417890,10417891,10417892,10415892,10417893,10415893,10417894,10415894,10417895,10417896,10417897,10417898,10417899,10417900,10417901,10417902,10417903,10415903,10417904,10415904,10417905,10415905,10417906,10415906,10417907,10415907,10417908,10415908,10417909,10417910,10417911,10417912,10415912,10417913,10417914,10417915,10417916,10415916,10417917,10419917,10415917,10417918,10415918,10417919,10415919,10417920,10417921,10417922,10417923,10417924,10417925,10417926,10417927,10417928,10417929,10417930,10417931,10417932,10417933,10417934,10417935,10417936,10417937,10417938,10417939,10417940,10417941,10417942,10417943,10417944,10417945,10417946,10417947,10417948,10417965,10417973,10417974,10417975,10417976,10417977,10417980,10418997,10418998,10418999,10417999,10418001,10418002,10418003,10418004,10418005,10418006,10418007,10418009,10418010,10418011,10418012,10418013,10418015,10418016,10418018,10418019,10418024,10420025,10418026,10418029,10418037,10418038,10418039,10418040,10418041,10416076,10416113,10416114,10416117,10416118,10419126,10419128,10419142,10419144,7055442,7055454,10471055,10471141,10471144,10471147,10469165,10469167,10469281,10469282,10469284,10469285,10469287,10469455,10463541,10467576,10467600,10469637,10469638,8916797,10463981,10463982,10468121,10468122,10468125,10468132,10470150,10470155,10470164,10470165,10470166,10470195,10470204,10470205,10468228,8563583,10468369,10468370,10468371,10468372,10468373,10468374,10468507,10468522,10468556,10470657,10468785,10468786,10468787,10468788,10468789,10468790,10470790,10628084,10628085,10628152,10155553,10627319,10627323,10627324,10627325,10627326,10627327,10627328,10627329,10627330,10627331,10627666,10627667,10627712,10627792,10627793,10625032,10625083,10625209,10625214,10625239,10625240,10625372,10625407,10631058,10626114,10626198,10626225,10626226,10626227,10626228,10626258,10626292,10626293,10626431,10626442,10631461,10631462,10631463,10631464,10626509,10631792,10631793,10631794,10631795,10626901,10626952,10522580,10522581,10522582,10522583,10522584,10522585,10522586,10522839,10420247,10420248,10420249,10420250,10420251,10420252,10420253,10420254,10420255,10420256,10420257,10420258,10420259,10420260,10420261,10420262,10420263,10420264,10420265,10420266,10420267,10420268,10421541,10420716,10420768,10420769,10420770,10420771,10420772,10420773,10421833) 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'