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(4970193,4970194,4970195,4970196,4970197,4970218,4970219,4970220,4970221,4970222,4970223,4970224,4970225,4970226,4970227,4970230,4970241,4970242,4970255,4970260,4970261,4970270,4970292,4970302,4970303,4970304,4970310,4970314,4970318,4970366,4970367,4970368,4970400,4970401,4970402,4970418,4970424,4970429,4970430,4970438,4970453,4970454,4970455,4970500,4970501,4970502,4970507,4970531,4970532,4970540,4970541,4970542,4970548,4970549,4970550,4970552,4970564,4970565,4970566,4970567,4970568,4970569,4970570,4970574,4970607,4970608,4970612,4970613,4970614,4970616,4970617,4970618,4970619,4970621,4970623,4970624,4970625,4970626,4970627,4970628,4970629,4970630,4970631,4970645,4970646,4970655,4970656,4970657,4970661,4970662,4970663,4970664,4970665,4970666,4970667,4970668,4970669,4970675,4970677,4970684,4970701,4970713,4970715,4970717,4970718,4970719,4970720,4970724,4970725,4970726,4970734,4970742,4970745,4970746,4970813,4970814,4970815,4970845,4970850,4970853,4970858,4970859,4970860,4970861,4970862,4970863,4970864,4970866,4970867,4970869,4970870,4970873,4970874,4970876,4970878,4970881,4970882,4970883,4970884,4970885,4970886,4970887,4970888,4970889,4970890,4970892,4970893,4970895,4970896,4970897,4970899,4970900,4970901,4970902,4970903,4970904,4970905,4970906,4970910,4970911,4970912,4970914,4970915,4970917,4970918,4970919,4970921,4970922,4970924,4970925,4970926,4970927,4970928,4970929,4970930,4970931,4970932,4970933,4970934,4970935,4970936,4970938,4970940,4970941,4970942,4970943,4970944,4970946,4970948,4970949,4970950,4970951,4970952,4970953,4970954,4970955,4970956,4970957,4970958,4970959,4970960,4970961,4970962,4970963,4970964,4970965,4970966,4970967,4970968,4970969,4970973,4970974,4970975,4970977,4970978,4970979,4970980,4970981,4970982,4970983,4970984,4970985,4970986,4970987,4970988,4970989,4970990,4970991,4970995,4971007,4971008,4971024,4971025,4971026,4971027,4971028,4971029,4971034,4971035,4971036,4971049,4971060,4971061,4971062,4971074,4971076,4971091,4971095,4971125,4971128,4971131,4971132,4971141,4971149,4971151,4971154,4971155,4971156,4971157,4971158,4968165,4968167,4968169,4968170,4968174,4968175,4968177,4968178,4968179,4968180,4968181,4968182,4968183,4968185,4968188,4968193,4968211,4968212,4968220,4968236,4968293,4968306,4968307,4968308,4968309,4968318,4968333,4968340,4968405,4968406,4968413,4968417,4968461,4968462,4968463,4968489,4968490,4968492,4968494,4968529,4968595,4968601,4968602,4968603,4968609,4968610,4968612,4968615,4968622,4968628,4968629,4968630,4968633,4968645,4968646,4968647,4968651,4968652,4968653,4968664,4968666,4968667,4968681,4968702,4968724,4968725,4968726,4968727,4968728,4968746,4968747,4968748,4968750,4968751,4968754,4968755,4968757,4968758,4968772,4968773,4968786,4968828,4968829,4968830,4968831,4968841,4968845,4968846,4968847,4968848,4968855,4968856,4968857,4968858,4968859,4968861,4968863,4968866,4968875,4968888,4968972,4969032,4969033,4969034,4969035,4969036,4969037,4969038,4969039,4969040,4969041,4969042,4969043,4969044,4969045,4969046,4969047,4969048,4969049,4969050,4969056,4969092,4969111,4969112,4969113,4969114,4969162,4969184,4969192,4969199,4969222,4969227,4969246,4969252,4969254,4969255,4969256,4969266,4969267,4969269,4969284,4969285,4969286,4969288,4969305,4969312,4969344,4969345,4969346,4969347,4969384,4969403,4969404,4969405,4969412,4969437,4969438,4969440,4969444,4969449,4969451,4969452,4969455,4969459,4969460,4969464,4969493,4969549,4969557,4969562,4969564,4969565,4969566,4969567,4969571,4969572,4969588,4969589,4969591,4969592,4969594,4969595,4969596,4969599,4969600,4969606,4969615,4969619,4969621,4969626,4969632,4969633,4969635,4969654,4969665,4969666,4969668,4969673,4969674,4969675,4969676,4969721,4969745,4969755,4969757,4969758,4969759,4969760,4969761,4969776,4969777,4969779,4969780,4969784,4969785,4969790,4969792,4969803,4969804,4969806,4969807,4969818,4969819,4969820,4969830,4969831,4969832,4969833,4969874,4969966,4969967,4970015,4970091,4970094,4970099,4970102,4970112,4970113,4970138,4970145,4970146,4970147,4970148,4970149,4970151,8075034,8075035,8075036,8075037,8075038,8075039,8075040,8075041,8075042,8075043,8075044,8075045,8075046,8075047,8075048,8075049,8075050,8075051,8075052,8075053,8075054,8075055,8075056,8075057,8075058,8075059,8075060,8075061,8075062,8075063,8075064,8075065,8075066,8075067,8075068,8075069,8075070,8075071,8075072,8075073,8075074,8075075,8075076,8075077,8075078,8075079,8075080,8075081,8075082,8075083,8075084,8075085,8075086,8075087,8075088,8075089,8075090,8075091,8075092,8075093,8075094,8075095,8075096,8075097,8075098,8075099,8075100,8075101,8075102,8075103,8075104,8075105,8075106,8075107,8075108,8075109,8075110,8075111,8075112,8075113,8075114,8075115,8075116,8075117,8075118,8075119,8075120,8075121,8075122,8075123,8075124,8075125,8075126,8075127,8075214,8075215,8075216,8075217,8075223,8075224,8075257,8075258,8075259,8075263,8075265,8075272,8075288,8075289,8075333,8075334,8075335,8075336,8075540,8075543,4967037,4967040,4967041,4967044,4967046,4967050,4967051,4967056,4967059,4967061,4967063,4967064,4967067,4967071,4967072,4967073,4967077,4967080,4967082,4967083,4967084,4967085,4967086,4967087,4967088,4967089,4967090,4967093,4967094,4967095,4967096,4967098,4967099,4967104,4967108,4967109,4967111,4967112,4967113,4967114,4967116,4967117,4967118,4967119,4967120,4967122,4967124,4967128,4967129,4967130,4967132,4967136,4967139,4967142,4967143,4967149,4967154,4967155,4967157,4967160,4967161,4967163,4967167,4967169,4967170,4967172,4967173,4967175,4967176,4967177,4967179,4967181,4967182,4967183,4967184,4967185,4967187,4967188,4967192,4967199,4967200,4967201,4967202,4967203,4967204,4967206,4967207,4967210,4967212,4967213,4967214,4967216,4967218,4967222,4967223,4967224,4967228,4967230,4967231,4967232,4967234,4967237,4967239,4967240,4967241,4967242,4967245,4967246,4967247,4967249,4967250,4967251,4967252,4967255,4967256,4967258,4967260,4967262,4967264,4967267,4967268,4967270,4967272,4967275,4967278,4967279,4967283,4967284,4967286,4967287,4967290,4967291,4967292,4967296,4967298,4967303,4967305,4967306,4967307,4967308,4967310,4967312,4967317,4967319,4967320,4967321,4967323,4967325,4967326,4967327,4967328,4967332,4967333,4967334,4967337,4967338,4967345,4967351,4967352,4967353,4967354,4967355,4967356,4967357,4967359,4967360,4967361,4967362,4967363,4967365,4967366,4967367,4967368,4967369,4967370,4967374,4967377,4967380,4967381,4967383,4967387,4967388,4967390,4967391,4967395,4967397,4967398,4967402,4967403,4967404,4967407,4967408,4967411,4967413,4967416,4967417,4967418,4967419,4967423,4967430,4967432,4967435,4967441,4967442,4967443,4967445,4967446,4967447,4967449,4967460,4967463,4967474,4967476,4967477,4967479,4967483,4967484,4967486,4967490,4967493,4967495,4967497,4967498,4967499,4967500,4967501,4967502,4967504,4967505,4967506,4967508,4967509,4967517,4967520,4967524,4967525,4967526,4967528,4967529,4967532,4967533,4967548,4967549,4967552,4967557,4967558,4967561,4967563,4967565,4967569,4967570,4967573,4967581,4967582,4967584,4967586,4967589,4967590,4967591,4967593,4967596,4967603,4967604,4967606,4967610,4967613,4967614,4967616,4967619,4967624,4967629,4967631,4967632,4967634,4967636,4967638,4967642,4967645,4967646,4967648,4967649,4967650,4967651,4967652,4967654,4967656,4967657,4967658,4967660,4967662,4967663,4967664,4967666,4967668,4967669,4967670,4967676,4967677,4967678,4967681,4967682,4967683,4967691,4967693,4967695,4967696,4967697,4967698,4967699,4967702,4967706,4967707,4967709,4967710,4967715,4967718,4967721,4967724,4967728,4967729,4967733,4967735,4967741,4967746,4967748,4967749,4967751,4967758,4967759,4967763,4967771,4967772,4967773,4967774,4967775,4967776,4967780,4967781,4967784,4967787,4967789,4967808,4967809,4967816,4967817,4967818,4967827,4967829,4967831,4967832,4967836,4967838,4967839,4967841,4967843,4967845,4967846,4967847,4967848,4967849,4967852,4967854,4967855,4967857,4967859,4967862,4967864,4967865,4967868,4967871,4967873,4967876,4967878,4967880,4967885,4967886,4967887,4967888,4967889,4967890,4967891) 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'