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(4970232,4970233,4970245,4970246,4970247,4970248,4970249,4970250,4970251,4970252,4970253,4970254,4970255,4970256,4970324,4970403,4970404,4970410,4970417,4970418,4970419,4970420,4970421,4970422,4970423,4970424,4970514,4970515,4970516,4970517,4970518,4970519,4970577,4970578,4970609,4970638,4970646,4970649,4970652,4970654,4970657,4970658,4970666,4970667,4970677,4970680,4970684,4970688,4970689,4970690,4970691,4970699,4970700,4970702,4970706,4970711,4970713,4970714,4970715,4970716,4970717,4970718,4970719,4970720,4970721,4970729,4970738,4970739,4970741,4970742,4970745,4970749,4970751,4970757,4970759,4970767,4970805,4970806,4970835,4970836,4970837,4970838,4970839,4970840,4970841,4970842,4970843,4970844,4970854,4970855,4970856,4970857,4970871,4970872,4970880,4970887,4970895,4970899,4970903,4970904,4970913,4970915,4970917,4970920,4970923,4970925,4970926,4970927,4970928,4970936,4970937,4970938,4970941,4970946,4970947,4970948,4970951,4970956,4970957,4970960,4970961,4970962,4970971,4970976,4970977,4970980,4970981,4970988,4970994,4971001,4971002,4971003,4971004,4971005,4971021,4971023,4971026,4971027,4971028,4971038,4971039,4971040,4971041,4971054,4971055,4971056,4971057,4971058,4971059,4971060,4971061,4971062,4971068,4971069,4971096,4971097,4971098,4971099,4971137,4971138,4971139,4971140,4971141,4971142,4971143,4971145,4968185,4968188,4968189,4968190,4968191,4968192,4968193,4968194,4968195,4968196,4968208,4968209,4968210,4968255,4968256,4968257,4968258,4968259,4968260,4968261,4968262,4968263,4968264,4968265,4968266,4968267,4968268,4968269,4968270,4968271,4968272,4968273,4968274,4968275,4968276,4968277,4968278,4968279,4968280,4968281,4968282,4968283,4968284,4968285,4968286,4968287,4968288,4968289,4968290,4968291,4968292,4968293,4968294,4968295,4968296,4968297,4968298,4968299,4968300,4968301,4968302,4968303,4968304,4968305,4968306,4968307,4968308,4968309,4968312,4968313,4968314,4968315,4968316,4968317,4968318,4968319,4968320,4968321,4968322,4968323,4968324,4968325,4968326,4968327,4968328,4968329,4968330,4968331,4968332,4968333,4968334,4968335,4968336,4968337,4968338,4968339,4968340,4968341,4968342,4968343,4968358,4968359,4968360,4968361,4968362,4968363,4968364,4968365,4968409,4968410,4968411,4968412,4968413,4968461,4968462,4968463,4968475,4968476,4968477,4968478,4968479,4968480,4968481,4968482,4968483,4968484,4968485,4968486,4968487,4968551,4968552,4968602,4968603,4968604,4968605,4968606,4968607,4968608,4968609,4968610,4968611,4968612,4968613,4968614,4968615,4968633,4968635,4968636,4968637,4968638,4968639,4968640,4968641,4968646,4968654,4968661,4968662,4968663,4968668,4968669,4968672,4968673,4968674,4968675,4968676,4968677,4968678,4968679,4968680,4968681,4968682,4968683,4968684,4968685,4968686,4968687,4968688,4968689,4968690,4968691,4968692,4968693,4968694,4968695,4968696,4968697,4968698,4968699,4968700,4968701,4968702,4968703,4968704,4968705,4968706,4968707,4968708,4968709,4968710,4968711,4968712,4968713,4968714,4968715,4968716,4968717,4968718,4968719,4968720,4968721,4968722,4968723,4968724,4968725,4968726,4968727,4968728,4968729,4968730,4968731,4968732,4968733,4968734,4968735,4968736,4968737,4968738,4968739,4968740,4968741,4968742,4968743,4968744,4968745,4968746,4968747,4968748,4968749,4968750,4968751,4968752,4968753,4968754,4968755,4968756,4968757,4968758,4968759,4968761,4968762,4968763,4968764,4968765,4968766,4968767,4968768,4968769,4968770,4968771,4968772,4968773,4968774,4968775,4968776,4968777,4968778,4968779,4968780,4968781,4968782,4968783,4968784,4968785,4968786,4968807,4968841,4968842,4968843,4968844,4968845,4968846,4968847,4968848,4968849,4968850,4968851,4968852,4968853,4968854,4968855,4968856,4968857,4968858,4968859,4968860,4968861,4968862,4968902,4968903,4968904,4968905,4968906,4968907,4968908,4968909,4968910,4968911,4968912,4968913,4968914,4968915,4968916,4968917,4968926,4969125,4969126,4969127,4969128,4969129,4969141,4969142,4969177,4969179,4969192,4969193,4969194,4969195,4969196,4969197,4969198,4969199,4969200,4969201,4969202,4969203,4969204,4969205,4969206,4969207,4969208,4969209,4969210,4969211,4969212,4969213,4969214,4969237,4969238,4969239,4969240,4969241,4969242,4969243,4969244,4969245,4969246,4969247,4969248,4969252,4969257,4969258,4969282,4969285,4969286,4969287,4969288,4969289,4969302,4969312,4969313,4969362,4969363,4969387,4969388,4969389,4969390,4969437,4969438,4969439,4969440,4969441,4969509,4969510,4969511,4969512,4969513,4969514,4969515,4969516,4969517,4969518,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,4969671,4969698,4969699,4969947,4970022,4970023,4970024,4970025,4970026,4970027,4970028,4970059,4970060,4970061,4970062,4970063,8074689,8074690,8074691,8074692,8074693,8074732,8074733,8074734,8074735,8074736,8074777,8074778,8074779,8074780,8074781,8074819,8074820,8074821,8074822,8074823,8074861,8074862,8074863,8074864,8074865,8074907,8074908,8074909,8074910,8074911,8074951,8074952,8074953,8074954,8074955,8074995,8074996,8074997,8074998,8074999,8075040,8075041,8075042,8075043,8075044,8075045,8075086,8075087,8075088,8075089,8075090,8075091,8075128,8075129,8075130,8075131,8075132,8075133,8075134,8075135,8075136,8075137,8075138,8075139,8075140,8075141,8075142,8075143,8075144,8075145,8075146,8075147,8075148,8075171,8075172,8075173,8075174,8075175,8075176,8075177,8075178,8075179,8075180,8075181,8075182,8075183,8075184,8075185,8075186,8075187,8075188,8075189,8075190,8075191,8075217,8075226,8075257,8075272,8075288,8075313,8075314,8075315,8075320,8075321,8075322,8075323,8075333,8075334,8075335,8075336,8075473,8075474,8075475,8075476,8075477,8075478,8075479,8075480,8075481,8075482,8075483,8075484,8075485,8075486,8075487,4967030,4967031,4967033,4967034,4967039,4967041,4967042,4967043,4967044,4967045,4967047,4967053,4967054,4967062,4967063,4967064,4967065,4967066,4967067,4967073,4967074,4967075,4967076,4967090,4967102,4967103,4967105,4967108,4967110,4967112,4967113,4967114,4967115,4967116,4967117,4967118,4967119,4967120,4967121,4967122,4967123,4967124,4967125,4967126,4967127,4967128,4967129,4967130,4967131,4967132,4967133,4967134,4967135,4967136,4967137,4967138,4967139,4967140,4967141,4967142,4967143,4967144,4967145,4967146,4967147,4967148,4967154,4967159,4967160,4967162,4967163,4967164,4967165,4967166,4967188,4967189,4967190,4967191,4967193,4967195,4967197,4967198,4967203,4967204,4967208,4967209,4967210,4967218,4967225,4967226,4967227,4967235,4967242,4967243,4967244,4967248,4967252,4967256,4967263,4967281,4967282,4967285,4967294,4967314,4967317,4967318,4967319,4967320,4967321,4967322,4967337,4967338,4967340,4967345,4967349,4967350,4967353,4967354,4967359,4967362,4967363,4967364,4967375,4967376,4967388,4967389,4967390,4967391,4967392,4967408,4967410,4967412,4967417,4967418,4967419,4967420,4967421,4967422,4967423,4967424,4967425,4967428,4967440,4967451,4967452,4967453,4967454,4967456,4967459,4967461,4967462,4967463,4967464,4967465,4967466,4967467,4967468,4967469,4967470,4967471,4967472,4967473,4967474,4967475,4967476,4967477,4967478,4967479,4967480,4967481,4967482,4967483,4967484,4967485,4967486,4967487,4967488,4967489,4967490,4967491,4967492,4967493,4967494,4967495,4967496,4967497,4967498,4967499,4967500,4967501,4967502,4967503,4967504,4967505,4967506,4967507,4967508,4967509,4967511,4967512,4967513,4967514,4967515,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) 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'