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(4970167,4970168,4970188,4970233,4970245,4970246,4970247,4970250,4970252,4970262,4970264,4970268,4970269,4970324,4970358,4970371,4970377,4970379,4970382,4970393,4970394,4970395,4970396,4970397,4970414,4970415,4970441,4970443,4970444,4970445,4970447,4970448,4970449,4970464,4970465,4970466,4970481,4970500,4970503,4970513,4970514,4970515,4970516,4970517,4970518,4970522,4970523,4970524,4970525,4970526,4970527,4970543,4970544,4970545,4970546,4970547,4970551,4970552,4970553,4970554,4970555,4970556,4970557,4970558,4970559,4970560,4970561,4970562,4970563,4970609,4970616,4970628,4970634,4970638,4970646,4970666,4970676,4970712,4970713,4970714,4970715,4970716,4970717,4970718,4970719,4970720,4970724,4970738,4970740,4970741,4970742,4970756,4970757,4970762,4970763,4970764,4970765,4970766,4970770,4970771,4970782,4970786,4970788,4970819,4970821,4970822,4970829,4970835,4970887,4970895,4970899,4970903,4970904,4970915,4970925,4970926,4970928,4970936,4970938,4970941,4970946,4970948,4970951,4970956,4970960,4970961,4970962,4970977,4970980,4970981,4970988,4971010,4971011,4971012,4971017,4971018,4971024,4971025,4971029,4971040,4971041,4971060,4971061,4971062,4971064,4971065,4971081,4971096,4971098,4971102,4971104,4971105,4971111,4971112,4968156,4968163,4968165,4968167,4968168,4968169,4968170,4968171,4968172,4968173,4968174,4968175,4968176,4968177,4968178,4968179,4968180,4968181,4968182,4968183,4968184,4968185,4968186,4968188,4968189,4968193,4968203,4968204,4968207,4968210,4968211,4968212,4968214,4968215,4968216,4968217,4968220,4968225,4968229,4968230,4968231,4968234,4968236,4968238,4968240,4968242,4968243,4968244,4968245,4968247,4968253,4968257,4968258,4968260,4968261,4968263,4968265,4968266,4968267,4968268,4968269,4968270,4968277,4968278,4968280,4968282,4968284,4968288,4968290,4968291,4968292,4968293,4968295,4968304,4968306,4968307,4968308,4968309,4968314,4968318,4968324,4968325,4968327,4968329,4968333,4968335,4968336,4968339,4968340,4968342,4968343,4968348,4968353,4968356,4968361,4968362,4968367,4968373,4968375,4968376,4968377,4968380,4968382,4968384,4968386,4968388,4968389,4968392,4968395,4968396,4968397,4968401,4968405,4968406,4968413,4968414,4968415,4968417,4968418,4968426,4968429,4968436,4968438,4968439,4968440,4968441,4968442,4968444,4968445,4968448,4968449,4968450,4968451,4968452,4968454,4968455,4968456,4968457,4968459,4968460,4968461,4968462,4968463,4968464,4968468,4968469,4968471,4968474,4968476,4968478,4968481,4968483,4968484,4968489,4968490,4968492,4968494,4968496,4968499,4968501,4968502,4968503,4968505,4968508,4968510,4968512,4968514,4968517,4968521,4968526,4968527,4968529,4968532,4968533,4968535,4968536,4968537,4968538,4968539,4968546,4968547,4968550,4968553,4968554,4968555,4968558,4968559,4968562,4968563,4968564,4968571,4968577,4968578,4968579,4968580,4968581,4968582,4968585,4968586,4968587,4968588,4968589,4968590,4968591,4968592,4968593,4968594,4968595,4968597,4968598,4968599,4968601,4968602,4968603,4968605,4968606,4968609,4968610,4968612,4968615,4968619,4968620,4968621,4968622,4968624,4968625,4968627,4968628,4968629,4968630,4968633,4968640,4968641,4968642,4968645,4968646,4968647,4968650,4968651,4968652,4968653,4968664,4968666,4968667,4968670,4968672,4968673,4968675,4968677,4968681,4968682,4968684,4968685,4968687,4968692,4968700,4968702,4968704,4968705,4968706,4968707,4968708,4968709,4968710,4968711,4968712,4968713,4968714,4968715,4968716,4968722,4968724,4968725,4968726,4968727,4968728,4968730,4968731,4968732,4968734,4968736,4968737,4968738,4968739,4968740,4968746,4968747,4968748,4968750,4968751,4968754,4968755,4968757,4968758,4968760,4968761,4968762,4968764,4968770,4968772,4968773,4968778,4968779,4968780,4968782,4968786,4968791,4968792,4968793,4968796,4968798,4968799,4968800,4968801,4968804,4968805,4968806,4968807,4968808,4968814,4968815,4968816,4968818,4968824,4968825,4968827,4968828,4968829,4968830,4968831,4968834,4968836,4968839,4968840,4968841,4968842,4968843,4968844,4968845,4968846,4968847,4968848,4968850,4968853,4968855,4968856,4968857,4968858,4968859,4968860,4968861,4968862,4968863,4968866,4968875,4968876,4968877,4968878,4968879,4968880,4968881,4968882,4968883,4968884,4968885,4968886,4968887,4968888,4968891,4968893,4968894,4968897,4968898,4968899,4968900,4968901,4968910,4968912,4968913,4968914,4968919,4968923,4968924,4968929,4968933,4968939,4968940,4968943,4968944,4968945,4968946,4968947,4968948,4968950,4968952,4968953,4968954,4968958,4968959,4968967,4968972,4968979,4968980,4968981,4968982,4968983,4968984,4968985,4968993,4968999,4969000,4969001,4969002,4969004,4969005,4969006,4969010,4969018,4969019,4969020,4969021,4969022,4969023,4969024,4969025,4969026,4969027,4969028,4969029,4969030,4969031,4969032,4969033,4969034,4969035,4969036,4969037,4969038,4969039,4969040,4969041,4969042,4969043,4969044,4969045,4969046,4969047,4969048,4969049,4969050,4969051,4969052,4969053,4969054,4969055,4969056,4969057,4969058,4969059,4969060,4969061,4969062,4969063,4969064,4969065,4969066,4969067,4969068,4969069,4969070,4969071,4969072,4969073,4969074,4969075,4969076,4969077,4969078,4969079,4969080,4969081,4969082,4969083,4969084,4969085,4969086,4969087,4969088,4969089,4969090,4969091,4969092,4969093,4969094,4969095,4969096,4969097,4969098,4969099,4969100,4969101,4969102,4969103,4969104,4969105,4969106,4969107,4969108,4969109,4969110,4969111,4969112,4969113,4969114,4969119,4969120,4969123,4969125,4969127,4969128,4969131,4969134,4969144,4969145,4969146,4969147,4969148,4969149,4969150,4969151,4969154,4969158,4969160,4969162,4969164,4969165,4969170,4969171,4969172,4969173,4969174,4969175,4969176,4969179,4969184,4969185,4969186,4969192,4969199,4969200,4969202,4969203,4969206,4969209,4969211,4969216,4969218,4969219,4969221,4969222,4969223,4969224,4969225,4969226,4969227,4969229,4969230,4969231,4969232,4969233,4969234,4969235,4969240,4969241,4969242,4969243,4969244,4969245,4969246,4969251,4969258,4969299,4969326,4969348,4969356,4969422,4969446,4969468,4969472,4969474,4969475,4969477,4969478,4969479,4969482,4969484,4969487,4969489,4969490,4969499,4969501,4969502,4969503,4969509,4969512,4969524,4969526,4969531,4969535,4969536,4969539,4969540,4969543,4969544,4969549,4969563,4969576,4969579,4969594,4969595,4969596,4969599,4969600,4969606,4969609,4969610,4969615,4969616,4969617,4969618,4969619,4969621,4969626,4969656,4969658,4969690,4969691,4969692,4969712,4969720,4969721,4969722,4969723,4969724,4969725,4969726,4969727,4969730,4969746,4969759,4969772,4969800,4969814,4969816,4969824,4969832,4969845,4970002,4970023,4970026,4970027,4970035,4970062,4970066,4970068,4970069,4970070,4970121,4970122,4970124,4970125,8075058,8075059,8075060,8075061,8075062,8075063,8075105,8075106,8075107,8075108,8075109,8075110,8075166,8075167,8075168,8075169,8075170,8075209,8075210,8075211,8075212,8075213,8075214,8075215,8075216,8075217,8075218,8075219,8075220,8075221,8075222,8075223,8075224,8075260,8075275,8075276,8075277,8075281,8075333,8075334,8075335,8075336,8075459,8075460,8075461,8075462,8075463,8075464,8075465,8075466,8075467,8075468,8075469,8075470,8075471,8075472,8075494,8075495,8075496,8075497,8075498,8075499,8075500,8075508,8075509,8075511,8075512,8075513,8075514,8075515,8075516,4967063,4967064,4967067,4967073,4967108,4967112,4967113,4967114,4967116,4967117,4967118,4967119,4967120,4967122,4967124,4967128,4967129,4967130,4967132,4967136,4967139,4967142,4967143,4967154,4967160,4967188,4967203,4967204,4967210,4967218,4967242,4967252,4967256,4967317,4967319,4967320,4967321,4967337,4967338,4967345,4967359,4967362,4967363,4967388,4967390,4967391,4967408,4967417,4967419,4967423,4967497,4967498,4967499,4967500,4967520,4967532,4967629,4967651,4967652,4967666,4967715,4967718,4967721,4967724,4967735,4967741,4967749,4967789,4967845,4967846,4967847,4967848,4967849,4967852,4967864,4967871,4967878,4967880,4967890,4967893,4967912,4967925,4967927,4967928,4967929,4967930,4967935,4967944,4967945,4967946,4967952,4967953,4968029,4968030,4968031,4968032,4968033,4968034,4968035,4968036,4968037,4968038,4968039,4968041) 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'