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(4970450,4970746,4970747,8569566,7065954,7066010,7066017,7066184,7066185,7066186,7066193,7066194,7066195,7066222,7066267,8067903,8067906,8067907,8067908,8067909,8067913,8067933,8067934,8067935,8067936,8067938,8067939,10939408,10939417,8065820,8065827,10931197,11048369,11048370,11048442,11048477,10618267,10618268,10618278,10618281,10618293,10618296,10618303,10618322,10618324,10618325,10618326,10623605,10623606,8070780,8070781,8070782,10617031,10617033,10617035,10617044,10617047,10617048,10617049,10617050,10617068,10617072,10617114,10617124,10617135,10617136,10617137,10617142,10617145,10617146,10617148,10617149,10617150,10617151,10617154,10617155,10617156,10617157,10617158,10617159,10617164,10617169,10617170,10617171,10617172,10622273,10622283,10622284,10622285,10622286,10622287,10622288,10622289,10622290,10622291,10622292,10622293,10622294,10622295,10622296,10622297,10622298,10622299,10622300,10622301,10622302,10622303,10622304,10622306,10622307,10622308,10622309,10622310,10622311,10622312,10622313,10622314,10622315,10622316,10622317,10622318,10622319,10622320,10622321,10622322,10622323,10622324,10622325,10622326,10622327,10622328,10622329,10622330,10622331,10622332,10622333,10622334,10622335,10622336,10622337,10622338,10622339,10622340,10622341,10622342,10622344,10622401,10617426,10622461,10622466,10622467,10622468,10622469,10622470,10622471,10622472,10622473,10622474,10622475,10622476,10622477,10622478,10622479,10622480,10622481,10622482,10622483,10622484,10622485,10622486,10622487,10622488,10622489,10622490,10622491,10622492,10622493,10622494,10622495,10622496,10622497,10622498,10622499,10622500,10622501,10622502,10622503,10622504,10622505,10622539,10617793,10615062,10615077,10615078,10615079,10615092,10615202,10615268,10615275,10615334,10615353,10615389,10615398,10615425,10615427,10615428,10615430,10615449,10615462,10615463,10615464,10615467,10615469,10615470,10615472,10615483,10615488,10615489,10615509,10615510,10615511,10615512,10615513,10615514,10615515,10615516,10615521,10615522,10615523,10615524,10615525,10615527,10615528,10615529,10615530,10615531,10615532,10615533,10615534,10614048,10611048,10614078,10614079,10614085,10614086,10614089,10611179,10611180,10611181,10614220,10611226,10611232,10614282,10611318,10611319,10611338,10611339,10611343,10611350,10611367,10611368,10611369,10611370,10614376,10614427,10614435,10614463,10614464,10614485,10614488,10614489,10614492,10614518,10614537,10614556,10614557,10614558,10614565,10614572,10614591,10614592,10614629,10614641,10614642,10614643,10614644,10611671,10611673,10611676,10611677,10611678,10614749,10614752,10614772,10614773,10614774,10611774,10614775,10614776,10614777,10614778,10614779,10614780,10614781,10614782,10614783,10614784,10614785,10614786,10614787,10611788,10614788,10614789,10614790,10614791,10614792,10614793,10614794,10614795,10614796,10614797,10614798,10614799,10611800,10614800,10614801,10611801,10611802,10614802,10614803,10614804,10614805,10614806,10614807,10614808,10614809,10614810,10614811,10611812,10614812,10614813,10614814,10614815,10614816,10614817,10611819,10611823,10614858,10614859,10614862,10614863,10614864,10611878,10611879,10614887,10611968,10612051,10612069,10612094,10612095,10612096,10612097,10612163,10612164,10612165,10612166,10612167,10612168,10612169,10612170,10612189,10612228,10612248,10612259,10612261,10612262,10612263,10612264,10612265,10612266,10612267,10612268,10609277,10612284,10612285,10612286,10612287,10612328,10612342,10609355,10609393,10612407,10612408,10612409,10612410,10612411,10612412,10612414,10612424,10612426,10612427,10612428,10612429,10612430,10612479,10612483,10612484,10612485,10612486,10612487,10612488,10612489,10612490,10612491,10612492,10612493,10612496,10612497,10612498,10612499,10612500,10612501,10612502,10612503,10612505,10612506,10612507,10612508,10612509,10612510,10612513,10612516,10612517,10612518,10612519,10612520,10612521,10612522,10612523,10612524,10612525,10612526,10612527,10612528,10612529,10612530,10612531,10612532,10612534,10612535,10612536,10612538,10612539,10612542,10612546,10612547,10612551,10612552,10612553,10612554,10612555,10612556,10612557,10612558,10612559,10612562,10612563,10612565,10612566,10612567,10612568,10612570,10612571,10612573,10612575,10612577,10612578,10612583,10612584,10612585,10612586,10612587,10612588,10612589,10612592,10612594,10609595,10612596,10612597,10612599,10612601,10612604,10612608,10612609,10612611,10612618,10612619,10612620,10612622,10612623,10612624,10612625,10612626,10612633,10612635,10612637,10612638,10612639,10612641,10612642,10612643,10612644,10612645,10612646,10612647,10612648,10612650,10612651,10612652,10612653,10612655,10612657,10612658,10612659,10612660,10612661,10612663,10612664,10612666,10612667,10612668,10612673,10612675,10612677,10612678,10612679,10612680,10612682,10612683,10612684,10612685,10612687,10612688,10612689,10612690,10612697,10612698,10612699,10612700,10612701,10612702,10612703,10612704,10612705,10612706,10612707,10612711,10612713,10612714,10612715,10612716,10612717,10612718,10609718,10609720,10612720,10612721,10609722,10612722,10609745,10609751,10612757,10609818,10609819,10612821,10612822,10612824,10609826,10609828,10612833,10612834,10612836,10612837,10612838,10612839,10609840,10612840,10609841,10612841,10612842,10609843,10612843,10612844,10609844,10612845,10612846,10612847,10612850,10612852,10612853,10612856,10612860,10612862,10612863,10609865,10612865,10609866,10612866,10612867,10612868,10612869,10612870,10609871,10612871,10609872,10612872,10612873,10612874,10609875,10612875,10609876,10612876,10612877,10612878,10612879,10612881,10612882,10612884,10609887,10612889,10609893,10609894,10612898,10612914,10612915,10612921,10612922,10612923,10612936,10612937,10612938,10612939,10612941,10612942,10612943,10612945,10612951,10609966,10609975,10609976,10609978,10609979,10609981,10612984,10609998,10609999,10610003,10610005,10610006,10613019,10610035,10610037,10610041,10610042,10610044,10610048,10610053,10610054,10613083,10610093,10613094,10613119,10613120,10613192,10610237,10613245,10613254,10610270,10610271,10610289,10610305,10610318,10610319,10613350,10610359,10610362,10610363,10610364,10613370,10610371,10610372,10610373,10610374,10610396,10610466,10610476,10610486,10613645,10613654,10610671,10613694,10610793,10613804,10613805,10613806,10610836,10610862,10610937,10610939,10610940,10610941,10419255,10419257,10419258,10419259,10419260,10416265,10416266,10417273,10417274,10417275,10417276,10417284,10417288,10419291,10417292,10419307,10415318,10415320,10415323,10415325,10417374,10417376,10417378,10419386,10419394,10417394,10419395,10417395,10419396,10417396,10417397,10415416,10415417,10415418,10415419,10417424,10415424,10415425,10415426,10415427,10417429,10415430,10417431,10415431,10415432,10417433,10415433,10415434,10417435,10415435,10417437,10415438,10417439,10415439,10415440,10417441,10415441,10415442,10415443,10415444,10415445,10415446,10416453,10416457,10415460,10415461,10419462,10417462,10415462,10417463,10415463,10417464,10415464,10415465,10417466,10416466,10415466,10417467,10415467,10417468,10415468,10417469,10416469,10417470,10416470,10417471,10417472,10417473,10417474,10417475,10417476,10417477,10417478,10417495,10415537,10415538,10419555,10419564,10419565,10417566,10419593,10416610,10416611,10416613,10416617,10416641,10417642,10416650,10416651,10416652,10416654,10416656,10416659,10416660,10416662,10415665,10416667,10416668,10416674,10416709,10416710,10416711,10416712,10416713,10416714,10416715,10416716,10416717,10417789,10417790,10417791,10417792,10417793,10417794,10417795,10417796,10419797,10416799,10416800,10416802,10416804,10416805,10416806,10416809,10416812,10416813,10416815,10416817,10416819,10416821,10416834,10416840,10416852,10416863,10416868,10416887,10416888,10416896,10416897,10417920,10417924,10417928,10417936,10417940,10417941,10417942,10417943,10417944,10417945,10417949,10417950,10417951,10417952,10415952,10417953,10415953,10417954,10415954,10417955,10415955,10417956,10415956,10417957,10415957,10417958,10415958,10417959,10415959,10417960,10415960,10417961,10415961,10417962,10415962,10417963,10415963,10417964,10415964,10415965,10415966,10416967,10415967,10415968,10415969,10415970,10415971,10415972,10417973,10415973,10417974,10415974,10417975,10415975,10417976,10415976,10415977,10415978,10415979,10415980,10417981,10415981,10417982,10417983,10417984,10417985,10417986,10417987,10417988,10417989,10417990,10417017,10417019,10417021,10417023,10417026,10417027,10417029,10417030,10417031,10417034,10417036,10417037,10417038,10416043,10416045,10418048,10418122,10418123,10418124,10418125,10418126,10418127,10418128,10418129,10418130,10418131,10418132,10418133,10418134,10418135,10418136,10418137,10418138,10418139,10469946,10470107,10470108,10470109,10470154,10470155,10470161,10470179,10470180,10470181,10470182,10470183,10470184,10470185,10470186,10470187,10470188,10470189,10470190,10470191,10462575,10470641,10470690,10470708,10470785) 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'