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,10200001,8067910,8067911,8067912,10195163,10195164,10195502,10195952,10196489,10931197,8860355,8860356,8860357,8860358,8860359,8860395,8860410,10618178,10618179,10618180,10618181,10190301,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,10190001,10190002,10190003,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,7059715,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,10614363,10614377,10614475,10614476,10614486,10614518,10614548,10614549,10614550,10614551,10614552,10614553,10614554,10614555,10614588,10614593,10614596,6666255,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,10612320,10612321,10612342,8862510,8862530,8862531,8862554,8862567,10612724,10612725,10612734,7058247,7058248,10612746,7058249,7058250,10612763,10612765,10612766,10612782,10612884,10612893,10612894,10612909,10612916,10612951,10612952,7058472,10613019,10613020,10613021,10613022,10613023,10613024,10613025,10613026,10613027,10613097,10613098,10613099,10613100,10613101,10613102,10613103,10613104,10613105,10613106,10613107,10613108,10613109,10613110,10613111,10613112,10613113,10613114,10613115,10613116,10613117,10613168,10613223,10613318,10613337,10613346,10613347,10613348,10613349,10613693,10613743,10613744,7055488,7055489,7055490,7055491,7055492,7055493,7055494,7055495,7055534,9169377,9169434,9169454,9169455,9169524,9169525,9169526,9169527,9169528,7055724,7055725,9169636,9169751,9169763,9169864,9169865,9169866,9169901,9169968,9169972,9169973,9169974,9169975,9169976,9169977,9169978,9169979,9169980,7056193,10416237,9168330,9168331,9168332,9168333,9168334,9168335,9168336,10419258,10416258,9168337,9168338,9168339,9168340,9168341,9168342,9168343,9168344,9168345,9168346,9168347,9168348,9168349,9168350,9168351,9168352,9168353,10419275,10418275,9168354,10418276,10419276,9168355,10418277,9168356,10418278,10419279,9168357,10418279,9168358,10418280,10419281,9168359,9168360,10419282,9168361,9168362,9168363,9168364,9168365,9168366,10416288,9168367,10416289,9168368,10419290,10416290,10416291,9168377,10418323,10418324,10418325,10419339,10419340,10419351,10419352,10417373,10417374,9168453,10417375,10417376,10417377,10417378,9168458,9168459,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,10419493,10419494,10416496,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,10419592,10418592,10419593,10416593,10418593,10419594,10416594,10418594,10418595,10416595,10419595,10416596,10418596,10416597,10418597,10416598,10418598,10418599,10416599,10416600,10418600,10416601,10418601,10416602,10418602,10416603,10418603,10416604,10418604,10416605,10418605,10416606,10418606,10416607,10418607,10416608,10418608,10418609,7054861,10418622,10418623,10418624,10418625,10418626,10418627,10418628,10418629,10418630,10418631,10418632,10418633,10418634,10418635,10418636,10417637,10418637,10416638,10418638,10416639,10418639,10418640,9168719,10418641,9168720,9168721,10418645,10418646,10418647,10418648,10418649,10418650,10418651,10418652,10418653,10418654,10418655,10418656,10418657,10418658,10418659,10418660,10418661,10418662,10418663,10418664,9168756,9168757,9168758,10417712,10417713,10419802,10419803,10419804,10419805,10419806,10418806,10419807,10418807,10419808,10418808,10419809,10418809,10418810,10417811,10418811,10417812,10418812,10418813,10417814,10418814,10418815,10417816,10418816,10418817,10417818,10418818,10418819,10417820,10418820,10418821,10417822,10418822,10418823,10417824,10418824,10418825,10417826,10418826,10418827,10417828,10418828,10418829,10417830,10418830,10418831,10417832,10418832,10418833,10417834,10418834,10418835,10418836,10417837,10418837,10418838,10417839,10418839,10418840,10417841,10418841,10418842,10417843,10418843,10418844,10417845,10418845,10418846,10417847,10418847,10418848,10417849,10418849,10417850,10418850,10418851,10417852,10418852,10418853,10417854,10418854,10418855,10417856,10418856,10418857,10417858,10418858,10418859,10417860,10418860,10418861,10417862,10418862,10418863,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,10418063,10418065,10418067,10419183,10419201,9161280,10419202,9161281,10419203,10419204,10419205,10419206,10419207,10419208,10419209,10468876,10469151,10471152,10469152,10471153,10469153,10469154,10469155,10469156,10469157,10469503,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,10468177,10468178,10468349,10468350,10468351,10468352,10468353,10468354,10468355,10468356,10468357,10468358,10468359,10468360,10468361,10468362,10468363,10468364,10468365,10468366,10468367,10468368,10468369,10468370,10468371,10468372,10468373,10468374,10468375,10468376,10468377,10468378,10468379,10468380,10468381,10468382,10468383,10468384,10468385,10468386,10468387,10468388,10468389,10468390,10468391,10468392,10468393,10468394,10468395,10468396,10468397,10468398,10468399,10468400,10468401,10468402,10468403,10468404,10468405,10468406,10468407,10468408,10468409,10468410,10468411,10468412,10468413,10468414,10468415,10468416,10468417,10468418,10468419,10468420,10468421,10468422,10468423,10468424,10468425,10468426,10468427,10468428,10468429,10468430,10468431,10468432,10468433,10468434,10468435,10468436,10468439,10468498,10468499,10468500,10468501,10468502,10468503,10468504,10470698,10470699,10470700,10470701,10470702,10468798,10468799,10468800,10468801,10468802,10468803,10468804,10468805,10468806,10468807,10468808,10468809,10468810,10468811,10468812,10468813,10468814,10468815,10468816,10468817,10468852,10468853,10468854,10468855,10468856,10468857,10468858,10468859,10468860,10468861,10468862,10468863,10468864,10468865,10468866,10468867,10468868,10468869,10468870,10468871,10468872,10468873,10468874,10468875,10628152,10628153,10628154,10628312,10628321,10632300,10632301,10632302,10627304,10153837,10153838,10153839,10153840,10153841,10153842,10153843,10153844,10627712,10627771,10521608,10522594,10522595,10472594) 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'