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(4970707,4970727,7065934,7065935,7065953,7065984,7065985,7065991,7065992,7065993,7066033,7066034,7066035,7066036,7066037,7066038,7066039,7066040,7066041,7066042,7066043,7066044,7066045,7066172,7066181,7066182,7066239,10437196,10437197,10437198,10437199,7066259,8067910,8067911,8067912,10939396,10939399,10939400,10939401,10939402,8065801,8065852,8970177,10931197,8860355,8860356,8860357,8860358,8860359,8860395,8860410,10618178,10618179,10618180,10618181,10618300,10618301,10618304,10618325,10623491,10623492,10623505,8070776,8070777,8070778,10616962,10616963,10616964,10616965,10616966,10616967,10616968,10616969,10616970,10616971,10616972,10617042,10617054,10617055,10617056,10617108,10617134,10617162,10617163,10617213,10617214,10617215,10617216,10617217,10622258,10622264,10622265,10622266,10622267,10622268,10622360,10622405,10622408,10622431,10622447,10617448,10617476,10617477,10622514,10622516,10622523,10615014,10615019,10615055,10615061,10615232,10615260,10615261,10615262,10615263,10615317,10615371,10615389,10615393,10615499,10615500,10615501,10615502,10615503,10615504,10615505,10615506,10615507,10615508,10615509,10615510,10615511,10615512,10615513,10615514,10615515,10615516,10615517,10615568,10615569,10615570,10615668,10615746,10615859,10615860,10615971,10615972,10615979,10615980,10616175,10616537,10616644,10616911,10616956,10616957,10616958,10616959,10616960,10616961,10611135,10611136,10611137,10611138,10611139,10611140,10611141,10611142,10611143,10611144,10611145,10611146,10611147,10611148,10611149,10611150,10614227,10614228,10614229,10614230,10614231,10614232,10614233,10614234,10614235,10614236,10614237,10614238,10614239,10614240,10614241,10614242,10614243,10614244,10614245,10614246,10614247,10614248,10614249,10614250,10614251,10614252,10614253,10614254,10614255,10614256,10614257,10614258,10614259,10614260,10614261,10614262,10614263,10614264,10614265,10614266,10614267,10614268,10614269,10614270,10614271,10614272,10614273,10614314,10611342,10614363,10614377,10614475,10614476,10614486,10614518,10614548,10614549,10611550,10614550,10614551,10614552,10614553,10614554,10614555,10614588,10614593,10614596,10611684,10611697,10611698,10611705,10611706,10611707,10611709,10611711,10611764,10611778,10611783,10611784,10611785,10611786,10611787,10611788,10611789,10611790,10611791,10611792,10611793,10611794,10611795,10611796,10611797,10611798,10611799,10611800,10611801,10611802,10611803,10611804,10611805,10611806,10611807,10611808,10611809,10611810,10611811,10611812,10611813,10611814,10611815,10611816,10611817,10611818,10611819,10611820,10611821,10611822,10611823,10611824,10611825,10611826,10611827,10611828,10611829,10611830,10611831,10611832,10611833,10611834,10611835,10611836,10611837,10611838,10611839,10611840,10611841,10611842,10611843,10611844,10611845,10611846,10611847,10611848,10611849,10611850,10611851,10611852,10611853,10611854,10611855,10611856,10611857,10611858,10611859,10611860,10611861,10611862,10611863,10611864,10611865,10611866,10611867,10611868,10611869,10611870,10611871,10611872,10611873,10611874,10611875,10611876,10611877,10611878,10611879,10611880,10611881,10611882,10611883,10611884,10611885,10611886,10611887,10611888,10611889,10611890,10611891,10611892,10611893,10611894,10611895,10611896,10611897,10611898,10611899,10611900,10611901,10611902,10611903,10611904,10611905,10611906,10611907,10611908,10611909,10611910,10611911,10611912,10611913,10611914,10611915,10611916,10611917,10611918,10611919,10611920,10611921,10611922,10611923,10611924,10611925,10611926,10611927,10611928,10611929,10611930,10611931,10611932,10611933,10611934,10611935,10611936,10611937,10611938,10611939,10611940,10611941,10611942,10611943,10611944,10611945,10611946,10611947,10611948,10611949,10611950,10611951,10611952,10611953,10611954,10611955,10611956,10611957,10611958,10611959,10611960,10611961,10611962,10611963,10611964,10611965,10611966,10611967,10611968,10611969,10611970,10611971,10611972,10611973,10611974,10611975,10611976,10611977,10611978,10611979,10611980,10611981,10611982,10611983,10611984,10611985,10611986,10611987,10611988,10611989,10611990,10611991,10611992,10611993,10611994,10611995,10611996,10611997,10611998,10611999,10612000,10612001,10612002,10612003,10612004,10612005,10612006,10612007,10612008,10612009,10612010,10612011,10612012,10612053,10612060,10612069,10612082,10612083,10612179,10612189,10612190,10612191,10612192,10612193,10612194,10612195,10612196,10612197,10612198,10612199,10612200,10612201,10612202,10612203,10612204,10612205,10609305,10612320,10612321,10612342,10609393,10612724,10612725,10612734,10612746,10612763,10612765,10612766,10612782,10612884,10612893,10612894,10612909,10612916,10612951,10612952,10610007,10610016,10613019,10613020,10613021,10613022,10613023,10613024,10613025,10610026,10613026,10613027,10613097,10613098,10613099,10613100,10613101,10613102,10613103,10613104,10613105,10613106,10613107,10613108,10613109,10613110,10613111,10613112,10613113,10613114,10613115,10613116,10613117,10610150,10610151,10613168,10613223,10610270,10610271,10610272,10610273,10610274,10610275,10610276,10610277,10610278,10610279,10610280,10610281,10610282,10610283,10610284,10610285,10610286,10610287,10610288,10610289,10610290,10610291,10610292,10610293,10610294,10610295,10610296,10610297,10610298,10610299,10613318,10613337,10613346,10613347,10613348,10613349,10610361,10610397,10610415,10610492,10610493,10610502,10610689,10613693,10610696,10613743,10613744,10610795,10610796,10610797,10610798,10610799,10610800,10610801,10610802,10610803,10610804,10610805,10610806,10610807,10610808,10610809,10610810,10610811,10610812,10610813,10610814,10610815,10610816,10610817,10610818,10610819,10610820,10610821,10610822,10610823,10610824,10610825,10610826,10610827,10610828,10610829,10610830,10610831,10610832,10610833,10610834,10610835,10610836,10610917,10610918,10610919,10610958,10416237,10419258,10416258,10418275,10419275,10418276,10419276,10418277,10418278,10418279,10419279,10418280,10419281,10419282,10416288,10416289,10419290,10416290,10416291,10415322,10418323,10418324,10418325,10419339,10419340,10419351,10419352,10415373,10417373,10415374,10417374,10417375,10417376,10415377,10417377,10417378,10417398,10417399,10417400,10417401,10417402,10417405,10417406,10417407,10417408,10417424,10419427,10419428,10419429,10419430,10419431,10419432,10419433,10419434,10419435,10419436,10417443,10417444,10417445,10417446,10417447,10417448,10417449,10417450,10417451,10417452,10417453,10417454,10417455,10417456,10417457,10417458,10417459,10417460,10417461,10417462,10417463,10417464,10417465,10415491,10419493,10419494,10416496,10415500,10415509,10416514,10416515,10416516,10416517,10416518,10416519,10416520,10416521,10416522,10416523,10416524,10416525,10416526,10416527,10416528,10416529,10416531,10417532,10416532,10417535,10416549,10416568,10418585,10418586,10418587,10418588,10418589,10418590,10418591,10418592,10419592,10418593,10419593,10416593,10418594,10416594,10419594,10418595,10416595,10419595,10418596,10416596,10418597,10416597,10418598,10416598,10418599,10416599,10418600,10416600,10418601,10416601,10418602,10416602,10418603,10416603,10418604,10415604,10416604,10418605,10415605,10416605,10418606,10415606,10416606,10418607,10415607,10416607,10418608,10415608,10416608,10415609,10418609,10415616,10418622,10418623,10418624,10418625,10418626,10418627,10418628,10418629,10418630,10418631,10418632,10418633,10418634,10418635,10418636,10418637,10417637,10418638,10416638,10418639,10416639,10418640,10418641,10418645,10418646,10418647,10418648,10415648,10418649,10415649,10418650,10415650,10418651,10415651,10418652,10418653,10418654,10415654,10418655,10418656,10418657,10415657,10418658,10415658,10418659,10418660,10415660,10418661,10415661,10418662,10415662,10418663,10418664,10415686,10417712,10417713,10415743,10419802,10419803,10419804,10419805,10418806,10419806,10418807,10419807,10419808,10418808,10418809,10419809,10418810,10418811,10417811,10418812,10417812,10418813,10418814,10417814,10418815,10417816,10418816,10418817,10418818,10417818,10418819,10418820,10417820,10418821,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,10416060,10416061,10416062,10416063,10418063,10416064,10418065,10418067,10471152,10471153,10467633,10467804,10467805,10467806,10467807,10467808,10467809,10467810,10467811,10467812,10467813,10469929,10469930,10470097,10470098,10470099,10470100,10470101,10470102,10470103,10470104,10470105,10470106,10470107,10470108,10470109,10462301,10470698,10470699,10470700,10470701,10470702) 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'