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(8569566,7066183,8906014,8906015,8906016,8906017,8906018,10622539,10615518,10615519,10615520,10615521,10615522,10615523,10615524,10615525,10615526,10615903,10614629,7016953,7016954,7016955,7016956,7016957,7016958,7016959,7016960,7016961,7016962,7016963,7016964,7016965,7016966,7016967,7016968,7016969,7016970,7016971,7016972,7016973,7016974,7016975,7016976,7016977,7016978,7016979,7016980,7016981,7016982,7016983,7016984,7016985,7016986,7016987,7016988,7016989,7016990,7016991,7016992,7016993,7016994,7016995,7016996,7016997,7016998,7016999,7017000,7017001,7017002,7017003,7017004,7017005,7017006,7017007,7017008,7017009,7017010,7017011,7017012,7017013,7017014,7017015,7017016,7017017,7017018,7017019,7017020,7017021,7017022,7017023,7017024,7017025,7017026,7017027,7017028,7017029,7017030,7017031,7017032,7017033,7017034,7017035,7017036,7017037,7017038,7017039,7017040,7017041,7017042,7017043,7017044,7017045,7017046,7017047,7017048,7017049,7017050,7017051,7017052,7017053,7017054,7017055,7017056,7017057,7017058,7017059,7017060,7017061,7017062,7017063,7017064,7017065,7017066,7017067,7017068,7017069,7017070,7017071,7017072,7017073,7017074,7017075,7017076,7017077,7017078,7017079,7017080,7017081,7017082,7017083,7017084,7017085,7017086,7017087,7017088,7017089,7017090,7017091,7017092,7017093,7017094,7017095,7017096,7017097,7017098,7017099,7017100,7017101,7017102,7017103,7017104,7017105,7017106,7017107,7017108,7017109,7017110,7017111,7017112,7017113,7017114,7017115,7017116,7017117,7017118,7017119,7017120,7017121,7017122,7017123,7017124,7017125,7017126,7017127,7017128,7017129,7017130,7017131,7017132,7017133,7017134,7017135,7017136,7017137,7017138,7017139,7017140,7017141,7017142,7017143,7017144,7017145,7017146,7017147,7017148,7017149,7017150,7017151,7017152,7017153,7017154,7017155,7017156,7017157,7017158,7017159,7017160,7017161,7017162,7017163,7017164,7017165,7017166,7017167,7017168,7017169,7017170,7017171,7017172,7017173,7017174,7017175,7017176,7017177,7017178,7017179,7017180,7017181,7017182,7017183,7017184,7017185,7017186,7017187,7017188,7017189,7017190,7017191,7017192,7017193,7017194,7017195,7017196,7017197,7017198,7017199,7017200,7017201,7017202,7017203,7017204,7017205,7017206,7017207,7017208,7017209,7017210,7017211,7017212,7017213,7017214,7017215,7017216,7017217,7017218,7017219,7017220,7017221,7017222,7017223,7017224,7017225,7017226,7017227,7017228,7017229,7017230,7017231,7017232,7017233,7017234,7017235,7017236,7017237,7017238,7017239,7017240,7017241,7017242,7017243,7017244,7017245,7017246,7017247,7017248,7017249,7017250,7017251,7017252,7017253,7017254,7017255,7017256,7017257,7017258,7017259,7017260,7017261,7017262,7017263,7017264,7017265,7017266,7017267,7017268,7017269,7017270,7017271,7017272,10612417,10613805,10613806,9169529,9169530,9169531,9169532,9169533,9169534,9169655,7016257,7016258,7016259,7016260,7016261,7016262,7016263,7016264,7016265,7016266,7016267,7016268,7016269,7016270,7016271,7016272,7016273,7016274,7016275,7016276,7016277,7016278,7016279,7016280,7016281,7016282,7016283,7016284,7016285,7016286,7016287,7016288,7016289,7016290,7016291,7016292,7016293,7016294,7016295,7016296,7016297,7016298,7016299,7016300,7016301,7016302,7016303,7016304,7016305,7016306,7016307,7016308,7016309,7016310,7016311,7016312,7016313,7016314,7016315,7016316,7016317,7016318,7016319,7016320,7016321,7016322,7016323,7016324,7016325,7016326,7016327,7016328,7016329,7016330,7016331,7016332,7016333,7016334,7016335,7016336,7016337,7016338,7016339,7016340,7016341,7016342,7016343,7016344,7016345,7016346,7016347,7016348,7016349,7016350,7016351,7016352,7016353,7016354,7016355,7016356,7016357,7016358,7016359,7016360,7016361,7016362,7016363,7016364,7016365,7016366,7016367,7016368,7016369,7016370,7016371,7016372,7016373,7016374,7016375,7016376,7016377,7016378,7016379,7016380,7016381,7016382,7016383,7016384,7016385,7016386,7016387,7016388,7016389,7016390,7016391,7016392,7016393,7016394,7016395,7016396,7016397,7016398,7016399,7016400,7016401,7016402,7016403,7016404,7016405,7016406,7016407,7016408,7016409,7016410,7016411,7016412,7016413,7016414,7016415,7016416,7016417,7016418,7016419,7016420,7016421,7016422,7016423,7016424,7016425,7016426,7016427,7016428,7016429,7016430,7016431,7016432,7016433,7016434,7016435,7016436,7016437,7016438,7016439,7016440,7016441,7016442,7016443,7016444,7016445,7016446,7016447,7016448,7016449,7016450,7016451,7016452,7016453,7016454,7016455,7016456,7016457,7016458,7016459,7016460,7016461,7016462,7016463,7016464,7016465,7016466,7016467,7016468,7016469,7016470,7016471,7016472,7016473,7016474,7016475,7016476,7016477,7016478,7016479,7016480,7016481,7016482,7016483,7016484,7016485,7016486,7016487,7016488,7016489,7016490,7016491,7016492,7016493,7016494,7016495,7016496,7016497,7016498,7016499,7016500,7016501,7016502,7016503,7016504,7016505,7016506,7016507,7016508,7016509,7016510,7016511,7016512,7016513,7016514,7016515,7016516,7016517,7016518,7016519,7016520,7016521,7016522,7016523,7016524,7016525,7016526,7016527,7016528,7016529,7016530,7016531,7016532,7016533,7016534,7016535,7016536,7016537,7016538,7016539,7016540,7016541,7016542,7016543,7016544,7016545,7016546,7016547,7016548,7016549,7016550,7016551,7016552,7016553,7016554,7016555,7016556,7016557,7016558,7016559,7016560,7016561,7016562,7016563,7016564,7016565,7016566,7016567,7016568,7016569,7016570,7016571,7016572,7016573,7016574,7016575,7016576,7016577,7016578,7016579,7016580,7016581,7016582,7016583,7016584,7016585,7016586,7016587,7016588,7016589,7016590,7016591,7016592,7016593,7016594,7016595,7016596,7016597,7016598,7016599,7016600,7016601,7016602,7016603,7016604,7016605,7016606,7016607,7016608,7016609,7016610,7016611,7016612,7016613,7016614,7016615,7016616,7016617,7016618,7016619,7016620,7016621,7016622,7016623,7016624,7016625,7016626,7016627,7016628,7016629,7016630,7016631,7016632,7016633,7016634,7016635,7016636,7016637,7016638,7016639,7016640,7016641,7016642,7016643,7016644,7016645,7016646,7016647,7016648,7016649,7016650,7016651,7016652,7016653,7016654,7016655,7016656,7016657,7016658,7016659,7016660,7016661,7016662,7016663,7016664,7016665,7016666,7016667,7016668,7016669,7016670,7016671,7016672,7016673,7016674,7016675,7016676,7016677,7016678,7016679,7016680,7016681,7016682,7016683,7016684,7016685,7016686,7016687,7016688,7016689,7016690,7016691,7016692,7016693,7016694,7016695,7016696,7016697,7016698,7016699,7016700,7016701,7016702,7016703,7016704,7016705,7016706,7016707,7016708,7016709,7016710,7016711,7016712,7016713,7016714,7016715,7016716,7016717,7016718,7016719,7016720,7016721,7016722,7016723,7016724,7016725,7016726,7016727,7016728,7016729,7016730,7016731,7016732,7016733,7016734,7016735,7016736,7016737,7016738,7016739,7016740,7016741,7016742,7016743,7016744,7016745,7016746,7016747,7016748,7016749,7016750,7016751,7016752,7016753,7016754,7016755,7016756,7016757,7016758,7016759,7016760,7016761,7016762,7016763,7016764,7016765,7016766,7016767,7016768,7016769,7016770,7016771,7016772,7016773,7016774,7016775,7016776,7016777,7016778,7016779,7016780,7016781,7016782,7016783,7016784,7016785,7016786,7016787,7016788,7016789,7016790,7016791,7016792,7016793,7016794,7016795,7016796,7016797,7016798,7016799,7016800,7016801,7016802,7016803,7016804,7016805,7016806,7016807,7016808,7016809,7016810,7016811,7016812,7016813,7016814,7016815,7016816,7016817,7016818,7016819,7016820,7016821,7016822,7016823,7016824,7016825,7016826,7016827,7016828,7016829,7016830,7016831,7016832,7016833,7016834,7016835,7016836,7016837,7016838,7016839,7016840,7016841,7016842,7016843,7016844,7016845,7016846,7016847,7016848,7016849,7016850,7016851,7016852,7016853,7016854,7016855,7016856,7016857,7016858,7016859,7016860,7016861,7016862,7016863,7016864,7016865,7016866,7016867,7016868,7016869,7016870,7016871,7016872,7016873,7016874,7016875,7016876,7016877,7016878,7016879,7016880,7016881,7016882,7016883,7016884,7016885,7016886,7016887,7016888,7016889,7016890,7016891,7016892,7016893,7016894,7016895,7016896,7016897,7016898,7016899,7016900,7016901,7016902,7016903,9168953,10470110,10470111,10522598) 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'