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(4970195,4970228,4970241,4970268,4970311,4970322,4970343,4970344,4970345,4970346,4970347,4970407,4970408,4970450,4970478,4970479,4970480,4970501,4970503,4970508,4970509,4970510,4970511,4970512,4970513,4970520,4970521,4970522,4970556,4970569,4970585,4970595,4970612,4970659,4970660,4970661,4970662,4970663,4970664,4970665,4970667,4970668,4970672,4970676,4970677,4970688,4970694,4970700,4970725,4970726,4970736,4970738,4970740,4970859,4970860,4970861,4970885,4970900,4970910,4970912,4970914,4970925,4970928,4970929,4970940,4970954,4970959,4970960,4970961,4970966,4970968,4970974,4970975,4970989,4971043,4971082,4971091,4971112,4971128,4971151,4968156,4968169,4968170,4968171,4968207,4968210,4968220,4968230,4968231,4968240,4968324,4968325,4968333,4968384,4968448,4968468,4968483,4968508,4968514,4968521,4968527,4968536,4968577,4968578,4968579,4968580,4968592,4968605,4968606,4968621,4968646,4968751,4968760,4968798,4968806,4968807,4968818,4968836,4968839,4968845,4968846,4968858,4968859,4968861,4968862,4968866,4968919,4968948,4968950,4968952,4968953,4969000,4969010,4969018,4969019,4969024,4969032,4969041,4969049,4969058,4969070,4969102,4969103,4969104,4969105,4969106,4969123,4969127,4969151,4969172,4969173,4969174,4969185,4969209,4969211,4969221,4969274,4969275,4969276,4969277,4969303,4969344,4969346,4969360,4969361,4969362,4969363,4969378,4969387,4969422,4969423,4969424,4969437,4969442,4969444,4969446,4969449,4969463,4969467,4969499,4969501,4969551,4969563,4969564,4969565,4969566,4969567,4969569,4969582,4969584,4969585,4969595,4969637,4969638,4969642,4969643,4969648,4969654,4969655,4969656,4969657,4969673,4969679,4969681,4969682,4969683,4969685,4969713,4969724,4969736,4969741,4969742,4969743,4969744,4969745,4969746,4969747,4969766,4969804,4969810,4969827,4969838,4969868,4969888,4969889,4969922,4969953,4969954,4969955,4969970,4970034,4970035,4970036,4970080,4970144,8075064,8075065,8075066,8075067,8075068,8075111,8075112,8075113,8075114,8075115,8075220,8075221,8075222,8075260,8075275,8075276,8075277,8075281,8075386,8075387,8075388,8075389,8075390,8075391,8075392,8075393,8075394,8075397,8075398,8075399,8075428,8075429,8075430,8075431,8075443,8075444,8075445,8075446,8075447,8075459,8075460,8075461,8075462,8075494,8075495,8075496,8075497,8075498,8075499,8075500,8075501,8075502,8075503,8075504,8075505,8075506,8075507,8075508,8075509,8075510,8075511,8075512,8075513,8075514,8075515,8075516,8075517,8075518,8075519,8075520,8075535,8075536,8075537,4967044,4967093,4967096,4967111,4967122,4967129,4967139,4967163,4967183,4967184,4967185,4967187,4967192,4967212,4967213,4967249,4967255,4967256,4967258,4967303,4967320,4967333,4967353,4967354,4967356,4967365,4967366,4967367,4967368,4967369,4967370,4967388,4967395,4967397,4967398,4967416,4967419,4967430,4967548,4967557,4967558,4967589,4967610,4967613,4967614,4967634,4967636,4967638,4967676,4967706,4967707,4967721,4967751,4967776,4967787,4967818,4967829,4967841,4967854,4967855,4967906,4967907,4967908,4967909,4967910,4967911,4967912,4967913,4967914,4967915,4967916,4967917,4967918,4967919,4967920,4967921,4967922,4967923,4967924,4967925,4967926,4967927,4967928,4967929,4967930,4967937,4967938,4967939,4967940,4967985,4968008,4968014,4968039,4968041,4968042,4968071,4968114,4968124,4968135,8073895,8073896,8073897,8073898,8073899,8073941,8073942,8073943,8073944,8073945,8073946,8074253,8074254,8074255,8074256,8074257,8074258,8074301,8074302,8074303,8074304,8074305,8074306,8074541,8074542,8074543,8074544,8074545,8074546,8074590,8074591,8074592,8074593,8074594,8074595,8072298,8072299,8072300,8072301,8072302,8072383,8072460,8072647,8072652,8072657,8072662,8072663,8072664,8072665,8072666,8072667,8072672,8072677,8072682,8072687,8072692,8072697,8072702,8072707,8072712,8072717,8072718,8072719,8072720,8072721,8072722,8072727,8072732,8072737,8072742,8072747,8072752,8072757,8072762,8072763,8072764,8072765,8072766,8072767,8072772,8072777,8072782,8072787,8072792,8072957,8072965,8072996,8073467,8073468,8073469,8073470,8073471,8073472,8073473,8073474,8073475,8073476,8073477,8073478,8073479,8073581,8073582,8073583,8073584,8073585,8073630,8073631,8073632,8073633,8073634,10623055,10623057,10623125,10623150,10623156,10623157,10623158,10623159,10623161,10623162,10623174,10623175,10623176,10623178,10623179,10623195,10623203,10623209,10623210,10623211,10623212,10623213,10623214,10623235,10623241,10623253,10623272,10623273,10623274,10623279,10623303,10623307,10623353,10623386,10623387,10623388,10623389,10623390,10623391,10623392,10623393,10623394,10623447,10623470,10623471,10623472,10623473,10623474,10623491,10623560,10623562,10623616,10623617,10623644,10623645,10623646,10623680,10623681,10623682,10623736,10623959,10624024,10624025,10624196,10624197,10624198,10624199,10624200,10624404,10624425,10624560,10624572,10624640,10624659,10624717,10624718,10624729,10624730,10624731,10624753,10624777,10624778,10624779,10624780,10624781,10624782,10624783,10624784,10624785,10624846,10624913,10621976,10622099,10622100,10622115,10622166,10622167,10622188,10622189,10622247,10622257,10622290,10622298,10622303,10622305,10622307,10622331,10622366,10622371,10622372,10622373,10622375,10622397,10622398,10622399,10622420,10622486,10622487,10622488,10622489,10622519,10622521,10622524,10622525,10622526,10622527,10622528,10622529,10622530,10622531,10622548,10622563,10622564,10622569,10622593,10622594,10622634,10622694,10622695,10622696,10622697,10622698,10622699,10622700,10622779,10622798,10622799,10622800,10619983,10620019,10620027,10620039,10620080,10620089,10620092,10620107,10620133,10620134,10620142,10620172,10620184,10620378,10620426,10620433,10620435,10620436,10620446,10620447,10620448,10620459,10620468,10620480,10620481,10620482,10620565,10620606,10620615,10620620,10620621,10620622,10620623,10620634,10620635,10620636,10620646,10620651,10620792,10620793,10620796,10620841,10620848,10620874,10620896,10620902,10620903,10620904,10620935,10620948,10620949,10620959,10620960,10620961,10620962,10620963,10620964,10620965,10620966,10620967,10620968,10620969,10620970,10620971,10620972,10620973,10620974,10620975,10620976,10620977,10620978,10620979,10620980,10621053,10621062,10621065,10621198,10621201,10621202,10621203,10621208,10621211,10621212,10621219,10621364,10621444,10621459,10621460,10621461,10621462,10621463,10621480,10621481,10621482,10621483,10621484,10621485,10621546,10621548,10621549,10621550,10621551,10621552,10621554,10621555,10621558,10621560,10621728,10621729,10621730,10621755,10621756,10621757,10621758,10621759,10621760,10621761,10621762,10621765,10621770,10621811,10565130,10565131,10565153,10565154,10565159,10565170,10565181,10565261,10565262,10565263,10565264,10565265,10565266,10565267,10565268,10565269,10565270,10565271,10565272,10565273,10565274,10565275,10565276,10565277,10565278,10565279,10565280,10565281,10565282,10565283,10565284,10565285,10565286,10565287,10565288,10565289,10565290,10565291,10565292,10565293,10565294,10565295,10565296,10565299,10565300,10565301,10565302,10565324,10565325,10565326,10565327,10565347,10565350,10565354,10565356,10565365,10565381,10565382,10565384,10565396,10565397,10565399,10565483,10565550,10565551,10565569,10565570,10565571,10565572,10565632,10565674,10565675,10565677,10565680,10566009,10566061,10566062,10566088,10566091,10566092,10566097,10566102,10566110,10563115,10563130,10563131,10563132,10563137,10563150,10563169,10563184,10563185,10563186,10563217,10563218,10563226,10563229,10563231,10563232,10563235,10563244,10563253,10563254,10563256,10563260,10563273,10563274,10563276,10563277,10563281,10563282,10563283,10563284,10563285,10563286,10563293,10563294,10563296,10563300,10563328,10563329,10563330,10563331,10563332,10563333,10563334,10563335,10563336,10563337,10563338,10563342,10563343,10563357,10563358,10563359,10563360,10563361,10563362,10563363,10563364,10563365,10563397,10563413,10563423,10563424,10563425,10563441,10563449,10563531,10563541,10563650,10563667,10563668,10563669,10563697,10563701,10563702,10563703,10563704,10563705,10563706,10563707,10563708,10563710,10563711,10563712,10563713,10563836,10563838,10563841,10563849,10563854,10563855,10563867,10563879,10563938,10563962,10564130,10564131,10564137,10564138,10564162,10564163,10564165,10564181,10564186,10564187,10564198,10564201,10564427,10564429,10564467,10564484,10564485,10564552,10564553,10564564,10564567,10564592,10564618,10564687,10564702,10564743,10564753,10564764,10564768,10564820,10564821,10564823,10564824,10564936,10564941,10565034,10565073) 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'