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(4970152,4970155,4970163,4970165,4970166,4970167,4970168,4970169,4970170,4970171,4970172,4970173,4970181,4970182,4970184,4970188,4970189,4970190,4970191,4970192,4970202,4970203,4970215,4970232,4970233,4970236,4970239,4970240,4970245,4970246,4970247,4970248,4970249,4970250,4970251,4970252,4970253,4970254,4970255,4970256,4970257,4970258,4970259,4970262,4970263,4970264,4970266,4970268,4970269,4970272,4970274,4970277,4970280,4970284,4970289,4970292,4970294,4970297,4970306,4970308,4970312,4970324,4970327,4970333,4970334,4970342,4970343,4970346,4970349,4970353,4970358,4970359,4970360,4970364,4970365,4970370,4970371,4970372,4970377,4970378,4970379,4970380,4970381,4970382,4970385,4970386,4970387,4970393,4970394,4970395,4970396,4970397,4970398,4970403,4970404,4970410,4970411,4970412,4970413,4970414,4970415,4970416,4970417,4970418,4970419,4970420,4970421,4970422,4970423,4970424,4970425,4970426,4970427,4970428,4970431,4970432,4970437,4970440,4970441,4970442,4970443,4970444,4970445,4970446,4970447,4970448,4970449,4970464,4970465,4970466,4970470,4970473,4970478,4970479,4970480,4970481,4970485,4970493,4970494,4970495,4970496,4970497,4970498,4970499,4970500,4970503,4970512,4970513,4970514,4970515,4970516,4970517,4970518,4970519,4970522,4970523,4970524,4970525,4970526,4970527,4970538,4970543,4970544,4970545,4970546,4970547,4970551,4970552,4970553,4970554,4970555,4970556,4970557,4970558,4970559,4970560,4970561,4970562,4970563,4970568,4970573,4970577,4970578,4970592,4970599,4970602,4970609,4970611,4970616,4970620,4970628,4970634,4970635,4970636,4970638,4970652,4970657,4970658,4970666,4970667,4970674,4970688,4970700,4970706,4970714,4970715,4970716,4970717,4970728,4970738,4970739,4970740,4970741,4970745,4970749,4970751,4970756,4970763,4970765,4970766,4970776,4970852,4970871,4970880,4970899,4970915,4970962,4970971,4970994,4970996,4970997,4970998,4970999,4971000,4971001,4971002,4971003,4971004,4971005,4971006,4971009,4971010,4971011,4971012,4971013,4971014,4971015,4971016,4971017,4971018,4971026,4971027,4971054,4971055,4971056,4971057,4971058,4971060,4971061,4971062,4971143,4968152,4968153,4968199,4968200,4968201,4968202,4968203,4968204,4968205,4968206,4968207,4968208,4968209,4968210,4968211,4968212,4968213,4968214,4968215,4968216,4968217,4968218,4968219,4968220,4968221,4968222,4968223,4968224,4968225,4968226,4968227,4968228,4968229,4968230,4968231,4968232,4968233,4968234,4968300,4968301,4968302,4968303,4968320,4968321,4968322,4968323,4968324,4968325,4968326,4968327,4968328,4968329,4968330,4968331,4968332,4968333,4968334,4968335,4968336,4968337,4968338,4968339,4968341,4968374,4968405,4968406,4968407,4968408,4968433,4968434,4968435,4968436,4968437,4968438,4968439,4968440,4968441,4968442,4968443,4968444,4968445,4968446,4968447,4968448,4968449,4968450,4968451,4968469,4968470,4968471,4968472,4968473,4968602,4968603,4968635,4968642,4968643,4968668,4968669,4968808,4968809,4968810,4968811,4968812,4968813,4968814,4968815,4968816,4968817,4968818,4968819,4968820,4968821,4968822,4968823,4968824,4968825,4968826,4968827,4968828,4968829,4968830,4968831,4968849,4968859,4968860,4968927,4968928,4968929,4968930,4968931,4968932,4968933,4968945,4968946,4968948,4968949,4968950,4968951,4968952,4968953,4968954,4968955,4968956,4968957,4968958,4968959,4968960,4968961,4968962,4968963,4968964,4968965,4968966,4968967,4969011,4969012,4969051,4969052,4969053,4969054,4969055,4969177,4969527,4969528,4969544,4969545,4969546,4969552,4969553,4969574,4969575,4969576,4969577,4969578,4969579,4969580,4969587,4969589,4969590,4969591,4969594,4969595,4969596,4969597,4969598,4969599,4969600,4969601,4969602,4969603,4969604,4969605,4969606,4969607,4969608,4969609,4969610,4969611,4969612,4969613,4969614,4969615,4969616,4969617,4969618,4969619,4969620,4969621,4969622,4969623,4969624,4969625,4969626,4969627,4969628,4969631,4969634,4969649,4969656,4969658,4969663,4969670,4969671,4969672,4969680,4969690,4969691,4969692,4969693,4969697,4969698,4969699,4969701,4969705,4969712,4969719,4969720,4969721,4969722,4969723,4969724,4969725,4969726,4969727,4969728,4969729,4969730,4969738,4969746,4969749,4969759,4969762,4969768,4969772,4969778,4969789,4969793,4969800,4969814,4969816,4969817,4969824,4969832,4969835,4969841,4969842,4969843,4969844,4969845,4969852,4969856,4969870,4969873,4969876,4969890,4969893,4969903,4969917,4969921,4969930,4969933,4969947,4969975,4969979,4969980,4969981,4969982,4969983,4969984,4969985,4969986,4969987,4969988,4969989,4969990,4969991,4969992,4969993,4969994,4969995,4969996,4969997,4969998,4969999,4970000,4970001,4970002,4970006,4970010,4970017,4970022,4970023,4970024,4970025,4970026,4970027,4970028,4970033,4970035,4970046,4970050,4970051,4970059,4970060,4970061,4970062,4970063,4970064,4970066,4970067,4970068,4970069,4970070,4970071,4970072,4970075,4970088,4970095,4970096,4970103,4970105,4970109,4970117,4970118,4970120,4970121,4970122,4970123,4970124,4970125,4970130,4970133,4970141,8074861,8074862,8074863,8074864,8074865,8074877,8074878,8074879,8074880,8074881,8074882,8074883,8074907,8074908,8074909,8074910,8074911,8074922,8074923,8074924,8074925,8074926,8074927,8074928,8075253,8075288,8075321,8075346,8075347,8075348,8075349,8075350,8075351,8075352,8075353,8075354,8075355,8075356,8075359,8075360,8075361,8075362,8075363,8075366,8075367,8075368,8075369,4967027,4967028,4967029,4967030,4967031,4967045,4967108,4967110,4967480,4967481,4967482,4967483,4967484,4967485,4967486,4967487,4967488,4967516,4967517,4967518,4967519,4967520,4967521,4967522,4967523,4967524,4967525,4967526,4967527,4967528,4967529,4967530,4967531,4967532,4967533,4967534,4967536,4967537,4967540,4967541,4967543,4967545,4967546,4967554,4967567,4967572,4967579,4967583,4967599,4967601,4967607,4967616,4967617,4967620,4967626,4967627,4967628,4967629,4967640,4967651,4967652,4967653,4967666,4967667,4967680,4967683,4967684,4967687,4967700,4967705,4967715,4967716,4967717,4967718,4967719,4967720,4967721,4967722,4967723,4967724,4967725,4967726,4967727,4967730,4967735,4967736,4967737,4967738,4967740,4967741,4967742,4967743,4967744,4967745,4967746,4967747,4967749,4967753,4967755,4967756,4967766,4967769,4967779,4967789,4967790,4967791,4967792,4967793,4967794,4967795,4967798,4967800,4967801,4967810,4967811,4967812,4967813,4967814,4967820,4967823,4967824,4967825,4967878,4967879,4967880,4967881,4967882,4967896,4967897,4967934,4967935,4967985,4967997,4967998,4967999,4968000,4968001,4968002,4968003,4968029,4968060,4968121,4968122,4968123,4968124,4968125,4968126,4968127,4968128,4968129,4968130,4968131,4968132,4968133,4968134,4968135,4968147,4968150,4968151,8072375,8072376,8072377,8072378,8072379,8072380,8072381,8072382,8072397,8072398,8072399,8072400,8072401,8072402,8072403,8072404,8072405,8072406,8072413,8072414,8072415,8072416,8072423,8072424,8072425,8072426,8072429,8072430,8072431,8072432,8072433,8072443,8072444,8072445,8072446,8072455,8072456,8072457,8072458,8072470,8072471,8072535,8072536,8072537,8072538,8072539,8072562,8072563,8072564,8072565,8072698,8072699,8072700,8072701,8072702,8072703,8072704,8072705,8072706,8072707,8072708,8072709,8072710,8072711,8072712,8072713,8072714,8072715,8072716,8072717,8072718,8072719,8072720,8072721,8072722,8072723,8072724,8072725,8072726,8072727,8072728,8072729,8072730,8072731,8072732,8072733,8072734,8072735,8072736,8072737,8072738,8072739,8072740,8072741,8072742,8072743,8072744,8072745,8072746,8072747,8072748,8072749,8072750,8072751,8072752,8072770,8072906,8072914,8073077,8073481,8073482,8073483,8073484,8073497,8073506,8073511,8073516,8073518,8073519,8073520,8073526,8073538,8073545,10622972,10623064,10623065,10623100,10623125,10623126,10623164,10623185,10623186,10623187,10623188,10623189,10623190,10623191,10623192,10623193,10623194,10623195,10623196,10623197,10623201,10623202,10623203,10623204,10623205,10623206,10623207,10623215,10623216,10623236,10623328,10623355,10623356,10623357,10623358,10623359,10623360,10623361,10623362,10623363,10623364,10623365,10623422,10623451,10623492,10623494,10623505,10623576,10623577,10623584,10623652,10623653,10623654,10623658,10623788,10623789) 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'