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(4970195,4970228,4970230,4970231,4970232,4970233,4970234,4970235,4970236,4970237,4970238,4970239,4970240,4970241,4970242,4970243,4970244,4970245,4970246,4970247,4970248,4970249,4970250,4970251,4970252,4970253,4970254,4970255,4970256,4970257,4970258,4970259,4970260,4970261,4970262,4970263,4970264,4970265,4970266,4970267,4970268,4970269,4970275,4970276,4970277,4970301,4970302,4970303,4970304,4970305,4970306,4970307,4970308,4970309,4970310,4970311,4970312,4970313,4970314,4970315,4970316,4970317,4970318,4970319,4970320,4970321,4970322,4970323,4970324,4970325,4970326,4970327,4970328,4970329,4970330,4970331,4970332,4970333,4970334,4970335,4970336,4970337,4970338,4970339,4970340,4970341,4970342,4970343,4970344,4970345,4970346,4970347,4970348,4970349,4970350,4970351,4970352,4970353,4970354,4970355,4970356,4970357,4970358,4970359,4970360,4970361,4970362,4970363,4970364,4970365,4970366,4970367,4970368,4970369,4970370,4970371,4970372,4970373,4970374,4970375,4970376,4970377,4970378,4970379,4970380,4970381,4970382,4970383,4970384,4970385,4970386,4970387,4970388,4970389,4970390,4970391,4970392,4970393,4970394,4970395,4970396,4970397,4970398,4970405,4970406,4970407,4970408,4970429,4970430,4970431,4970432,4970433,4970434,4970435,4970436,4970437,4970438,4970439,4970440,4970441,4970442,4970443,4970444,4970445,4970446,4970447,4970448,4970449,4970450,4970478,4970479,4970480,4970501,4970503,4970508,4970509,4970510,4970511,4970512,4970513,4970520,4970521,4970522,4970556,4970569,4970585,4970586,4970587,4970588,4970595,4970612,4970613,4970614,4970615,4970616,4970617,4970618,4970619,4970620,4970621,4970622,4970623,4970624,4970625,4970626,4970666,4970667,4970668,4970669,4970672,4970683,4970687,4970688,4970692,4970707,4970720,4970726,4970727,4970728,4970738,4970740,4970747,4970753,4970885,4970900,4970910,4970912,4970914,4970916,4970925,4970940,4970954,4970959,4970960,4970961,4970966,4970968,4970975,4970989,4971030,4971031,4971032,4971033,4971057,4971061,4971062,4971070,4971071,4971072,4971081,4971128,4968324,4968325,4968326,4968335,4968341,4968642,4968643,4968645,4968646,4968651,4968652,4968653,4968802,4968803,4968860,4968939,4969105,4969278,4969279,4969280,4969281,4969548,4969571,4969572,4969573,4969574,4969575,4969576,4969577,4969578,4969579,4969580,4969581,4969582,4969583,4969584,4969585,4969586,4969587,4969592,4969593,4969594,4969595,4969596,4969597,4969598,4969599,4969600,4969601,4969602,4969603,4969604,4969605,4969630,4969631,4969637,4969638,4969642,4969643,4969648,4969654,4969655,4969656,4969657,4969673,4969679,4969680,4969681,4969682,4969683,4969684,4969685,4969713,4969724,4969736,4969741,4969742,4969743,4969744,4969745,4969746,4969747,4969748,4969749,4969750,4969766,4969788,4969804,4969810,4969827,4969838,4969841,4969860,4969866,4969867,4969868,4969888,4969889,4969890,4969891,4969892,4969912,4969913,4969922,4969943,4969944,4969953,4969954,4969955,4969956,4969960,4969970,4970008,4970021,4970034,4970035,4970036,4970037,4970061,4970078,4970079,4970080,4970096,4970097,4970098,4970143,4970144,8074772,8074773,8074774,8074775,8074776,8074777,8074778,8074779,8074780,8074781,8074782,8074783,8074784,8074785,8074786,8074787,8074788,8074789,8074790,8074791,8074792,8074793,8074794,8074795,8074796,8074797,8074798,8074799,8074800,8074801,8074802,8074803,8074804,8074805,8074806,8074807,8074808,8074809,8074810,8074811,8074812,8074813,8074814,8074815,8074816,8074817,8074818,8074819,8074820,8074821,8074822,8074823,8074824,8074825,8074826,8074827,8074828,8074829,8074830,8074831,8074832,8074833,8074834,8074835,8074836,8074837,8074838,8074839,8074840,8074841,8074842,8074843,8074844,8074845,8074846,8074847,8074848,8074849,8074850,8074851,8074852,8074853,8074854,8074855,8074884,8074885,8074886,8074887,8074888,8074889,8074929,8074930,8074931,8074932,8074933,8075232,8075261,8075262,8075278,8075279,8075282,8075283,8075306,8075324,8075325,8075326,8075327,8075328,8075329,8075330,8075331,8075459,8075460,8075461,8075462,8075485,8075488,4967029,4967032,4967046,4967109,4967110,4967111,4967339,4967340,4967341,4967344,4967351,4967352,4967523,4967546,4967547,4967548,4967557,4967558,4967559,4967560,4967574,4967588,4967589,4967610,4967611,4967612,4967613,4967614,4967634,4967635,4967636,4967637,4967638,4967639,4967674,4967675,4967676,4967685,4967706,4967707,4967708,4967717,4967719,4967721,4967751,4967754,4967755,4967756,4967757,4967758,4967759,4967760,4967761,4967762,4967763,4967764,4967765,4967766,4967767,4967768,4967769,4967774,4967775,4967776,4967777,4967778,4967779,4967780,4967781,4967782,4967783,4967784,4967785,4967786,4967787,4967788,4967789,4967790,4967791,4967792,4967793,4967794,4967795,4967796,4967797,4967798,4967799,4967800,4967801,4967802,4967803,4967804,4967805,4967806,4967807,4967808,4967809,4967810,4967811,4967812,4967813,4967814,4967815,4967816,4967817,4967818,4967826,4967829,4967883,4967884,4967919,4967920,4967921,4967937,4967938,4967939,4967985,4968124,4968135,4968156,4968157,4968158,8071773,8071774,8071775,8071776,8071777,8071778,8071779,8071780,8071781,8071782,8071783,8071784,8071785,8071786,8071787,8071788,8071789,8071790,8071791,8071792,8071793,8071794,8071795,8071796,8071797,8071798,8071799,8071800,8071801,8071802,8071803,8071804,8071805,8071806,8071807,8071808,8071809,8071810,8071811,8071812,8071813,8071814,8071815,8071816,8071817,8071818,8071819,8071820,8071821,8071822,8071823,8071824,8071825,8071826,8071827,8071828,8071829,8071830,8071831,8071832,8071833,8071834,8071835,8071836,8071837,8071838,8071839,8071840,8071841,8071842,8071843,8071844,8071845,8071846,8071847,8071848,8071849,8071850,8071851,8071852,8071853,8071854,8071855,8071856,8071857,8071858,8071859,8071860,8071861,8071862,8071863,8071864,8071865,8071866,8071867,8071868,8071869,8071870,8071871,8071872,8071873,8071874,8071875,8071876,8071877,8071878,8071879,8071880,8071881,8071882,8071883,8071884,8071885,8071886,8071887,8071888,8071889,8071890,8071891,8071892,8071893,8071894,8071895,8071896,8071897,8071898,8071899,8071900,8071901,8071902,8071903,8071904,8071905,8071906,8071907,8071908,8071909,8071910,8071911,8071912,8071913,8071914,8071915,8071916,8071917,8071918,8071919,8071920,8071921,8071922,8071923,8071924,8071925,8071926,8071927,8071928,8071929,8071930,8071931,8071932,8071933,8071934,8071935,8071936,8071937,8071938,8071939,8071940,8071941,8071942,8071943,8071944,8071945,8071946,8071947,8071948,8071949,8071950,8071951,8071952,8071953,8071954,8071955,8071956,8071957,8071958,8071959,8071960,8071961,8071962,8071963,8071964,8071965,8071966,8071967,8071968,8071969,8071970,8071971,8071972,8071973,8071974,8071975,8071976,8071977,8071978,8071979,8071980,8071981,8071982,8071983,8071984,8071985,8071986,8071987,8071988,8071989,8071990,8071991,8071992,8071993,8071994,8071995,8071996,8071997,8071998,8071999,8072000,8072001,8072002,8072003,8072004,8072005,8072006,8072007,8072008,8072009,8072010,8072011,8072012,8072013,8072014,8072015,8072016,8072017,8072018,8072019,8072020,8072021,8072022,8072023,8072024,8072025,8072026,8072027,8072028,8072029,8072030,8072031,8072032,8072033,8072034,8072035,8072036,8072037,8072038,8072039,8072040,8072041,8072042,8072043,8072044,8072045,8072046,8072047,8072048,8072049,8072050,8072051,8072052,8072053,8072054,8072055,8072056,8072057,8072058,8072059,8072060,8072061,8072062,8072063,8072064,8072065,8072066,8072067,8072068,8072069,8072070,8072071,8072072,8072073,8072074,8072075,8072076,8072077,8072078,8072079,8072080,8072081,8072082,8072083,8072084,8072085,8072086,8072087,8072088,8072089,8072090,8072091,8072092,8072093,8072094,8072095,8072096,8072097,8072098,8072099,8072100,8072101,8072102,8072103,8072104,8072105,8072106,8072107,8072108,8072109,8072110,8072111,8072112,8072113,8072114,8072115,8072116,8072117,8072118,8072119,8072120,8072121,8072122,8072123,8072124,8072125,8072126,8072127,8072128,8072129,8072130,8072131,8072132,8072133,8072134,8072135,8072136,8072137,8072138,8072139,8072140,8072141,8072142,8072143,8072144,8072145,8072146,8072147,8072148,8072149,8072150,8072151,8072152,8072153,8072154,8072155) 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'