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(4970425,4970494,4970495,4970496,4970497,4970498,4970499,4970636,4970676,4970684,4970685,4970700,4970705,4970716,4970718,4970724,4970742,4970759,4970765,4970766,4970771,4970772,4970819,4970820,4970821,4970822,4970841,4970857,4970913,4970923,4970927,4970988,4971009,4971081,4971096,4971101,4971102,4968152,4968153,4968154,4968155,4968156,4968157,4968158,4968159,4968160,4968161,4968162,4968163,4968164,4968165,4968166,4968167,4968172,4968173,4968177,4968179,4968181,4968183,4968193,4968194,4968202,4968218,4968228,4968229,4968234,4968235,4968236,4968237,4968238,4968239,4968240,4968241,4968242,4968243,4968244,4968245,4968246,4968247,4968248,4968249,4968250,4968251,4968252,4968253,4968254,4968257,4968261,4968266,4968272,4968273,4968274,4968288,4968292,4968295,4968328,4968337,4968338,4968340,4968359,4968360,4968363,4968364,4968365,4968382,4968412,4968440,4968443,4968444,4968446,4968453,4968455,4968456,4968463,4968474,4968475,4968533,4968541,4968542,4968543,4968544,4968545,4968546,4968547,4968548,4968549,4968550,4968553,4968564,4968577,4968586,4968594,4968598,4968602,4968619,4968645,4968664,4968673,4968699,4968700,4968701,4968702,4968703,4968704,4968705,4968706,4968707,4968708,4968709,4968710,4968711,4968712,4968713,4968714,4968715,4968730,4968734,4968736,4968737,4968738,4968739,4968740,4968746,4968758,4968777,4968780,4968785,4968792,4968802,4968803,4968804,4968805,4968812,4968813,4968816,4968826,4968832,4968833,4968834,4968843,4968844,4968846,4968849,4968862,4968889,4968890,4968891,4968892,4968893,4968894,4968895,4968896,4968897,4968898,4968901,4968925,4968934,4968935,4968936,4968937,4968938,4968939,4968940,4968941,4968942,4968943,4968944,4968948,4968962,4968963,4968964,4968965,4968968,4968969,4968970,4968971,4968972,4968973,4968974,4968975,4968976,4968977,4968978,4968979,4968980,4968981,4968982,4968983,4968984,4968985,4968986,4968987,4968988,4968989,4968990,4968991,4968992,4968993,4968994,4968995,4968996,4968997,4968998,4968999,4969000,4969001,4969002,4969003,4969004,4969005,4969006,4969007,4969008,4969009,4969010,4969011,4969012,4969013,4969014,4969015,4969016,4969017,4969019,4969021,4969038,4969048,4969056,4969057,4969058,4969059,4969060,4969096,4969097,4969107,4969131,4969143,4969146,4969171,4969173,4969177,4969185,4969186,4969187,4969188,4969189,4969190,4969191,4969192,4969203,4969208,4969213,4969224,4969235,4969239,4969285,4969286,4969287,4969288,4969330,4969331,4969352,4969353,4969354,4969471,4969472,4969473,4969474,4969475,4969476,4969477,4969478,4969479,4969480,4969481,4969482,4969483,4969484,4969485,4969486,4969487,4969488,4969489,4969490,4969526,4969529,4969530,4969540,4969543,4969591,4969615,4969621,4969625,4969626,4969627,4969994,4969995,8074706,8074707,8074708,8074709,8074710,8074748,8074749,8074750,8074751,8074752,8074967,8074968,8074969,8074970,8074971,8074972,8075011,8075012,8075013,8075014,8075015,8075016,8075160,8075161,8075162,8075163,8075164,8075165,8075202,8075203,8075204,8075205,8075206,8075207,8075208,8075246,8075249,8075254,8075255,8075270,8075271,8075273,8075276,8075277,8075281,8075306,8075324,8075325,8075326,8075327,8075328,8075329,8075330,8075331,8075346,8075347,8075348,8075349,8075350,8075351,8075352,8075353,8075354,8075355,8075356,8075359,8075360,8075361,8075362,8075363,8075366,8075367,8075368,8075369,8075370,8075371,8075372,8075373,8075374,8075375,8075420,8075421,8075437,8075438,8075491,8075492,8075493,8075515,8075538,4967033,4967120,4967132,4967164,4967165,4967166,4967424,4967425,4967453,4967454,4967489,4967490,4967491,4967492,4967493,4967494,4967495,4967496,4967511,4967512,4967513,4967514,4967516,4967517,4967518,4967519,4967520,4967521,4967522,4967523,4967524,4967525,4967526,4967527,4967528,4967529,4967530,4967531,4967532,4967533,4967534,4967842,4967843,4968030,4968032,4968034,4968036,4968052,4968053,4968055,4968076,4968077,4968078,4968079,4968083,4968091,4968120,4968133,4968136,4968137,4968138,4968139,4968140,4968141,4968142,4968143,4968144,4968145,4968146,4968147,4968148,4968149,4968150,4968151,8073686,8073687,8073688,8073689,8073690,8073691,8073692,8073693,8073694,8073695,8073740,8073741,8073742,8073743,8073744,8073745,8073746,8073747,8073748,8073792,8073793,8073794,8073795,8073796,8073797,8073798,8073841,8073842,8073843,8073844,8073845,8073846,8073847,8074070,8074071,8074072,8074073,8074074,8074075,8074112,8074113,8074114,8074115,8074116,8074117,8074155,8074156,8074157,8074158,8074159,8074160,8074200,8074201,8074202,8074203,8074204,8074205,8072228,8072229,8072230,8072231,8072232,8072233,8072234,8072235,8072236,8072237,8072238,8072239,8072240,8072241,8072242,8072243,8072244,8072245,8072246,8072247,8072248,8072249,8072250,8072251,8072252,8072253,8072254,8072255,8072256,8072257,8072258,8072259,8072260,8072261,8072262,8072263,8072264,8072265,8072266,8072267,8072268,8072269,8072270,8072271,8072272,8072273,8072274,8072275,8072276,8072277,8072278,8072279,8072280,8072281,8072282,8072283,8072284,8072285,8072286,8072287,8072288,8072289,8072290,8072291,8072292,8072323,8072324,8072325,8072326,8072327,8072328,8072329,8072330,8072366,8072377,8072381,8072399,8072403,8072415,8072425,8072428,8072445,8072457,8072467,8072468,8072469,8072566,8072567,8072568,8072569,8072570,8072571,8072572,8072573,8072574,8072575,8072576,8072703,8072704,8072705,8072706,8072707,8072708,8072709,8072710,8072711,8072712,8072723,8072724,8072725,8072726,8072727,8072728,8072729,8072730,8072731,8072732,8072748,8072749,8072750,8072751,8072752,8072997,8073002,8073013,8073014,8073511,8073527,8073533,8073537,8073542,8073543,10622972,10622975,10622978,10623038,10623058,10623059,10623061,10623062,10623257,10623301,10623309,10623329,10623366,10623367,10623368,10623369,10623370,10623371,10623372,10623373,10623374,10623375,10623376,10623407,10623423,10623460,10623491,10623492,10623503,10623506,10623582,10623653,10623654,10623733,10623734,10623801,10623875,10623876,10623887,10623888,10623889,10623890,10623891,10623892,10623893,10623894,10623895,10623896,10623897,10624018,10624019,10624020,10624021,10624022,10624023,10624104,10624122,10624123,10624173,10624174,10624175,10624269,10624411,10624412,10624556,10624566,10624575,10624582,10624663,10624731,10624732,10624823,10624837,10624956,10624959,10624960,10621966,10621977,10621979,10622015,10622054,10622063,10622088,10622093,10622095,10622100,10622131,10622234,10622267,10622292,10622306,10622307,10622308,10622309,10622310,10622325,10622337,10622338,10622341,10622389,10622392,10622393,10622394,10622395,10622402,10622403,10622405,10622408,10622409,10622410,10622412,10622429,10622451,10622478,10622506,10622527,10622528,10622545,10622613,10622656,10622657,10622658,10622659,10622660,10622661,10622662,10622663,10622664,10622677,10622704,10622705,10622706,10622707,10622708,10622709,10622710,10622728,10622729,10622810,10622811,10622812,10622813,10622814,10622815,10622816,10622817,10622889,10622890,10622899,10622900,10622911,10622912,10622918,10622959,10620048,10620071,10620072,10620073,10620079,10620096,10620097,10620121,10620123,10620124,10620125,10620208,10620244,10620277,10620289,10620343,10620344,10620345,10620356,10620359,10620365,10620375,10620385,10620404,10620426,10620438,10620439,10620440,10620462,10620469,10620487,10620491,10620499,10620500,10620501,10620502,10620503,10620530,10620596,10620597,10620598,10620599,10620600,10620601,10620602,10620603,10620604,10620605,10620606,10620607,10620608,10620609,10620610,10620611,10620612,10620613,10620614,10620615,10620616,10620617,10620618,10620619,10620620,10620621,10620622,10620623,10620626,10620654,10620655,10620739,10620740,10620741,10620778,10620809,10620813,10620840,10620843,10620844,10620845,10620846,10620847,10620864,10620866,10620873,10620877,10620878,10620879,10620886,10620887,10620890,10620896,10620899,10620902,10620905,10620919,10620924,10620929,10620931,10620934,10620937,10620938,10620939,10620940,10620950,10620953,10620954,10620965,10620981,10620982,10620992,10620995,10621002,10621008,10621024,10621025,10621026,10621027,10621028,10621044,10621046,10621049,10621050,10621073,10621117,10621118,10621120,10621121,10621124,10621125,10621126,10621127,10621128,10621129,10621130,10621131,10621133,10621134,10621135,10621136,10621144,10621145,10621147,10621148,10621149,10621151,10621152,10621155,10621156,10621157,10621158,10621159,10621160,10621161,10621165,10621243,10621251,10621255,10621256) 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'