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(4970692,4970696,4970698,10989326,7065942,8575167,7066019,7066021,10950674,10950700,10950709,10950720,10950761,7066167,7066168,7066250,10990260,7074578,7074584,7074593,7074673,7074679,10990368,10951361,7074833,7074834,7074855,7075010,8067921,8067929,8067939,8573300,8573317,8573319,8573332,8573334,8573340,10939101,10939404,8574012,7072302,10960057,10960071,10960072,10960085,10960192,8911589,4967032,8065839,7065856,7065920,10958949,8064326,10959115,10959116,8064692,11048422,11048437,11048453,10958376,10618181,10618281,10618282,10618283,10618285,10618298,10618327,10994378,10616996,10616997,10616998,10617003,10617004,10617005,10617006,10617007,10617008,10622027,10622040,10617047,10617085,10617092,10617093,10617094,10617095,10617096,10617097,10617098,10617164,10617165,10617169,10617170,10622189,10617215,10617281,10617282,10617283,10617284,10617285,10617286,10617287,10617288,10617289,10617290,10617291,10617292,10617293,10617294,10617318,10622429,10954097,10954099,10622447,10622453,10622455,10954195,10954196,10954197,10954198,10954199,10954200,10954201,10993247,10614991,10614993,10620121,10615158,10615170,10615225,10615226,10615227,10615228,10615229,10615232,10615237,10615282,10615283,10615284,10615292,10620302,10615312,10615327,10615328,10615336,10615337,10615338,10615344,10615395,10615397,10615398,10615491,10615570,10615604,10615615,10615639,10615640,10615672,10615685,10615698,10615700,10615730,10615731,10615736,10615745,10615747,10615748,10615849,10615876,10615877,10615959,10615971,10615972,10615973,10615974,10616092,10616103,10616359,10616376,10616378,10616380,10616382,10616383,10616384,10616385,10616386,10616390,10616392,10616396,10616398,10616399,10616402,10616409,10616413,10616414,10616416,10616418,10616419,10616424,10616425,10616428,10616504,10616586,10616764,10616911,10616913,10613971,10611012,10614024,10614050,10614085,10614086,7059643,7059644,10614148,10611179,10614181,9165548,9165549,10611240,10614291,10614292,10614327,10614328,10614329,10614374,10611374,10611375,10614418,10614477,10614478,10614479,10614480,10614481,10614482,10614483,10559711,10611576,10611578,10611583,10611586,10611591,10611592,10611593,10614595,10611595,10611601,10611602,10611610,10611611,10611614,10559766,10611625,10611626,10614634,10614638,10611639,10611640,10611642,10611643,10611650,10611651,10614656,10614658,10611678,10611679,9166051,10614752,9166099,10611786,10614857,10614886,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,7057465,10608963,10611978,10608980,10611996,10608999,10612003,10612008,10609014,10609018,10609020,10609028,10609033,10609036,10612069,10609082,10609083,10609084,10609085,10609087,10609088,10609092,10609093,10609095,10609100,7057615,7057616,7057617,10612210,10612260,10612264,10612267,10612270,10609285,10609303,10612323,10612344,10612347,10609367,10609386,10612475,10609478,10612479,10609483,10612499,10609500,10612500,10609501,10609503,10609512,10609513,10609529,10612532,10609546,10609547,10609560,10612567,10612585,10612586,10612587,10612588,10612589,10612590,10612591,10612598,10612600,10612601,10612605,10612608,10612615,10612620,10612621,10612626,10612629,10612630,10612633,10612634,10609640,10612645,10612646,10612647,10612648,10612649,10612650,10612651,10612653,10612663,10609664,10612666,10612667,10612668,10612669,10612670,10612671,10612672,10612673,7058185,10609682,10612683,10612684,10612685,10612686,10612687,10612688,10612689,10612690,7058197,7058198,10612696,10612701,10612702,7058207,8862566,10612710,10612711,10612712,10612718,10612719,10612720,10612721,10612722,10612723,10612724,10612725,10612726,10612727,10612728,10612729,10612730,10612731,10612732,10612733,10612734,10612735,10612736,10612737,10612738,10612755,10612763,10612764,10612765,10612766,10612767,10612768,10612771,10609772,10612782,10612783,10612784,10612785,10612786,10612787,10612788,10612789,10612790,10612791,10612792,10612793,10612794,10612795,10612796,10612800,10612801,10612802,10612803,10612806,10612807,10612808,10612818,10612819,10557973,10557975,10557976,10612832,10612842,10612847,10612882,10612890,10612905,10609934,10609935,10609936,10612963,10612967,10612971,10609979,10609990,10613034,10610035,10610037,10610044,10610067,10613072,10613079,10613091,10610112,10613140,10613184,10613187,10613189,10613223,10610233,10610236,10613253,10610268,10610395,7058908,10613408,10613409,10613410,9204793,10613468,10613469,10613470,10613471,10610479,10610480,10610481,7059074,10613576,10613588,10613589,10613610,10613634,10613635,10610658,10610674,10610675,10610676,10610677,10613682,10613683,10613696,10613731,10610764,10610776,10610777,10610778,10610780,10610781,10613808,10610907,10610915,10610916,10610955,7055468,7055469,9169356,9169377,7055545,9169393,9169440,9169441,9169453,9169458,9169459,9169460,9169521,9169540,9169576,9169577,9169610,9169629,9169631,9169639,9169649,9169650,9169651,9169816,9169824,9169887,9161891,9161892,9161893,9177901,9169913,9178477,10418226,10418229,10418232,10418233,10418234,10416237,10418238,10418239,10418243,10418244,10418245,10418248,10419257,10416262,10418269,10418270,9168352,10416275,10418279,10418280,10416282,9168363,10419288,10418298,10418309,10416358,10416359,10417360,10419362,10416363,10419363,10417370,10417371,10419377,10417377,10417378,10416382,10417388,10417392,10416408,10416409,10416410,10416411,10416412,10416413,10416414,10419414,9168494,10419431,10416448,10416449,10416450,10416451,10416452,10418490,10418491,10416499,10416501,10418502,10416503,10418505,10416515,10416520,10416522,10415525,10416526,10415526,10416527,10415527,10416528,10416532,10417532,10417533,10417535,10419536,10416540,10416545,10416546,10416548,10417552,10418556,10415563,10417570,10415573,9168672,9168673,9168675,10415604,10415605,9168684,9168686,9168687,10416610,10418610,10416611,10418611,9168689,10419611,10419612,10418612,10416612,9168690,9168691,10416613,9168692,10419615,10419616,10416617,9168696,10418618,9168700,10419624,10419625,10419630,10416631,10419634,10419635,10419638,10419639,10419643,10419644,10417644,10419648,10419649,10419652,9168731,10416656,10419656,10419657,10419660,10416661,10416662,10419663,10417663,10419664,10416673,10416674,10416675,10416676,10418685,10418686,10418687,10415701,10416704,10416705,10416706,10416707,10416708,10416709,10415709,10416710,10416711,10416712,10416713,10416714,10416715,10416716,9168794,10416717,9168796,10416730,10416731,10416732,10416733,10416734,10416735,10416736,10416737,10416738,10416739,10416740,10416741,10416742,10416743,10416744,10416745,10416746,10416747,10416748,10416749,10416750,10416751,10416752,10416753,10416754,10416755,10416756,10417758,10417764,10417765,10417766,10417767,10417768,10417769,10417770,10417771,10417772,10417780,10419806,9168886,10416834,10416835,10416836,10416837,10416838,10416839,10419862,10419863,10418864,10419864,10418865,10416881,10416882,10416883,10416884,10416885,10415886,10416886,10416904,10416905,10416906,10416907,10416908,10416909,10416910,10416911,10416912,10416913,10416914,10416915,10416916,10416917,10416918,10418924,10418947,10418949,10416955,10416956,10416964,10417965,10416965,10416966,10418968,10417968,10417970,10417971,10417972,10416972,10416974,10417978,10417979,10417986,10416986,10416987,10417990,10417998,10418001,10418004,10418011,10418014,10417016,10418018,10418024,10416028,10418029,10416030,10418031,10416032,10416034,10417041,10417047,10418057,9169138,10417071,10418091,10418102,9161184,10418121,10418128,10419167,10418168,10419174,10419175,10419176,9169257,9169273,10419196,10419199,10419200,10469143,10469254,10467466,10467469,10467496,10467507,10467510,9175052,8916797,10467765,9167398,10470092,10470113,10470114,4972395,4972396,4972397,10470149,10470161,10470164,10470169,10470176,10470178,9167634,9167637,10464231,10470244,9167686,10470274,10470293,10470363,10470364,10470391,10470395,10468406,10470413,10470463,9167901,10470503,9199929,9167936,9167955,10470534,10470535,9167977,10462572,10470580,9168005,10470598,10470605,9168063,10470643,10470644,10470645,10470647,10470648,10470649,10470650,10470651,9168088,9168091,10470672,10468694,9168147,10468732,9168159,10468738,10468739,10468743,10468747,10468748,10468749,10468750,10468751,10468752,10462752,10468753,10468770,10468824,9168258,10468847,10468850,10154576,10627313,10627321,10627771,10161688,10161692,10161791,10161793,10161943,10162221,10162222,10162223,10162243,10630822,10630823,10626123,10626143,10626144,10167916,10167936,10163108,10163112,10581960,10588686,10532186,10421491,10421492,10421515,10422672,10422673,10483193,10486326,10478020,10478021,10478022,10487105,10487106,10487107,10476341,10472504,10472510,10472512,10472562,10482850,10482854) 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'