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(10940001,10989268,4970860,10976487,8068066,10986217,10986218,10932250,10932604,10932621,10932662,7073645,7073646,11049375,11049378,3655549,10944451,10940732,10940733,10940734,10940735,10940736,10940737,10940738,10940739,10940740,7069267,10944744,10970211,10970212,10970213,10970214,10970215,10970216,10970217,10970218,10970219,10970220,10970221,10970222,10970223,10970224,10970225,10970226,10970227,10970228,10970229,10970230,10970231,10970232,10970233,10970234,10970235,10970236,10970237,10970238,10970239,10970240,10970241,10970242,10970243,10970244,10970245,10970246,10970247,10970248,10970249,10970250,10970251,10970252,10970253,10970254,10970255,10970256,10970257,10970258,10970259,10970260,10970261,10970262,10970263,10970264,10970265,10970266,10970267,10970268,10970269,10970270,10970271,10970272,10970273,10970274,10970275,10970276,10970277,10970278,10970279,10970280,10970281,10970282,10970283,10970284,10970285,10970286,10970287,10970288,10970289,10970290,10970291,10970292,10970293,10970294,10970295,10970296,10970297,10970298,10970299,10970300,10970301,10970302,10970303,10970304,10970305,10970306,10970307,10970308,10970309,10970310,10970311,10970312,10970313,10970314,10970315,10970316,10970317,10970318,10970319,10970320,10970321,10970322,10970323,10970324,10970325,10970326,10970327,10970328,10970329,10970330,10970331,10970332,10970333,10970334,10970335,10970336,10970337,10970338,10970339,10970340,10970341,10970342,10970343,10970344,10970345,10970346,10970347,10970348,10970349,10970350,10970351,10970352,10970353,10970354,10970355,10970356,10970357,10970358,10970359,10970360,10970361,10970362,10970363,10970364,10970365,10970366,10970367,10970368,10970369,10970370,10970371,10970372,10970373,10970374,10970375,10970376,10970377,10970378,10970379,10970380,10970381,10970382,10970383,10970384,10970385,10970386,10970387,10970388,10970389,10970390,10970391,10970392,10970393,10970394,10970395,10970396,10970397,10970398,10970399,10970400,10970401,10970402,10970403,10970404,10970405,10970406,10970407,10970408,10970409,10970410,10970411,10970412,10970413,10970414,10970415,10970416,10970417,10970418,10970419,10970420,10970421,10970422,10970423,10970424,10970425,10970426,10970427,10970428,10970429,10970430,10970431,10970432,10970433,10970434,10970435,10970436,10970437,10970438,10970439,10970440,10970441,10970442,10970443,10970444,10970445,10970446,10970447,10970448,10970449,10970450,10970451,10970452,10970453,10970454,10970455,10970456,10970457,10970458,10970459,10970460,10970461,10970462,10970463,10970464,10970465,10970466,10970467,10970468,10970469,10970470,10970471,10970472,10970473,10970474,10970475,10970476,10970477,10970478,10970479,10970480,10970481,10970482,10970483,10970484,10970485,10970486,10970487,10970488,10970489,10970490,10970491,10970492,10970493,10970494,10970495,10970496,10970497,10970498,10970499,10970500,10970501,10970502,10970503,10970504,10970505,10970506,10970507,10970508,10970509,10970510,10970511,10970512,10970513,10970514,10970515,10970516,10970517,10970518,10970519,10970520,10970521,10970522,10970523,10970524,10970525,10970526,10970527,10970528,10970529,10970530,10970531,10970532,10970533,10970534,10970535,10970536,10970537,10970538,10970539,10970540,10970541,10970542,10970543,10970544,10970545,10970546,10970547,10970548,10970549,10970550,10970551,10970552,10970553,10970554,10970555,10970556,10970557,10970558,10970559,10970560,10970561,10970562,10970563,10983563,10970564,10983564,10970565,10983565,10970566,10983566,10970567,10983567,10970568,10983568,10970569,10983569,10970570,10983570,10970571,10983571,10970572,10983572,10970573,10983573,10970574,10983574,10970575,10983575,10970576,10983576,10970577,10983577,10970578,10983578,10970579,10983579,10970580,10983580,10970581,10983581,10970582,10983582,10970583,10983583,10970584,10983584,10970585,10983585,10970586,10983586,10970587,10983587,10970588,10983588,10970589,10983589,10970590,10983590,10983591,10970591,10970592,10983592,10970593,10983593,10970594,10983594,10970595,10983595,10970596,10983596,10970597,10983597,10970598,10983598,10970599,10983599,10983600,10983601,10983602,10983603,10983604,10983605,10983606,10983607,10983608,10983609,10983610,10983611,10983612,10983613,10983614,10983615,10983616,10983617,10983618,10983619,10983620,10983621,10983622,10983623,10983624,10983625,10983626,10983627,8072678,10983628,8072679,10983629,8072680,10983630,8072681,10983631,8072682,10983632,10983633,10983634,10983635,10983636,10983637,10983638,10983639,10983640,10983641,10983642,10983643,10983644,10983645,10983646,10983647,10983648,10983649,10983650,10983651,10983652,10983653,3656592,3656593,3656594,3656595,3656596,10942137,11048717,10623303,10619032,10619342,8071123,10622059,10622060,10622061,10622062,10622063,10622064,10622065,10622066,10622067,10622068,10622069,10622070,10622071,10967011,10920684,10920685,10920686,10925850,10925851,10925852,10925865,10925866,10925867,10925868,10930890,10621281,10621282,10621283,7059519,7059520,8864554,8863159,8863160,8863161,8863162,8863163,8863164,8863165,8863166,8863167,8863168,8863169,8863170,10564632,10564633,8863712,8863713,9169491,10518994,10518995,4971160,4971591,4971592,4971593,4971594,4971595,4971596,4971597,4971598,4971599,4972450,4972451,4972452,4972453,4972454,10165489,10165490,10165491,10165492,10165493,10165494,10165495,10165496,10165497,10165498,10165499,10165500,10165501,10165502,10165503,10165504,10165505,10165506,10165507,10165508,10165509,10165510,10165511,10165512,10165513,10165514,10165515,10165516,10165517,10165518,10165519,10165520,10165521,10165522,10165523,10165524,10165525,10165526,10165527,10165528,10165529,10165530,10165531,10165532,10165533,10165534,10165535,10165536,10165537,10165538,10165539,10165540,10165541,10165542,10165543,10165544,10165545,10165546,10165547,10165548,10165549,10165550,10165551,10165552,10165553,10165554,10165555,10165556,10165557,10165558,10165559,10165560,10165561,10165562,10165563,10165564,10165565,10165566,10165567,10165568,10165569,10165570,10165571,10165572,10165573,10165574,10165575,10165576,10165577,10165578,10165579,10165580,10165581,10165582,10165583,10165584,10165585,10165586,10165587,10165588,10165589,10165590,10165591,10165592,10165593,10165594,10165595,10165596,10165597,10165598,10165599,10165600,10165601,10165602,10165603,10165604,10165605,10165606,10165607,10165608,10165609,10165610,10165611,10165612,10165613,10165614,10165615,10165616,10165617,10165618,10165619,10165620,10165621,10165622,10165623,10165624,10165625,10165626,10165627,10165628,10165629,10165630,10165631,10165632,10165633,10165634,10165635,10165636,10165637,10165638,10165639,10165640,10165641,10165642,10165643,10165644,10165645,10165646,10165647,10165648,10165649,10165650,10165651,10165652,10165653,10165654,10165655,10165656,10165657,10165658,10165659,10165660,10165661,10165662,10165663,10165664,10165665,10165666,10165667,10165668,10165669,10165670,10165671,10165672,10165673,10165674,10165675,10165676,10165677,10165678,10165679,10165680,10165681,10165682,10165683,10165684,10165685,10165686,10165687,10165688,10165689,10165690,10165691,10165692,10165693,10165694,10165695,10165696,10165697,10165698,10165699,10165700,10165701,10165702,10165703,10165704,10165705,10165706,10165707,10165708,10165709,10165710,10165711,10165712,10165713,10165714,10165715,10165716,10165717,10165718,10165719,10165720,10165721,10165722,10165723,10165724,10165725,10165726,10165727,10165728,10165729,10165730,10165731,10165732,10165733,10165734,10165735,10165736,10165737,10165738,10165739,10165740,10165741,10165742,10165743,10165744,10165745,10165746,10165747,10165748,10165749,10165750,10165751,10165752,10165753,10165754,10165755,10165756,10165757,10165758,10165759,10165760,10165761,10165762,10165763,10165764,10165765,10165766,10165767,10165768,10165769,10165770,10165771,10165772,10165773,10165774,10165775,10165776,10165777,10165778,10165779,10165780,10165781,10165782,10165783,10165784,10165785,10165786,10165787,10165788,10165789,10165790,10165791,10165792,10165793,10165794,10165795,10165796,10165797,10165798,10165799,10165800,10165801,10165802,10165803,10165804,10165805,10165806,10165807,10165808,10165809,10165810,10165811,10165812,10165813,10165814,10165815,10165816,10165817,10165818,10165819,10165820,10165821,10165822,10165823,10165824,10165825,10165826,10165827,10165828,10165829,10165830,10165831,10165832,10165833,10165834,10165835,10165836,10165837,10165838,10165839,10165840,10165841,10165842,10165843,10165844,10165845,10165846,10165847,10165848,10165849,10165850,10165851,10165852,10165853,10165854,10165855,10165856,10165857,10165858,10165859,10165860,10165861,10165862,10165863,10165864,10165865,10165866,10566532,10566533,10519115,10524403,10524404,10524405,10524406,10524407,10524408,10524409,10524410,10524411,10524412,10524413,10524414,10524415,10524416,10523031,10421223,10422634,10421216,10421217,10421218,10473332,10473333,10473334,10473351,10473409,10473410,10473447,10473448,10473611,10472843) 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'