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(9214694,8631146,8631485,8631488,8631494,8631500,8631503,8631504,8631505,8631506,8631507,8631519,7068902,7068906,7068912,7068920,8621878,10976971,10976972,8631993,8632182,8632393,8632394,8632395,8632396,8632397,8632398,8632399,8632400,10863046,8632404,8632405,8632406,8632407,8632408,8632417,8632418,8632437,8632441,8632449,8632452,8632455,8632458,8632463,8632465,8632467,8632469,8632473,8632477,8632479,8632482,8632484,8632486,8632488,8632494,8632501,8632504,8632505,8632507,8632508,8632509,8632510,8632511,10847619,8632512,8632513,8632516,8632518,10847632,8632526,8632527,8632532,8632533,8632541,8632545,8632562,8632563,8632564,8632565,10847679,8632573,8632574,10844733,8630444,8630447,8630448,8630450,8630454,8630455,7067843,4430564,7072134,7201459,7201460,7201462,7201463,7201466,7201467,7201470,7201473,7201474,7201476,7201482,7201486,8835731,7201490,7201491,7201495,7201496,7201501,7201507,7201509,7201512,7201513,8618403,10858872,10960440,7202239,7202300,7202302,7202304,7202307,7202310,8628784,8628820,8628821,8628825,8628829,8628830,8628834,8628836,8628838,8628840,8628842,8628847,8628848,8628853,8628854,8628859,8628860,8628863,8628864,8628869,8628870,8628875,8628878,8628881,8628884,8628887,8628889,8628891,8628893,8628897,8628900,8628903,8628906,8628909,8628912,8628915,8628918,8628921,8628924,8628927,8628930,8628933,8628936,8628939,8628941,8628944,8628947,8628951,8628952,8628955,8628958,8628959,8628964,8628965,8628970,8628971,8628976,8628977,8628982,8628983,8628988,8628989,8629006,8629009,8629011,8629013,10104498,8629015,8629021,8629022,8629023,8629024,8629027,8629028,8629033,8629034,8629037,8629038,8629040,8629043,8629048,8629049,8629050,8629051,8629054,8629055,8629060,8629061,8629111,8629112,8629116,8629138,8629147,8629148,8629149,8629190,8629194,8629197,8629205,8596298,10844558,10844568,10844589,10844590,10958950,10958951,10958952,10958953,10958954,7200536,7200539,3235763,10840491,10840492,10840677,10983659,10941935,11036377,11045770,11045771,11045793,11045794,11045795,3923593,8554241,11046050,10968230,11007315,11007330,11007399,11007404,11007405,11007406,11007407,8613729,11046693,11046694,8555079,11007844,8624259,8624260,10617002,10966664,10966665,8612210,10617426,8542126,8542129,8542130,10837668,10951604,10952031,11004121,11004122,11004123,11004124,3230993,3230994,3230995,8540451,7155100,7155101,10992578,10992579,9915542,7059550,7059567,7059643,7059644,7059649,10559341,10562412,9189645,7019433,7019434,7019435,7019436,7019437,7019438,7019439,7019440,7019441,7019442,9197822,9213830,7019535,7019536,7019537,7019538,7019539,7019540,7019541,7019542,7019543,7019544,10559713,9181904,10614634,10614638,9189981,7019760,7019761,7019762,7019763,7019764,7019765,7019803,7019804,7019805,7019806,7019807,7019808,7019809,7019810,7019811,7019812,7019813,7019814,7019815,7019816,7019817,7019818,7019819,7019820,7019821,7019822,10611998,10119645,9171827,10609835,9172283,9196570,9196571,9196634,10561605,10561616,10561635,10561636,10561637,9196894,10561712,10561713,10561730,10561745,9189158,9189159,9915455,9915456,9915479,9915480,9915482,9915493,9915494,9209609,9209674,9209915,9186353,9186354,9186355,9186356,9210563,9210564,7024603,7024604,7024605,7024606,7024607,7024608,7024609,7024610,7024611,7024612,9171089,9211197,7014051,7014052,9208454,10417458,9208623,10416603,4973718,4973726,4973761,10117490,7020399,7020400,7020401,7020402,7020403,7020404,7020405,7020406,7020407,7020408,6678981,10123521,10123554,10123565,9167455,9175495,8550825,9208156,10124471,10903705,10903706,10903707,10903708,10903709,10903710,10903711,10628278,10628279,10628280,10908980,10908981,10174997,10174998,10628550,10175088,10170210,10170224,10170261,10170262,10170263,10170264,10170265,10170266,10170267,10170288,10170387,10170388,10170389,10170390,10170391,10170392,10170393,10170394,10170395,10170396,10170397,10170398,10170399,10170400,10170525,10170526,10170527,10170528,10170529,10170530,10170531,10170532,10170533,10170534,10170535,10170536,10170537,10170538,10170539,10170540,10170541,10170542,10170543,10170544,10170545,10170546,10170547,10170630,10170631,10170632,10884644,10884864,10884865,10884888,10910132,10910133,10910268,10910287,10910306,10882894,10172226,10172227,10626262,10172831,10172838,10882166,10586623,10586624,10586645,10586646,10586647,10586655,10586656,10586662,10586684,10586689,10586690,10586709,10586710,10586724,10586727,10586728,10586729,10586731,10586733,10586750,10586769,10586784,10586803,10586814,10586815,10586823,10586824,10586825,10586826,10586827,10586837,10586838,10586839,10586840,10586841,10586876,10586877,10586878,10586905,10586906,10586915,10586916,10586938,10586994,10586995,10587020,10587021,10599039,10587042,10587043,10587044,10587047,10587050,10587051,10587052,10587070,10587071,10587097,10587107,10599155,10599156,10587455,10587456,10587470,10587479,10587480,10587481,10587485,10587486,10587487,10587489,10587490,10587491,10587498,10587526,10587527,10587528,10587530,10587541,10587562,10587563,10587564,10587565,10587571,10587572,10587578,10587579,10587583,10587584,10587585,10587598,10584614,10587616,10587636,10587637,10584654,10584655,10584656,10587674,10587675,10587687,10587688,10584698,10587698,10584699,10584700,10584701,10584709,10584710,10584711,10584712,10584713,10587713,10587714,10587715,10587716,10587717,10584723,10584724,10584736,10584742,10584743,10587756,10587757,10587758,10587759,10587760,10587761,10587762,10584776,10584777,10584781,10584782,10584792,10584810,10587811,10587812,10587813,10587843,10584863,10587877,10587886,10587887,10587888,10584892,10587897,10584928,10587951,10587965,10584972,10584978,10584979,10587979,10584980,10584981,10584997,10585000,10585020,10585022,10585040,10588047,10585090,10588093,10588094,10588095,10588096,10585105,10585113,10588136,10588157,10588158,10585169,10585175,10588188,10588220,10588221,10588232,10585240,10585241,10585242,10585247,10585248,10585250,10588254,10588255,10588258,10588259,10588260,10588261,10588262,10588263,10585273,10588286,10588287,10585299,10585300,10585301,10585302,10585303,10585304,10588315,10585321,10585322,10585323,10585324,10585325,10585326,10588340,10585346,10585347,10585349,10588355,10585395,10585396,10585402,10585415,10585416,10585417,10585418,10585419,10585421,10585444,10585445,10585464,10585465,10585467,10585468,10585476,10585506,10607412,10607413,10585891,10532207,10532208,10532209,10522227,10550424,10522524,10532812,10524928,10524929,10524930,10546994,10530996,10551009,10551010,10509644,10425202,10413404,10492799,10408972) 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'