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(4970248,4970333,4970342,4970360,4970370,4970385,4970386,4970464,4970465,4970466,4970478,4970479,4970480,4970503,4970552,4970553,4970554,4970555,4970556,4970557,4970558,4970559,4970560,4970561,4970562,4970563,4970636,4970666,4970674,4970680,4970684,4970706,4970714,4970728,4970738,4970745,4970749,4970751,4970756,4970759,4970762,4970767,4970786,4970787,4970788,4970789,4970790,4970804,4970827,4970828,4970829,4970852,4970857,4970872,4970895,4970903,4970904,4970913,4970917,4970920,4970923,4970925,4970926,4970927,4970928,4970936,4970937,4970938,4970946,4970947,4970948,4970956,4970957,4970960,4970961,4970962,4970971,4970976,4970977,4970980,4970981,4970988,4970992,4970993,4970994,4970996,4971003,4971009,4971012,4971013,4971024,4971025,4971029,4971039,4971054,4971055,4971056,4971057,4971058,4971060,4971061,4971062,4971063,4971064,4971065,4971066,4971067,4971068,4971069,4971081,4971096,4971100,4971104,4971105,4971106,4971112,4971113,4971114,4971124,4971143,4968154,4968158,4968174,4968184,4968186,4968187,4968188,4968189,4968190,4968191,4968192,4968195,4968196,4968197,4968198,4968199,4968200,4968201,4968202,4968203,4968204,4968205,4968206,4968207,4968209,4968220,4968221,4968222,4968223,4968226,4968228,4968229,4968231,4968232,4968235,4968236,4968237,4968238,4968239,4968240,4968241,4968242,4968243,4968244,4968245,4968246,4968247,4968250,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,4968294,4968307,4968310,4968311,4968312,4968313,4968314,4968315,4968316,4968317,4968318,4968319,4968320,4968321,4968322,4968330,4968331,4968337,4968342,4968344,4968345,4968346,4968347,4968348,4968349,4968350,4968351,4968352,4968353,4968354,4968355,4968356,4968357,4968358,4968359,4968365,4968366,4968367,4968368,4968369,4968370,4968371,4968372,4968377,4968378,4968379,4968380,4968381,4968382,4968383,4968384,4968385,4968386,4968387,4968388,4968389,4968390,4968391,4968392,4968393,4968394,4968395,4968396,4968397,4968398,4968399,4968400,4968401,4968402,4968403,4968404,4968407,4968409,4968410,4968411,4968412,4968413,4968414,4968417,4968419,4968421,4968425,4968428,4968429,4968430,4968431,4968433,4968434,4968435,4968436,4968437,4968438,4968439,4968440,4968441,4968442,4968443,4968444,4968445,4968446,4968447,4968452,4968453,4968454,4968455,4968456,4968457,4968458,4968475,4968476,4968477,4968478,4968479,4968480,4968481,4968482,4968483,4968484,4968485,4968486,4968487,4968488,4968489,4968490,4968491,4968492,4968493,4968494,4968495,4968496,4968497,4968498,4968499,4968500,4968501,4968502,4968503,4968504,4968505,4968506,4968507,4968508,4968509,4968510,4968511,4968512,4968513,4968514,4968515,4968516,4968517,4968518,4968519,4968520,4968521,4968522,4968523,4968524,4968525,4968526,4968527,4968528,4968529,4968530,4968531,4968532,4968533,4968534,4968535,4968536,4968537,4968538,4968539,4968540,4968541,4968542,4968543,4968544,4968545,4968546,4968547,4968548,4968549,4968550,4968557,4968558,4968559,4968560,4968561,4968562,4968563,4968564,4968565,4968566,4968567,4968568,4968569,4968570,4968571,4968572,4968573,4968574,4968575,4968576,4968577,4968578,4968579,4968580,4968581,4968582,4968583,4968584,4968585,4968586,4968587,4968588,4968589,4968590,4968591,4968592,4968593,4968594,4968600,4968604,4968605,4968606,4968607,4968608,4968611,4968613,4968614,4968619,4968620,4968621,4968622,4968623,4968624,4968625,4968626,4968627,4968631,4968633,4968634,4968635,4968636,4968637,4968638,4968639,4968640,4968641,4968642,4968643,4968644,4968645,4968647,4968651,4968652,4968653,4968654,4968655,4968659,4968661,4968662,4968663,4968665,4968668,4968669,4968670,4968671,4968672,4968673,4968674,4968675,4968679,4968681,4968682,4968683,4968689,4968692,4968695,4968696,4968698,4968703,4968712,4968713,4968719,4968729,4968730,4968731,4968732,4968733,4968734,4968735,4968736,4968737,4968738,4968739,4968740,4968741,4968749,4968753,4968760,4968761,4968762,4968763,4968764,4968765,4968766,4968767,4968768,4968769,4968770,4968771,4968775,4968776,4968777,4968781,4968787,4968789,4968794,4968797,4968808,4968809,4968812,4968817,4968823,4968824,4968825,4968828,4968832,4968833,4968834,4968835,4968836,4968837,4968838,4968839,4968840,4968842,4968843,4968844,4968845,4968846,4968847,4968848,4968854,4968859,4968861,4968862,4968863,4968864,4968865,4968866,4968867,4968868,4968869,4968870,4968871,4968872,4968873,4968874,4968875,4968876,4968877,4968878,4968879,4968880,4968881,4968882,4968883,4968884,4968885,4968886,4968887,4968888,4968889,4968890,4968891,4968892,4968893,4968894,4968895,4968896,4968897,4968898,4968899,4968900,4968901,4968902,4968903,4968904,4968907,4968909,4968917,4968932,4968936,4968942,4968948,4968949,4968950,4968951,4968952,4968953,4968954,4968955,4968956,4968957,4968958,4968959,4968960,4968961,4968962,4968963,4968964,4968965,4968966,4968967,4968968,4968969,4968970,4968971,4968972,4968973,4968974,4968975,4968976,4968977,4968978,4968979,4968980,4968981,4968982,4968983,4968984,4968985,4968986,4968987,4968988,4968989,4968990,4968991,4968992,4968993,4968994,4968995,4969004,4969007,4969008,4969011,4969016,4969017,4969018,4969019,4969020,4969021,4969022,4969023,4969024,4969025,4969026,4969027,4969028,4969029,4969030,4969031,4969040,4969043,4969053,4969066,4969071,4969075,4969076,4969077,4969078,4969079,4969080,4969081,4969082,4969083,4969084,4969085,4969086,4969087,4969088,4969089,4969093,4969099,4969109,4969110,4969115,4969116,4969117,4969118,4969119,4969120,4969121,4969122,4969123,4969124,4969132,4969134,4969135,4969136,4969137,4969138,4969139,4969140,4969148,4969152,4969153,4969154,4969155,4969168,4969169,4969177,4969178,4969179,4969180,4969181,4969182,4969183,4969188,4969191,4969193,4969194,4969195,4969196,4969197,4969198,4969199,4969200,4969201,4969202,4969203,4969204,4969205,4969206,4969207,4969208,4969209,4969210,4969211,4969212,4969213,4969214,4969215,4969216,4969217,4969218,4969219,4969220,4969221,4969222,4969223,4969224,4969225,4969226,4969227,4969237,4969238,4969239,4969240,4969241,4969242,4969243,4969244,4969245,4969249,4969250,4969251,4969257,4969290,4969291,4969292,4969293,4969317,4969364,4969371,4969372,4969373,4969374,4969434,4969435,4969436,4969499,4969500,4969501,4969502,4969503,4969504,4969525,4969526,4969527,4969534,4969535,4969536,4969537,4969538,4969539,4969540,4969541,4969542,4969543,4969546,4969570,4969611,4969612,4969613,4969614,4969620,4969627,4969628,4969670,4969671,4969672,4969690,4969691,4969692,4969720,4969721,4969722,4969723,4969724,4969725,4969726,4969727,4969728,4969729,4969730,4969793,4969816,4969817,4969841,4969842,4969843,4969844,4969845,4969930,4970028,8075217,8075245,8075246,8075270,8075271,8075272,8075273,8075274,8075275,8075280,8075293,8075306,8075314,8075321,8075324,8075325,8075326,8075327,8075328,8075329,8075330,8075331,8075333,8075334,8075335,8075336,8075370,8075371,8075372,8075373,8075374,8075375,8075376,8075377,8075378,8075379,8075380,8075381,8075382,8075383,8075384,8075385,8075386,8075387,8075388,8075389,8075390,8075391,8075392,8075393,8075394,8075395,8075396,8075397,8075398,8075399,8075400,8075401,8075402,8075403,8075404,8075405,8075406,8075407,8075408,8075409,8075410,8075411,8075412,8075413,8075414,8075415,8075416,8075417,8075418,8075419,8075420,8075421,8075422,8075423,8075424,8075425,8075426,8075427,8075428,8075429,8075430,8075431,8075432,8075433,8075434,8075435,8075436,8075437,8075438,8075439,8075440,8075441,8075442,8075443,8075444,8075445,8075446,8075447,8075448,8075449,8075450,8075451,8075452,8075453,8075454,8075455,8075456,8075457,8075458,8075490,8075494,8075495,8075496,8075497,8075498,8075508,8075509,8075511,8075512,8075513,8075514,8075515,8075534,8075535,8075536,8075537,4967027,4967028,4967029,4967030,4967031,4967041,4967053,4967054,4967062,4967063,4967064,4967065,4967066,4967067,4967103,4967112,4967121,4967133,4967137,4967159,4967160,4967318,4967353,4967451,4967452) 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'