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(8574002,8574003,4970670,4970671,4970672,4970773,4970774,10944265,7065947,8583441,7066070,7066071,7066072,7066073,7066074,7066075,7066076,10950709,7066161,7066162,7066267,7066268,7066269,10950914,10437392,8067941,8067942,8067943,8573243,7067586,10939404,10939435,10939440,8910076,8834745,8834764,8834765,8910465,8909101,8860325,8860326,10101583,8860413,8860415,8860450,8860451,8860452,8860453,8905880,8906799,8906800,8906801,8906806,8906897,8906898,8906899,8906900,8906901,8907408,11008186,11008187,11008188,10619875,8905014,8905015,8905167,8905168,8905169,8905170,8905171,8905172,8905173,8905174,8905175,8905176,8905177,8905178,8905179,8905180,8905181,8905182,8905183,8905184,8905185,8905186,8905187,8905188,8905189,8905190,8905191,8905192,8905193,8905194,8905195,8905196,8905197,8905198,8905199,10622454,10622456,10622462,10617466,10617467,10617468,10617469,10617470,10617471,10617472,10617473,10617474,10617475,10617476,10617477,10617478,10617479,10617480,10617481,10617482,10617483,10617484,10617485,10617486,10617487,10617488,10617489,10617490,10617491,10617492,10617493,10617494,10617495,10617496,10617497,10617498,10617499,10617500,10617501,10617502,10617503,10617504,10617505,10617506,10617507,10617508,10617509,10617510,10617511,10617512,10617513,8905424,10617514,10617515,10617516,10617517,8905572,8905573,8905574,8905852,8576160,10615173,10615174,10615175,10615176,10615177,10965468,10952786,10616844,10616849,10616853,10616907,10616908,10616909,10616910,10610998,10610999,10614374,10614465,10614466,10614467,10614468,10614469,10614470,10614512,10614513,10614514,10614515,10614830,10614833,10614836,10612011,10612012,10612226,10612227,10609592,10609898,10609899,7017916,7017917,7017918,7017919,7017920,7017921,7017922,7017923,7017924,7017925,7017926,7017927,7017928,7017929,7017930,7017931,7017932,7017933,7017934,7017935,7017936,7017937,7017938,7017939,7017940,7017941,7017942,9172305,9172306,9172307,9172308,9172309,9172310,9172311,10609989,10610067,10610500,10610501,10610502,10610503,10610504,10610505,10610506,10610507,10610508,10610509,10610510,10610511,10610512,10610513,10610514,10610515,10610516,10610517,10610518,10610519,10610520,10610521,10610522,10610523,10610524,10610525,10610526,10610527,10610528,10610529,10610530,10610531,10610532,10610533,10610534,10610535,10610536,10610537,10610538,10610539,10610540,10610541,10610542,10610543,10610544,10610545,10610546,10610547,10610548,10610549,10610550,10610551,10610552,10610553,10610554,10610555,10610556,10610557,10610558,10610559,10610560,10610561,10610562,10610563,10610564,10610565,10610566,10610567,10610568,10610569,10610570,10610571,10610572,10610573,10610574,10610575,10610576,10610577,10610578,10610579,10610580,10610581,10610582,10610583,10610584,10610585,10610586,10610587,10610588,10610589,10610590,10610591,10610592,10610593,10610594,10610595,10610596,10610597,10610598,10610599,10610600,10610601,10610602,10610603,10610604,10610605,10610606,10610607,10610608,10610609,10610610,10610611,10610612,10610613,10610614,10610615,10610616,10610617,10610618,10610619,10610620,10610621,10610622,10610623,10610624,10610625,10610626,10610627,10610628,10610629,10610630,10610631,10610632,10610633,10610634,10610635,10610636,10610637,10610638,10610639,10610640,10610641,10610642,10610643,10610644,10610645,10610646,10610647,10610648,10610649,10610650,10610651,10610652,10610653,10610654,10610655,10610656,10610657,10610658,10610659,10610660,10610661,10610662,10610663,10613722,10610726,10610735,10610741,10610744,10610746,10610749,10515290,10515291,10515292,10515293,10515294,10515295,10515296,10515297,10515298,10515299,10515300,10515301,10515302,10515303,10515304,9169844,9169892,9169934,9169987,9169988,9169989,9169990,9169991,9169992,9169993,9169994,9169995,9169996,9169997,9169998,9169999,9168329,10416333,10416334,10416335,10416549,10418552,10418553,10418554,10418555,10418556,10418557,10418558,10418559,10418560,10418561,10418562,10418563,10418564,10418565,10418566,10418567,10418568,10418569,10418570,10418571,10418572,10418573,10418574,10418575,10418576,10418577,10418578,10418579,10418580,10418581,10418582,10418583,10418584,10418585,10418586,10418587,10418588,10418589,10418590,10418591,10418592,10418593,10418594,10418595,10418596,10418597,10418598,10418599,10418600,10418601,10418602,10419602,10418603,10419603,10419604,10418604,10419605,10418605,10419606,10418606,10419607,10418607,10418608,10419608,10419609,10418609,10418610,10419610,10418611,10419611,10418612,10419612,10418613,10419613,10418614,10419614,10418615,10419615,10419616,10418616,10419617,10418617,10419618,10418618,10419619,10418619,10419620,10418620,10419621,10418621,10419622,10418622,10419623,10418623,10418624,10419624,10418625,10419625,10418626,10419626,10418627,10419627,10418628,10419628,10418629,10419629,10418630,10419630,10418631,10419631,10418632,10419632,10418633,10419633,10418634,10419634,10418635,10419635,10418636,10419636,10418637,10419637,10418638,10419638,10418639,10419639,10419640,10418640,10418641,10419641,10419642,10418642,10419643,10418643,10419644,10418644,10418645,10419645,10419646,10418646,10419647,10418647,10419648,10418648,10419649,10418649,10419650,10418650,10419651,10418651,10419652,10418652,10419653,10418653,10419654,10418654,10418655,10419655,10418656,10419656,10418657,10419657,10418658,10419658,10418659,10419659,10418660,10419660,10418661,10419661,10418662,10419662,10418663,10419663,10416663,10418664,10419664,10416664,10418665,10419665,10416665,10418666,10419666,10416666,10418667,10419667,10418668,10419668,10418669,10419669,10416669,10418670,10416670,10419670,10418671,10419671,10418672,10419672,10418673,10419673,10418674,10419674,10418675,10419675,10419676,10419677,10419678,10419679,10419680,10419681,10419682,10419683,10419684,10419685,10419686,10419687,10419688,10419689,10419690,10415690,10419691,10419692,10419693,10419694,10419695,10419696,10419697,10419698,10419699,10419700,10419701,10419702,10419703,10419704,10419705,10419706,10419707,10419708,10419709,10419710,10419711,10419712,10419713,10419714,10419715,10419716,10419717,10419718,10419719,10419720,10419721,10419722,10419723,10419724,10419725,10419726,10419727,10419728,10419729,10419730,10419731,10419732,10419733,10419734,10419735,10419736,10419737,10419738,10419739,10419740,10419741,10419742,10419743,10419744,10419745,10419746,10419747,10419748,10419749,10419750,10419751,10419752,10419753,10419754,10419755,10419756,10419757,10419758,10419759,10419760,10419761,10419762,10419763,10419764,10416764,10419765,10419766,10419767,10416767,10419768,10416768,10419769,10416769,10419770,10419771,10416771,10419772,10419773,10419774,10419775,10419776,10419777,10419778,10419779,10419780,10419781,10419782,10419783,10419784,10419785,10419786,10419787,10419788,10419789,10419790,10419791,10419792,10419793,10419794,10419795,10419796,10419797,10419798,10419799,10419800,10419801,10419802,10419803,10419804,10419805,10419806,10419807,10419808,10419809,10419810,10419811,10419812,10419813,10419814,10419815,10419816,10419817,10419818,10419819,10419820,10419821,10419822,10419823,10419824,10419825,10419826,10419827,10419828,10419829,10419830,10419831,10419832,10419833,10419834,10419835,10419836,10419837,10419838,10419839,10419840,10419841,10419842,10419843,10419844,10419845,10419846,10419847,10419848,10419849,10419850,10419851,10419852,10419853,10419854,10419855,10419856,10419857,10419858,10419859,10419860,10419861,10419862,10419863,10419864,10419865,10419866,10419867,10419868,10419869,10419870,10419871,10419872,10419873,10419874,10419875,10419876,10419877,10419878,10419879,10419880,10419881,9169077,10420038,10420042,10417161,10419187,10471128,10471129,10471167,10471220,10471221,10471222,10471223,10471224,10471225,10471226,10471227,10471228,10471229,10471230,10471231,10471232,10471233,10471234,10471235,10471236,10471237,10471238,10471239,10471240,10471241,10471242,10471243,10471244,10471245,10471246,10471247,10471248,10471249,10471250,10471251,10471252,10471253,10471254,10471255,10471256,10471257,10471258,10471259,10471260,10471261,10471262,10471263,10471264,10471265,10471266,10471267,10471268,10471269,10471270,10471271,10471272,10471273,10471274,10471275,10471276,10467632,8916799,8916800,8916899,10467896,10467897,10467898,10467899,10467900,10467901,10467902,10467903,10467904,10467905,10467906,10467907,10467908,10467909,10467910,10467911,10467912,10467913,10467914,10467915,10466249,10466250,10466251,10468348,9167780,9167862,9167863,10468499,10468500,9167994,9167995,9167996,9167997,9167998,9167999,9168000,9168001,9168002,9168003,9168004,10470666,10470667,10470668,10470669,10470670,10470671,10470672,10470673,10470674,10470675,9168106,10470705,9168233,10632011,10627668,10627779,10161850,10161851,10161852,10161853,10161854,10161855,10161856,10161857,10161858,10161859,10161860,10161980,10626441,10590192,10477211,10477212,10477213,10477214,10478056,10478057) 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'