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(7067824,7067838,7075873,7075912,7075913,7068072,10943628,7076123,7076124,7076125,7076126,7076127,7076128,7076129,10198396,10198397,4970670,4970671,4970675,4970731,4970732,4970733,4970734,8569474,8569605,8569615,7065830,7065831,7065832,7065833,7065834,7065835,7065836,7065837,7065838,7065839,7073938,7066178,7066265,7066266,7074294,7066348,7066375,7066378,7066379,7066381,7066453,10199769,7066766,10200021,10200022,10437751,10437753,7066825,10437774,7066836,8067931,8067943,7075070,7075073,7067102,7067134,7067196,7067425,7067452,7075498,7075578,7075771,7075773,7075776,7067815,7071829,6000119,7071911,6000194,6000195,6000196,6000197,6000198,6000199,7071983,7064355,7072474,8075333,8075334,8075335,8075336,7072545,7064592,7064733,7064735,7064736,7064747,7064748,7064751,7064754,7064756,7064760,7064761,7064771,7064822,7064856,7064863,7064878,7064892,10196145,7064911,7064912,7064926,7064932,7064935,7064947,7064977,7064983,7064984,7064985,7064986,7065004,7073166,7073299,7073300,7073317,7065421,7073531,7073534,10196984,7065750,10942913,7071274,10943257,10194896,10194897,10194898,10945086,10945101,7069606,7069718,7069719,10941948,8860412,8860418,8860419,8860420,8860554,10942401,10942410,10190224,8070049,8070054,8070057,8070061,8070094,8070101,8070107,8070111,8070125,8070131,8070134,8070136,8070139,8070149,8070152,8070157,8070168,8070171,8070172,8070178,8070180,8070186,8070189,8070196,8070198,8070212,8070214,8070219,8070224,8070225,8070230,8070234,8070237,8070314,8070319,10624632,10624633,10619864,10619865,10619866,10619928,10617322,10617323,10617324,10617325,10617326,10617327,10617328,10617329,10617330,10617331,10617332,10617333,10617334,10617335,10617336,10617337,10617338,10617339,10617340,10617341,10617342,10617343,10617344,10617345,10617346,10617347,10617348,10617349,10617350,10617351,10617352,10617353,10617354,10617355,10617356,10617357,10617358,10617359,10617360,10617361,10617362,10617363,10617364,10617365,10617366,10617367,10617368,10617369,10617370,10617371,10617372,10617373,10617374,10617375,10617376,10617377,10922895,10617378,10922896,10617379,10617380,10617381,10922899,10617382,10922900,10617383,10617384,10617385,10617386,10617387,10617388,10617389,10617390,10617391,10617392,10617393,10617394,10617395,10617396,10617397,10617398,10617399,10617400,10617401,10617402,10617403,10617404,10617405,10617406,10617407,10617408,10617409,10617410,10617411,10617412,10617413,10617414,10617415,10617416,10617417,10617418,10617419,10617420,10617421,10617422,10617423,10617424,10617425,10617426,10617427,10617428,10617429,10617430,10617431,10922949,10617432,10617433,10617434,10617435,10617436,10617437,10617438,10617439,10617440,10617441,10617442,10617443,10617444,10617445,10617446,10617447,10617448,10617449,10617450,10617451,10617452,10617453,10617454,10617455,10617456,10617457,10617458,10928007,10928008,10928009,10928010,10928011,10617511,10617512,10928301,10928302,10928303,10190017,10190018,10620117,10620118,10615167,8570011,10620208,10615222,10615229,10620297,10620298,10620301,10620302,10620303,10615338,10615339,10615340,10615341,10615342,10615343,10615344,10930631,10930665,10930666,10930667,10615889,10615890,10615891,10615892,10615893,10615894,10615895,10615896,10616005,10616006,10616023,10616044,10616045,10616059,10188366,10188367,10188377,10188378,10188379,10188380,10188381,10188382,10188383,10188384,10188385,10188386,10616332,10616417,10616426,10188656,10188657,10188658,10188659,10188665,10616648,10616649,10616905,10616906,10559609,10614495,10614496,10614497,10614498,10614499,10614500,10614501,10614502,10614503,10614504,10614505,10559705,10559706,10559715,10559716,10559717,10559718,10559719,10559720,10559721,10559722,10559723,10559724,10559725,10559726,10559744,10559745,10562767,10611969,10611970,10612086,10612104,10612105,10612106,10612107,10612131,8862099,8862146,10612292,10612293,10612294,10612295,10612381,8862394,8862480,8862481,10612916,10612935,10612936,10612937,10612938,10612939,10612940,10612941,10612942,10612943,10612959,10612961,8862850,8862865,10613135,10613136,10613137,10613144,10558303,10558304,10558317,10558318,10558319,10558320,10613369,10561523,10561524,10613736,10613737,10613738,10613739,10613740,10613750,10515280,10515281,10515282,10515327,10515328,10515329,10515377,10515422,10515423,10517614,10517615,10517616,10517617,10517618,10513622,10517670,10515683,10515684,10515685,10515686,10515687,10515688,10515689,10515690,10515691,10515692,10515693,10515694,10515695,10515696,10515697,10515698,10515699,10515700,10515701,10515702,10515703,10515704,10515705,10515706,10515707,10515708,10515709,10515710,10515711,10513974,10513975,10514015,10514037,10514038,10514090,10514091,10514092,10514093,10516128,10516129,10516130,10516131,10516132,10516157,10516158,10516160,10516161,10516162,10516163,10516164,10516165,10516166,10516171,10516172,10516173,10516174,10516175,10516176,10514364,10514388,10514389,10514390,10514402,10514405,10514406,10514407,10514410,10512530,10518648,10518649,10518650,10518651,10518652,10518653,10518654,10518655,10518656,10518657,10518658,10518659,10518660,10518661,10518662,10518663,10518664,10518665,10518666,10518667,10518668,10518669,10518670,10518671,10518672,10518673,10518674,10518675,10518676,10518677,10518678,10518679,10518680,10518681,10518682,10518683,10518684,10518685,10518686,10518687,10518688,10518689,10518690,10518691,10518692,10518693,10518694,10518695,10518696,10518697,10518698,10518699,10518700,10518701,10518702,10518703,10518704,10518705,10518706,10518707,10518708,10512782,10516865,10516866,10516867,10516910,10516911,10516912,10516913,10516914,10516915,10516916,10516917,10516918,10514964,10514965,10515072,10515087,10515088,10515089,10515090,10515091,10515092,10515093,10515094,10515095,10515096,10515097,10419307,10416348,10416349,10416350,10416351,10416352,10416353,10416354,10416355,10416356,10416357,10416358,10416359,10416360,10416361,10416362,10416363,4973308,10419468,10419469,10419470,10419471,10419472,10419473,10419474,10419475,10419476,10419477,10419478,10419479,10419480,10419481,10419482,10419483,10419484,10419485,10419486,10419487,10419488,10419489,10419490,10419491,10419492,10419493,10419494,10419495,10419496,10419497,10419498,10419499,10419500,10419501,10419502,10419503,10419504,10419505,10419506,10419507,10419508,10419509,10419510,10419511,10419512,10419513,10419514,10419515,10419516,10419517,10419518,10419519,10419520,10419521,10419522,10419523,10419524,10419525,10419526,10419527,10419528,10419529,10419530,10419531,10419532,10419533,10419534,10419535,10419536,10419537,10419538,10418543,10418544,10418545,10418546,4973643,4973736,10417053,10417054,10417055,10417056,10417057,10417058,10417059,10417060,10417061,10417062,10417063,10417064,10417065,10417066,10417067,10417068,10417069,10417070,10417071,10417072,10417073,10417074,10417075,10417076,10417077,10417078,10417079,10417080,10417081,10417082,10417083,10417084,10417085,10417086,10417087,10417088,10417089,10417090,10417091,10417092,10417093,10417094,10417095,10417096,10417097,10417098,10417099,10417100,10417101,10417102,10417103,10417104,10417105,10417106,10417107,10417108,10417109,10417110,10417111,10417112,10417113,10417114,10417115,10417116,10417117,10417118,10417119,10417120,10417121,10417122,10417123,10417124,10417125,10417126,10417127,10417128,10417129,10417130,10417131,10417132,10417133,10417134,10417135,10417136,10417137,10417138,10417139,10417140,10417141,10417142,10417143,10417144,10417145,10417146,10417147,10417148,10417149,10417150,10420150,10417151,10420151,10417152,10420152,10417153,10420153,10417154,10420154,10417155,10420155,10417156,10420156,10417157,10420157,10417158,10420158,10417159,10420159,10417160,10420160,10420161,10420162,10420163,10420164,10419165,10420165,10419166,10420166,10419167,10420167,10419168,10420168,10419169,10420169,10419170,10420170,10419171,10420171,10419172,10420172,10419173,10420173,10419174,10420174,10419175,10420175,10419176,10420176,10419177,10420177,10420178,10420179,10420180,10420181,10420182,10420183,10420184,10420185,10420186,10420187,10420188,10420189,10420190,10420191,10420192,10420193,10420194,10420195,10420196,10420197,10420198,10420199,10420200,10420201,10420202,10420203,10420204,10420205,10420206,10420207,10420208,10420209,10420210,10420211,10420212,10420213,10420214,10420215,10471171,10471172,10471173,10471174,10471175,10467217,10467218,10467219,10467220,10467221,10469277,10469278,10469573,10469949,10469950,4972257,10468234,10468235,10468236,10468237,10468323,10468324,10468325,10468326,10468327,10468328,10468329,10627985,10627986,10626963,10627319,10627405,10627775,10626143,10626144,10626145,10626241,10626299,10626300,10626301,10568112,10568113,10568114,10568115,10568116,10568117,10568118,10568119,10568120,10568121,10568122,10568123,10568124,10568125,10568126,10568127,10568128,10568129,10568130,10568294,10568295,10568296,10568297) 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'