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(10975620,10975621,10975622,10975623,10975624,10975625,10975626,10975627,10975628,10975629,10975630,10975631,10975632,7068175,7076264,7076266,7076395,4970915,10940360,7068748,7068749,7068763,10940396,10940412,10940417,7068795,10940419,7068797,7068798,10940422,10940423,7068801,7068802,10940426,10940427,10940428,10940429,10940438,11015523,7068846,7068848,7068849,7068850,7068851,7068852,7068859,7068862,7068863,7068867,7068869,7068871,7068872,7068874,7068875,7068877,7068878,7068880,7068881,7068883,10933331,4968433,4968436,7074259,7074267,7074277,7074278,7074280,7074281,7074282,7074283,7074284,7074285,7074286,7074287,7074289,4968558,10437321,10977282,10977338,10977436,10977437,10977438,8067732,8067733,10437684,10437720,7066894,8067855,7075068,8068046,7067243,10961931,7067248,7067249,10987950,10987951,10987952,7075325,8068218,4969581,8068285,8068286,7067448,11001144,10988246,10939191,10939192,10988385,10988386,10988387,10988388,10988389,10988390,10988391,10988392,10988393,10939381,8068803,10975619,10986018,10973097,10973158,10986199,10986200,8065506,7064657,10960440,7072922,7072923,7072926,10999627,10960783,10960784,7073174,8066193,8066194,8066195,8066196,8066198,8066199,8066200,8066206,8066208,8066251,7073289,10932663,10932664,10932666,11000003,10932667,10932668,10932669,8066300,8066365,7073400,8066401,8066434,7065460,7073486,7073492,7073548,10974594,10974595,10974596,10974597,10974598,10974599,10974600,10974601,10974602,10974603,10974604,10974605,10974606,10974607,10933270,10933271,10974608,10974609,10974610,10971624,10971681,10971691,10971702,10971726,10971734,10971799,10971815,10971845,10971858,10971946,10971951,10971952,10971962,10971965,10971980,10972032,10972033,10972034,7071397,10972086,10959092,10972108,10972109,10972111,10972112,10972113,10972114,11049364,11049365,10943115,10959199,10959200,10943160,10985264,10985265,10972323,10972351,10972356,10972357,10972359,10985363,10972368,10972371,10985492,10985493,10972547,10972553,7068937,7068965,10969712,10969713,10969714,10969715,10969716,10969774,10969775,10995961,10970108,10944969,7069556,10970474,10970528,10970529,10970530,10970531,10970532,3656530,3656531,3656532,3656533,3656534,3656535,3656536,3656537,11009714,10983728,3656648,10983766,10983767,10983768,10983769,10983770,10983771,10983789,7070181,11010041,10971129,10971130,10971185,11010242,11010244,11010264,11010265,11010266,11010267,11010268,11048691,11048692,11048693,11048694,10971556,11006921,10954946,10967954,10954963,11007082,11007121,10982056,11008180,10616984,10922557,10922567,10922568,10922569,10922570,10922571,10922572,10922573,10922574,10922575,10622093,10622282,10622285,10622387,10622470,10993358,10993359,11006425,11006544,11006545,11006546,11006547,11006548,11006549,10977712,10615078,10615079,10615116,10977822,10977832,10977833,10977834,10925689,10925690,10977839,10977842,10977867,10977868,10977869,10977870,10977871,10977872,10977873,10977874,10977875,10977876,10977877,10977878,10977891,10977893,10977894,10977895,10977896,10977897,10977898,10977905,11004068,11004069,10615411,8570379,10925976,10978239,10978247,10978249,10978250,10978251,10978252,10978253,10978254,10978255,10978256,10978257,10978258,10978259,10978260,10978261,10978262,10978263,10978264,10978265,10978266,10978267,10978268,10978271,10978277,10978299,10978300,10978301,10978302,10978303,10978304,10978305,10978306,10978307,10978308,10978309,10978310,10978311,10978312,10978313,10978314,10978315,10978316,10978317,10978318,10978319,10978320,10978321,10978322,10978323,10978324,10978325,10978326,10978327,10978328,10978329,10978360,10978361,10978362,10978363,10978364,10978365,10978366,10978367,10978368,10978369,10978370,10978371,10978372,10978373,10978374,10978375,10978376,10978377,10978378,10978379,10978380,10978381,10978382,10978383,10978384,10978385,10978386,10978387,10978388,10978389,10978390,10978391,10978396,10978397,10978398,10978404,10978406,10978407,10978408,10978424,10921279,10921282,10978445,10978446,10978447,10978448,10978453,10978454,10978455,10978456,10978457,10615803,10978462,10926319,10926320,10978470,10926323,10978471,10926324,10926325,10926326,10926327,10926328,10978476,10978478,10926332,10926333,10926335,10926336,10978484,10926337,10978485,10978486,10978487,10978488,10978489,10926342,10978494,10926347,10978495,10926348,10978496,10978497,10978498,10615841,10978500,10978505,10978507,10978508,10978509,10978510,10978511,10978512,10978513,10978514,10978515,10978516,10978517,10978518,10978519,10978520,10978521,10978522,10978523,10978524,10978525,10978526,10978527,10978528,10978529,10978530,10978531,10978532,10978533,10978534,10978535,10978536,10978537,10978540,10978548,10978553,10978623,10978626,10978628,10978631,10978648,10978655,10978656,10978657,10978660,10978686,10978697,10978699,10978700,10978703,10978709,10978725,10978745,10978746,10978747,10978748,10978749,10978768,10978769,10978770,10978771,10978777,10978778,10978790,10978791,10621134,10978793,10978794,10621138,10978797,10978798,10978801,10621145,10621156,10621157,10621158,10621159,10621162,10616173,10621282,10621283,10978982,10978983,10621360,10616366,10621370,10621408,10616559,10616571,10927121,10927122,10927123,10927173,7059490,7059491,7059492,7059577,10559252,10559253,10559254,10559255,10559256,10559257,10559258,10559259,10559260,10559268,10559269,10559270,10559279,10559280,10559281,10559282,10559291,10565343,10565344,10565345,9165608,10611580,10611604,9181971,9181972,9182026,9182027,9182050,9182051,9182052,9182053,9182054,9182055,9182057,9182059,9166216,10563075,10563076,10563080,9171300,10611969,10611987,10557139,10557141,10557147,10557149,10557150,10557151,10557152,10557153,10557154,10557155,10557156,10557158,10557160,10557162,10557165,10557167,10557168,10557173,10557174,10557175,10557176,10557179,10557180,10557181,10557182,10557183,10557188,7057596,10609117,9172127,9172147,9172172,10609836,7058357,10558142,10613171,10610197,7058748,9180615,9180616,9180617,9180618,10561435,10561436,10613293,10613294,10613295,10613296,10561449,10613299,10561450,10564454,10561457,10561480,10561487,10610339,10561491,10561493,10561498,8863298,8863299,9180824,10564670,10564671,10564672,10564673,10564674,10564675,10564676,8863392,10564761,10564765,8863518,8863519,8863520,9177324,7055496,9161355,7055534,9169399,7055722,10513401,7055836,10515492,7055882,10517551,9169819,4974756,4974757,4974758,9177910,9177915,9177953,4974935,4974936,4974937,10513918,10513919,10513920,10513921,4974966,9178156,4975050,4975053,10514014,9178240,9178246,9178253,9178254,7056420,9178255,9178261,9178264,9178265,9178266,9178267,9178268,9178269,7056436,9178270,9178271,9178272,9178273,9178274,7056441,7056442,7056443,7056444,9178279,7056449,7056450,7056451,7056455,7056460,7056463,7056464,7056467,7056471,7056474,9178321,9178361,9178362,9178365,9178366,9178370,9178371,9178372,9178373,9178375,9178383,9178384,9178385,9178386,9178387,4975274,2809380,10514794,7057176,9171020,9171021,9171022,9171025,9171026,10514873,7057312,7057323,7057324,7057325,10515033,7057459,8917976,8917977,8918029,8918030,10416407,10416602,9168712,9168955,9169031,6666310,8864846,6666323,8864847,10470927,8864895,10463013,10469035,6666575,6666576,6666577,6666582,6666583,6666590,4971510,4971511,4971627,4971974,4971978,4971979,4971989,4971991,4972003,4972005,4972007,4972020,4972026,4972027,4972030,4972031,10467828,10469945,9167433,9167458,9167459,9167469,9167471,6667477,6667478,6667479,9167517,8563426,9167538,8917199,8917200,8917201,8563459,10466220,9167737,8917492,10466432,10466433,10466434,10466435,10462624,10470850,10154613,10628115,10628251,10628252,10164791,10164792,10164793,10164794,10164795,10164796,10164797,10164798,10164799,10164800,10164880,10164881,10164882,10165395,10165396,10165870,10165871,10165872,10165964,10165965,10165966,10165967,10165968,10166142,10166233,10166234,10166235,10627098,10627100,10627103,10627104,10627319,10627787,10627814,10627840,10627841,10627849,10627884,10627928,10630100,10630101,10630102,10630103,10630104,10630105,10625156,10625157,10625158,10631134,10162695,10575979,10575980,10521257,10521286,10521288,10521289,10523671,10523698,10523699,10523700,10523701,10523702,10523703,10523706,10523707,10522176,10522780,10524817,10524818,10524819,10523041,10423384,10423387,10423388,10423389,10423720,10423721,10423722,10423723,10423855,10421080,10421081,10472890,10472891,10472896,10472913,10479226,10479267,10479460,10479467,10479472,10479535,10479536,10479540,10479541,10479542,10479543,10479544,10479545,10479546,10479547,10479548,10479549,10479550,10479551,10479552,10479553,10479554,10479562,10479573,10479575,10479581,10475728,10475729,10474122,10478195,10478196,10478704,10478705,10478706,10478744,10478745,10478752,10478753,10478754,10478755,10478756,10478757,10478758,10472818) 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'