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(7065992,8067414,8067415,10437495,10437496,10437497,10437498,10437499,10437500,11001211,10986470,10932596,10932597,10932598,10932599,10932600,10932601,10932602,10932603,10932604,10932605,10932606,10932607,10932608,10932609,10932610,10932611,10932612,10932613,10932614,10932615,10932616,10932617,10932618,10932619,10932620,10932621,10932622,10932623,10932624,10932625,10932626,10932627,10932628,10932629,10932630,10932631,10932632,10932633,10932634,10932635,10932636,10932637,10932638,10932639,10932640,10932641,10932642,10932643,10932644,10932645,10932646,10932647,10932648,10932649,10932650,10932651,10932652,10932653,10932654,10932655,10932656,10932657,10932658,10932659,10932660,10932661,10932662,10932663,10932664,10932665,10932666,10932667,10932668,10932669,10932670,10932671,10932672,10932673,10932674,10932675,10932676,10932677,10932678,10932679,10932680,10932681,10932682,10932683,10932684,10932685,10932686,10932687,10932688,10932689,10932690,10932691,10932692,10932693,10932694,10932695,7073561,7073562,7073563,7073564,7073565,7073566,7073567,7073568,7073569,7073570,7073571,7073572,7073573,7073574,7073575,7073576,7073577,7073578,7073579,7073580,7073581,7073582,7073583,7073584,7073585,7073586,7073587,7073588,10942596,10942597,10942598,10942599,10942600,11049217,11049218,11049219,11049220,11049221,10943329,3655823,3655824,3655825,3655826,3655827,3655828,3655829,3655830,3655831,3655832,3655833,3655834,3655835,3655836,3655837,10996173,10996174,10996175,8073091,8073092,8073093,8073094,8073095,8073096,8073097,8570193,10965294,10930888,10930889,10930890,10930891,10930892,10930893,10930894,10930895,10930896,10930897,10930898,10930899,10930900,10930901,10930902,10930903,10930904,10930905,10559335,10563216,10563217,10563218,10563219,7057856,7057857,7058450,7058451,7058452,10564456,10564457,10564458,10564459,10564460,10564461,10564462,10564463,10564464,10564465,10564466,10564467,10564468,10564469,10564470,10564471,10564472,10564473,10564474,10564475,10564476,10564477,10564478,10564479,10564480,10564481,10564482,10564483,10564484,10564485,10564486,10564487,10564488,10564489,10564490,10564491,10564492,10564493,10564494,10564495,10564496,10564497,10564498,10564499,10564500,10564501,10564502,10564503,10564504,10564505,10564506,10564507,10564508,10564509,10564510,10564511,10564512,10564513,10564514,10564515,10564516,10564517,10564518,10564519,10564520,10564521,10564522,10564523,10564524,10564525,10564526,10564527,10564528,10564529,10564530,10564531,10564532,10564533,10564534,10564535,10564536,10564537,10564538,10564539,10564540,10564541,10564542,10564543,10564544,10564545,10564546,10564547,10564548,10564549,10564550,10564551,10564552,10564553,10564554,10564555,10564556,10564557,10564558,10564559,10564560,10564561,10564562,10564563,10564564,10564565,10564566,10564567,10564568,10564569,10564570,10564571,10564572,10564573,10564574,10564575,10564576,10564577,10564578,10564579,10564580,10564581,10564582,10564583,10564584,10564585,10564586,10564587,10564588,10564589,10564590,10564591,10564592,10564593,10564594,10564595,10564596,10564597,10564598,10564599,10564600,10564601,10564602,10564603,10564604,10564605,10564606,10564607,10564608,10564609,10564610,10564611,10564612,10564613,10564614,10564615,10564616,10564617,10564618,10564619,10564620,10564621,10564622,10564623,10564624,10564625,10564626,10564627,10564628,10564629,10564630,10564631,10564632,10564633,10564634,10564635,10564636,10564637,10564638,10564639,10564640,10564641,10564642,10564643,10564644,10564645,10564646,10564647,10564648,10564649,10564650,10564651,10564652,10564653,10564654,10564655,10564656,10564657,10564658,10564659,10564660,10564661,10564662,10564663,10564664,10564665,10564666,10564667,10564668,10564669,10564670,10564671,10564672,10564673,10564674,10564675,10564676,10564677,10564678,10564679,10564680,10564681,10564682,10564683,10564684,10564685,10564686,10564687,10564688,10564689,10564690,10564691,10564692,10564693,10564694,10564695,10564696,10564697,10564698,10564699,10564700,10564701,10564702,10564703,10564704,10564705,10564706,10564707,10564708,10564709,10564710,10564711,10564712,10564713,10564714,10564715,10564716,10564717,10564718,10564719,10564720,10564721,10564722,10564723,10564724,10564725,10564726,10564727,10564728,10564729,10564730,10564731,10564732,10564733,10564734,10564735,10564736,10564737,10564738,10564739,10564740,10564741,10564742,10564743,10564744,10564745,10564746,10564747,10564748,10564749,10564750,10564751,10564752,10564753,10564754,10564755,10564756,10564757,10564758,10564759,10564760,10564761,10564762,10564763,10564764,10564765,10564766,10564767,10564768,10564769,10564770,10564771,10564772,10564773,10564774,10564775,10564776,10564777,10564778,10564779,10564780,10564781,10564782,10564783,10564784,10564785,10564786,10564787,10564788,10564789,10564790,10564791,10564792,10564793,10564794,10564795,10564796,10564797,10564798,10564799,10564800,10564801,10564802,10564803,10564804,10564805,10564806,10564807,10564808,10564809,10564810,10564811,10564812,10564813,10564814,10564815,10564816,10564817,10564818,10564819,10564820,10564821,10564822,10564823,10564824,10564825,10564826,10564827,10564828,10564829,10564830,10564831,10512145,10512146,4973950,4973951,6667494,6667495,6667496,6667497,6667498,6667499,6667500,6667501,6667502,6667503,6667504,6667505,6667506,6667507,6667508,6667509,6667510,6667511,6667512,6667513,6667514,6667515,6667516,6667517,6667518,6667519,6667520,6667521,6667522,6667523,6667524,6667525,6667526,6667527,6667528,6667529,6667530,6667531,6667532,6667533,6667534,6667535,6667536,6667537,6667538,6667539,8917496,8917497,8917641,8917642,8917643,8917644,8917645,8917646,8917647,8917648,8917649,8917650,8917651,10628722,10628723,10628724,10628725,10628726,10628727,10628728,10628729,10628730,10628731,10628732,10628733,10628734,10628735,10628736,10628737,10628738,10628739,10628740,10628741,10628742,10628743,10522098,10423332,10423333,10423334,10423335,10423336,10423337,10423338,10423339,10423340,10423341,10423342,10423343,10423344,10423345,10423346,10423347,10423348,10423349,10423350,10423351,10423352,10423353,10423354,10423355,10423356,10423357,10423358,10423359,10423360,10423361,10423362,10423363,10423364,10423365,10423366,10423367,10423368,10423369,10423370,10423371,10423372,10423373,10423374,10423375,10423376,10423377,10423378,10423379,10423380,10423381,10423382,10423383,10473249,10473250,10473251,10473252,10473253,10473254,10473255,10473256,10473257,10473258,10473259,10473260,10473261,10473262,10473263,10473264,10473265,10473266,10473267,10473268,10473269,10473270,10473271,10473272,10473273,10473274,10473275,10473276,10473277,10473278,10473279,10473280,10473281,10473282,10473283,10473284,10473285,10473286,10473287,10473288,10473289,10473290,10473291,10473292,10473293,10473294,10473295,10473296,10473297,10473298,10473299,10473300,10473301,10473302,10473303,10473304,10473305,10473306,10473307,10473308,10473309,10473310,10473311,10473312,10473313,10473314,10473315,10473316,10473317,10473318,10473319,10473320,10473321,10473322,10473323,10473324,10473325,10473326,10473327,10473328,10473329,10473330,10473331,10473332,10473333,10473334,10473335,10473336,10473337,10473338,10473339,10473340,10473341,10473342,10473343,10473344,10473345,10473346,10473347,10473348,10473349,10473350,10473351,10473352,10473353,10473354,10473355,10473356,10473357,10473358,10473359,10473360,10473361,10473362,10473363,10473364,10473365,10473366,10473367,10473368,10473369,10473370,10473371,10473372,10473373,10473374,10473375,10473376,10473377,10473378,10473379,10473380,10473381,10473382,10473383,10473384,10473385,10473386,10473387,10473388,10473389,10473390,10473391,10473392,10473393,10473394,10473395,10473396,10473397,10473398,10473399,10473400,10473401,10473402,10473403,10473404,10473405,10473406,10473407,10473408,10473409,10473410,10473411,10473412,10473413,10473414,10473415,10473416,10473417,10473418,10473419,10473420,10473421,10473422,10473423,10473424,10473425,10473426,10473427,10473428,10473429,10473430,10473431,10473432,10473433,10473434,10473435,10473436,10473437,10473438,10473439,10473440,10473441,10473442,10473443,10473444,10473445,10473446,10473447,10473448,10473449,10473450,10473451,10473452,10473453,10473454,10473455,10473456,10473457,10473458,10473459,10473460,10473461,10473462,10473463,10473464,10473465,10473466,10473467,10473468,10473469,10473470,10473471,10473472,10473473,10473474,10473475,10473476,10473477,10473478,10473479,10473480,10473481,10473482,10473483,10473484,10473485,10473486,10473487,10473488,10473489,10473490,10473491,10473492,10473493,10473494,10473495,10473496,10473497,10473498,10473499,10473500,10473501,10473502,10473503,10473504,10473505,10473506,10473507,10473508,10473509,10473510,10473511,10473512,10473513,10473514,10473515,10473516,10473517,10473518,10473519,10473520,10473521,10473522,10473523,10473524,10473525,10473526,10473527,10473528,10473529) 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'