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,4970153,4970154,4970164,4970169,4970170,4970179,4970185,4970191,4970193,4970194,4970195,4970196,4970197,4970198,4970199,4970200,4970201,4970202,4970203,4970205,4970209,4970213,4970216,4970218,4970219,4970220,4970221,4970222,4970223,4970224,4970225,4970226,4970227,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,4970258,4970260,4970261,4970263,4970265,4970266,4970267,4970270,4970272,4970273,4970274,4970276,4970281,4970285,4970287,4970290,4970292,4970293,4970295,4970299,4970300,4970301,4970302,4970303,4970304,4970305,4970306,4970307,4970308,4970309,4970310,4970311,4970312,4970314,4970315,4970316,4970317,4970318,4970321,4970323,4970324,4970325,4970331,4970332,4970335,4970336,4970337,4970338,4970340,4970350,4970357,4970361,4970362,4970363,4970366,4970367,4970368,4970369,4970373,4970381,4970383,4970384,4970385,4970386,4970391,4970398,4970399,4970400,4970401,4970402,4970403,4970404,4970405,4970406,4970407,4970408,4970409,4970410,4970412,4970416,4970417,4970418,4970419,4970420,4970421,4970422,4970423,4970424,4970427,4970429,4970430,4970431,4970432,4970433,4970434,4970435,4970436,4970437,4970438,4970439,4970440,4970446,4970450,4970452,4970453,4970454,4970455,4970456,4970459,4970465,4970468,4970477,4970479,4970484,4970485,4970486,4970487,4970488,4970489,4970490,4970491,4970492,4970493,4970498,4970500,4970501,4970502,4970507,4970508,4970509,4970510,4970511,4970512,4970513,4970514,4970515,4970516,4970517,4970518,4970519,4970521,4970528,4970531,4970532,4970537,4970540,4970541,4970542,4970544,4970548,4970549,4970550,4970552,4970560,4970564,4970565,4970566,4970567,4970568,4970569,4970570,4970571,4970572,4970573,4970574,4970575,4970576,4970577,4970578,4970579,4970580,4970586,4970591,4970594,4970598,4970600,4970601,4970606,4970607,4970608,4970609,4970610,4970611,4970612,4970613,4970614,4970615,4970616,4970617,4970618,4970619,4970620,4970621,4970622,4970623,4970624,4970625,4970626,4970627,4970628,4970629,4970630,4970631,4970632,4970633,4970636,4970637,4970638,4970639,4970651,4970654,4970655,4970656,4970666,4970667,4970668,4970669,4970675,4970687,4970688,4970699,4970706,4970713,4970714,4970718,4970741,4970743,4970748,4970749,4970750,4970751,4970752,4970753,4970754,4970755,4970756,4970757,4970777,4970778,4970779,4970785,4970792,4970859,4970865,4970868,4970872,4970877,4970878,4970890,4970891,4970900,4970903,4970911,4970912,4970916,4970920,4970930,4970931,4970932,4970933,4970934,4970935,4970936,4970937,4970939,4970941,4970942,4970949,4970952,4970957,4970958,4970959,4970965,4970966,4970967,4970968,4970972,4970975,4970976,4970985,4970989,4970994,4970995,4970997,4970999,4971001,4971002,4971003,4971004,4971005,4971007,4971008,4971010,4971014,4971016,4971022,4971023,4971030,4971031,4971032,4971033,4971034,4971035,4971036,4971057,4971058,4971070,4971071,4971072,4971128,4971131,4971132,4971136,4971143,4968165,4968166,4968167,4968208,4968209,4968210,4968211,4968212,4968213,4968214,4968215,4968216,4968217,4968218,4968219,4968220,4968229,4968321,4968322,4968323,4968330,4968331,4968332,4968333,4968334,4968405,4968406,4968407,4968408,4968442,4968443,4968565,4968602,4968603,4968635,4968637,4968644,4968646,4968647,4968648,4968649,4968650,4968651,4968668,4968669,4968698,4968699,4968700,4968723,4968784,4968808,4968809,4968810,4968811,4968812,4968813,4968827,4968828,4968829,4968830,4968831,4968843,4968859,4969261,4969262,4969263,4969264,4969285,4969286,4969287,4969288,4969328,4969329,4969340,4969341,4969342,4969382,4969383,4969544,4969545,4969546,4969562,4969571,4969572,4969573,4969575,4969577,4969586,4969587,4969588,4969589,4969590,4969591,4969592,4969593,4969594,4969595,4969596,4969597,4969598,4969599,4969600,4969601,4969602,4969603,4969604,4969605,4969606,4969607,4969608,4969609,4969610,4969611,4969612,4969613,4969614,4969615,4969619,4969620,4969621,4969622,4969623,4969625,4969626,4969627,4969628,4969632,4969633,4969634,4969635,4969636,4969637,4969638,4969641,4969642,4969643,4969644,4969645,4969646,4969647,4969648,4969649,4969650,4969651,4969652,4969653,4969654,4969664,4969665,4969666,4969667,4969668,4969669,4969671,4969672,4969673,4969674,4969675,4969676,4969677,4969678,4969679,4969680,4969681,4969682,4969683,4969684,4969685,4969686,4969687,4969688,4969689,4969695,4969696,4969697,4969698,4969699,4969700,4969701,4969702,4969703,4969704,4969705,4969706,4969707,4969708,4969709,4969710,4969711,4969712,4969713,4969714,4969715,4969716,4969717,4969718,4969719,4969721,4969729,4969735,4969745,4969750,4969751,4969755,4969756,4969757,4969758,4969759,4969760,4969761,4969762,4969763,4969764,4969765,4969771,4969775,4969776,4969777,4969778,4969779,4969780,4969781,4969782,4969783,4969784,4969785,4969786,4969787,4969788,4969789,4969790,4969791,4969792,4969793,4969798,4969802,4969803,4969804,4969805,4969806,4969807,4969818,4969819,4969820,4969821,4969822,4969823,4969824,4969825,4969826,4969827,4969828,4969829,4969830,4969831,4969832,4969833,4969834,4969835,4969836,4969842,4969843,4969850,4969858,4969859,4969865,4969866,4969869,4969872,4969874,4969875,4969876,4969877,4969878,4969879,4969880,4969881,4969882,4969883,4969884,4969885,4969887,4969892,4969896,4969900,4969904,4969906,4969907,4969908,4969909,4969910,4969911,4969912,4969913,4969914,4969915,4969916,4969917,4969919,4969938,4969941,4969947,4969948,4969949,4969952,4969956,4969961,4969962,4969964,4969966,4969967,4969968,4969969,4969970,4969971,4969972,4969973,4969974,4969975,4969976,4969977,4969978,4969979,4969987,4969989,4969998,4970002,4970005,4970013,4970014,4970015,4970016,4970017,4970018,4970019,4970020,4970021,4970022,4970023,4970024,4970025,4970026,4970027,4970028,4970029,4970030,4970031,4970032,4970033,4970034,4970035,4970036,4970037,4970038,4970039,4970040,4970041,4970042,4970043,4970044,4970045,4970046,4970047,4970048,4970049,4970054,4970055,4970056,4970057,4970058,4970059,4970060,4970061,4970062,4970063,4970064,4970065,4970073,4970074,4970079,4970081,4970090,4970091,4970092,4970093,4970094,4970095,4970098,4970099,4970100,4970101,4970102,4970103,4970106,4970110,4970112,4970113,4970114,4970115,4970116,4970117,4970118,4970119,4970123,4970128,4970131,4970132,4970134,4970137,4970138,4970139,4970140,4970141,4970142,4970143,4970145,4970146,4970147,4970148,4970149,4970150,4970151,8074856,8074857,8074858,8074859,8074860,8074861,8074862,8074863,8074864,8074865,8074866,8074867,8074868,8074869,8074870,8074871,8074872,8074873,8074874,8074875,8074876,8074902,8074903,8074904,8074905,8074906,8074907,8074908,8074909,8074910,8074911,8074912,8074913,8074914,8074915,8074916,8074917,8074918,8074919,8074920,8074921,8075232,8075233,8075234,8075259,8075261,8075262,8075263,8075264,8075265,8075266,8075321,8075400,8075401,8075404,8075405,8075407,8075408,8075409,8075410,8075413,8075414,8075415,8075432,8075433,8075435,8075436,8075448,8075449,8075450,8075453,8075455,8075488,8075489,4967027,4967028,4967030,4967031,4967032,4967047,4967107,4967109,4967245,4967246,4967247,4967312,4967516,4967517,4967518,4967519,4967520,4967521,4967522,4967523,4967524,4967525,4967526,4967527,4967528,4967529,4967530,4967531,4967532,4967533,4967534,4967535,4967536,4967537,4967538,4967539,4967540,4967541,4967542,4967543,4967544,4967545,4967546,4967547,4967548,4967549,4967550,4967551,4967552,4967553,4967554,4967555,4967556,4967557,4967558,4967559,4967560,4967561,4967562,4967563,4967564,4967565,4967566,4967567,4967568,4967569,4967570,4967571,4967572,4967573,4967574,4967575,4967576,4967577,4967578,4967579,4967580,4967581,4967582,4967583,4967584,4967585,4967586,4967587,4967588,4967589,4967590,4967591,4967592,4967593,4967594,4967595,4967596,4967597,4967598,4967599,4967600,4967601,4967602,4967603,4967604,4967605,4967606,4967607,4967608,4967609,4967610,4967611,4967612,4967613,4967614,4967615,4967616,4967617,4967618,4967619,4967620,4967621,4967622,4967623,4967624,4967625,4967626,4967627,4967628,4967629,4967630,4967631,4967632) 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'