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(8068847,10939584,10939586,10939604,10939605,10939606,10939611,10939612,10939642,10939643,10939644,7068228,7068247,7068248,7068255,7068256,7068283,7068288,7068289,7068295,7068333,4970696,10940152,10940162,10940167,10940169,10940186,10940192,10940196,7068796,10940425,10940426,10940427,10940442,10940447,10940490,7068902,10940525,10940526,7068906,7068912,7068920,10944347,10944348,8066962,7066141,10437397,7066726,7066728,7066755,7066784,7066790,7066803,7066804,7066805,7066821,7066822,7066866,7066867,7066888,7066890,7066891,7066917,10437774,7066939,8067928,7067371,7067372,10939102,7067541,7067542,7067552,7067553,7067554,7067555,8068487,8068612,8068613,8068614,8068615,8068659,8068660,8068661,8068662,8068663,8068664,8068665,8068666,10939412,8068722,8068723,8068724,10931546,10931640,7064401,10931896,10931897,8066166,8066197,7065357,8066442,8066443,8066444,8066445,8066446,10932931,10932950,8066589,8066590,8066591,8066592,8066593,8066594,8066595,8066596,8066597,8066598,8066599,8066600,8066601,8066602,8066603,8066604,8066605,8066606,8066692,8066693,8066694,8066695,8066696,8066697,8066698,8066699,8066700,8066701,8066702,8066703,8066704,8066705,8066706,8066707,8066708,8066709,8066710,8066711,8066712,7065933,11048905,10942753,10943183,10943377,10943380,10943391,10943393,10943412,3655535,3655536,3655548,10940722,10940772,10941117,10944990,10944991,10944992,8072560,8072561,8072588,8072589,10941615,10942032,11048378,11048540,11048541,3657273,10942410,10942471,10942472,10622970,10928679,8070701,8070711,8070714,8070720,8070721,10622067,10622068,10622069,10622123,10622273,10622289,10622290,10622291,10622292,10622293,10622294,10622361,10622362,10622378,10622427,10622429,10622447,10622448,10622449,10622501,10622502,10622538,10928320,10622871,10921556,10921557,10921558,10921559,10921612,10921613,10921619,10621163,10926755,10926756,10926868,10621444,10621459,10621460,10621461,10621462,10621463,10621480,10621481,10621482,10621483,10621484,10621485,10927019,10621620,10621640,10621641,10621642,10922205,10922206,10621697,10922207,10621728,10565197,10614078,10614079,10614085,10614086,10565319,10565347,10611372,10614560,10611561,10611796,10611846,10611897,10611980,10609020,10609024,10563568,10609420,10557610,10557619,10557620,10612490,10612491,10612492,10612499,10557654,10612505,10557655,10557656,10557657,10612513,10557665,10612516,10557666,10612529,10609556,10609559,10612564,10612601,10612663,10612666,10612667,10612668,10612679,10612680,10612693,10612699,10612704,10612726,10612737,10609743,10609749,10612758,10612763,10612764,10612765,10612766,10612767,10612771,10612795,10612834,10612842,10612869,10609895,10609995,10609996,10609997,10609998,10613001,10610007,10610011,10610012,10610013,10610014,10610016,10610027,10610028,10610029,10610042,10610070,10610093,10610094,10610095,10610111,10610113,10610114,10610115,10564313,10610172,10610173,10610175,10610176,10610177,10610180,10610191,10610193,10564376,10564377,10564378,10610255,10610269,10610279,10610291,10558442,10613293,10558443,10610293,10613294,10558444,10613295,10558445,10613296,10558446,10613297,10558447,10613298,10558448,10613299,10558449,10613300,10558450,10613301,10558451,10613302,10613303,10558453,10613304,10558464,10610314,10558465,10558466,10558467,10558471,10558478,10613363,10613364,10613369,10558542,10558543,10558544,10558545,10610395,10558546,10558547,10558548,10558549,10558550,10558551,10558552,10558553,10558554,10610404,10558555,10610405,10558556,10558557,10610414,10610421,10610437,10610439,10610440,10610441,10558597,10558598,10558599,10558600,10558601,10558602,10558603,10558604,10558605,10558606,10558607,10558608,10558609,10558610,10558611,10610461,10558612,10558613,10558614,10558615,10558616,10558617,10610469,10610474,10610477,10610959,10517117,10517118,10517119,10517120,10517121,10517122,10517123,10517124,10517125,10517126,10517127,10517128,10517129,10517130,10517131,10517132,10517133,10517134,10517135,10517136,10517137,10517138,10517139,10517140,10517141,10517170,10517171,10517172,10517173,10517174,10517175,10517176,10517177,10517178,10517220,10517221,10517224,10517225,10517248,10517249,10517250,10517251,10517256,10517276,10517282,10517283,10517284,10517290,10517291,10517292,10517296,10517297,10517320,10513342,10513343,10517350,10517351,10517352,10517353,10517354,10517355,10517356,10511460,10511461,10511477,10511494,10511495,10511501,10511502,10511503,10511504,10511505,10511507,10511508,10511509,10511510,10511520,10511523,10511524,10511525,10511526,10511527,10511528,10511529,10511530,10511539,10511545,10517546,10517547,10517548,10517549,10517552,10517607,10517608,10517620,10517621,10511632,10511662,10511669,10511676,10517681,10511687,10511692,10511693,10511694,10511695,10511696,10511697,10511698,10511699,10511700,10511701,10511702,10511703,10511709,10511722,10511723,10511724,10511731,10511734,10511735,10513740,10511744,10511745,10511746,10517788,10513909,10513910,10513911,10513912,10513960,10513965,10513966,10514003,10514017,10514018,10514025,10514026,10514027,10514036,10514037,10514038,10514043,10514044,10514045,10514046,10514047,10514048,10514049,10514050,10514051,10514052,10514053,10514054,10514055,10514056,10514057,10514058,10514083,10512085,10512086,10512087,10512088,10512089,10514090,10512090,10512091,10514091,10514092,10512092,10514093,10512093,10514094,10512094,10512095,10514095,10514096,10512096,10512097,10514097,10514098,10512098,10512099,10514099,10512100,10514100,10512101,10512102,10514102,10512103,10514103,10512104,10512105,10512106,10512107,10514107,10512108,10514118,10514120,10514126,10514127,10514128,10514131,10514132,10514135,10514136,10514140,10514147,10514150,10514154,10514155,10514157,10514166,10514170,10514193,10514194,10514195,10514196,10514202,10514203,10514204,10514205,10514206,10514208,10514209,10514210,10514211,10514212,10514213,10514214,10514215,10514216,10514217,10514220,10514227,10514228,10514230,10514232,10514242,10514244,10514246,10514247,10514248,10514249,10514250,10514255,10514259,10514260,10514261,10514262,10514263,10514264,10514265,10514266,10514267,10514268,10514269,10514270,10514271,10514272,10514273,10514274,10514275,10514276,10514277,10514278,10514279,10514281,10514283,10514284,10514286,10514290,10514291,10514292,10514320,10514321,10514322,10514323,10514324,10514325,10514326,10514327,10514328,10514329,10514330,10514331,10514332,10514333,10514334,10514335,10514336,10514337,10514338,10514339,10514340,10514341,10514342,10514343,10514344,10514345,10514346,10514347,10514348,10514349,10514350,10514357,10514358,10514359,10514360,10514361,10514362,10514363,10514364,10514366,10514367,10514368,10514369,10514370,10514371,10514372,10514373,10514374,10514375,10514376,10514377,10514378,10514379,10514380,10514381,10514382,10514383,10514384,10514385,10514386,10514387,10514388,10514389,10514390,10514391,10514392,10514393,10514394,10514395,10514396,10514397,10514398,10514399,10514400,10514401,10514402,10514403,10514404,10514405,10514406,10514407,10514408,10514409,10514410,10514411,10514412,10514413,10514414,10514415,10514416,10514417,10514418,10514419,10514420,10514421,10514422,10514423,10514424,10514425,10514426,10514427,10514428,10514429,10514430,10514431,10514432,10514433,10514434,10514435,10514436,10514437,10514438,10514439,10514440,10514441,10514442,10514443,10514444,10514445,10514446,10514447,10514448,10514449,10514450,10514451,10514452,10514453,10514454,10514455,10514456,10514457,10514459,10514460,10514463,10514464,10514465,10514466,10514467,10514468,10514469,10514470,10514471,10514473,10514474,10514475,10514476,10514477,10514478,10514479,10514480,10514481,10514482,10514483,10514484,10514500,10514501,10514502,10514503,10514504,10514505,10514506,10514507,10514508,10514509,10514510,10514511,10514512,10514513,10514514,10514515,10514516,10514517,10514518,10514519,10514520,10514521,10514522,10514523,10514524,10514525,10514526,10514527,10514528,10514529,10514530,10514531,10514532,10514533,10514534,10514535,10514536,10514537,10514538,10514539,10514540,10514541,10514544,10514545,10514546,10514547,10514548,10514549,10514550,10514551,10514552,10514553,10514554,10514555,10514556,10514557,10514558,10514564,10514565,10514566,10514567,10514568,10514569,10514570,10514571,10514572,10514573,10514574,10514575,10514576,10514577,10514578,10514579,10514580,10514581,10514582,10514583,10514584,10514585,10514586,10514587,10514588,10514589,10514590,10514591,10514592,10514593,10512911,10512962,10519012,10519013,10519014,10519015,10519016,10519017,10519018,10519019,10519020,10519021,10415302,10415303,10415304,10415305,10415343,10419385,10416494,10416495,10419735,10415777,10415821,10415826,10415834,10415837,10419862,10415885,10415886,10419901,10419902,10419903,10419907,10419913,10419931,10419973,10420149,10420164,10420165,10420182,10420190,10420195,10420196,10420200,10420208,10420212,10471327,10471328,10471341,10463399,10470001,10470002,10470003,10470061,10462451,10470535) 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'