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(10939571,10939589,10939590,10939591,10939646,7068083,10939797,10939826,4970451,4970452,4970453,4970454,4970455,4970456,4970457,4970458,4970459,7068243,4970460,4970461,4970462,4970463,4970464,4970465,4970466,10943670,4970467,4970468,4970469,4970470,4970471,4970472,4970473,4970474,4970475,4970476,4970477,7068292,7068308,7068315,7068316,10943804,10943941,10940163,10940184,10940185,7068562,7068619,7068621,7068627,7068797,10944221,10940433,10940434,7068832,4971070,4971088,7068876,7068884,7068892,7068915,7068916,10944346,10933291,10933314,10933316,10933324,10933392,4968265,7066281,10437170,10437173,8067422,10437302,10437307,7066485,4968712,10437454,10437460,10437508,10437533,7066716,7066743,7066752,7066763,7066766,7066800,7066830,7066836,7066840,7066845,7066858,10437713,10437714,7066871,7066881,7066890,7066892,7066893,4969134,7066930,7067028,7067045,7067053,4969272,7067103,10938857,10938902,7067525,8068462,8068463,8068470,10939347,10939348,10939349,10939350,10939351,10939390,7067815,7067824,10939456,7067886,8068781,10931460,10931472,10931482,10931608,10931718,7064396,7064585,7064589,7064592,7064622,8065717,8065718,8065719,8065720,8065721,10932234,7064964,10932374,7065028,7065054,10932521,10932541,7065254,7065421,7065649,10933112,7065838,10942920,10931210,10944386,3655646,10940841,10940844,10940850,10940851,10941007,10944863,10944864,10944934,10944970,10941215,10941216,10941217,10941218,10941219,10941220,10941221,10941222,10941223,10941224,10941225,3656259,3656374,3656382,3656534,3656722,3656828,11048357,10942099,10942116,3657192,10942282,8073514,8073515,8073516,8073527,10942491,10942508,11048812,11048813,11048814,10928516,10623185,10623186,10623187,10623188,10623189,10623191,10623192,10623193,10623194,10623195,10623196,10623197,10623205,10623493,10624007,8070773,10624453,10624454,10624455,10624456,10624457,10624458,10624459,10624460,10624461,10624462,10624463,10624464,10624465,10624466,10624467,10624468,10624878,10922610,10622296,10622316,10622374,10622413,10622414,10927983,10622473,10927984,10927985,10927988,10622525,10622526,10928103,10622694,10622695,10928459,10925559,10925576,10925592,10620108,10620137,10620208,10620239,10620240,10925756,10620252,10925782,10925783,10925784,10925785,10925793,10925899,10925929,10925957,10925958,10921388,10921389,10921390,10921391,10921392,10921393,10921394,10921395,10921396,10921397,10921398,10921399,10921400,10921401,10921402,10921403,10921404,10921405,10921406,10921407,10921408,10921409,10921410,10921411,10921412,10926413,10921413,10921414,10921415,10921416,10921417,10921418,10921419,10921420,10921421,10921422,10921423,10921424,10921425,10921426,10921427,10921428,10921429,10921430,10921431,10921432,10921433,10921434,10921435,10921436,10921437,10921438,10921439,10921440,10921441,10921442,10921443,10921444,10921445,10921446,10921447,10921448,10921449,10921450,10921451,10921452,10921453,10921454,10921455,10921456,10921457,10921458,10921459,10921460,10921461,10921462,10921463,10921464,10921465,10921466,10921467,10921468,10921469,10621124,10621131,10926762,10926764,10926766,10926771,10621371,10621372,10565114,10565120,10565125,10565126,10611068,10614069,10614125,10565304,10565305,10565306,10565307,10565308,10565309,10565310,10565311,10565312,10565313,10565314,10565315,10565316,10565317,10614737,10611763,10614766,10614767,10614841,10563120,10563129,10563141,10563190,10612055,10609271,10609273,10609375,10609377,10609378,10563564,10563565,10563566,10563570,10563655,10563656,10563661,10563662,10563663,10563664,10563665,10563691,10563701,10563702,10563710,10563741,10612596,10563761,10563767,10563771,10563874,10563875,10563876,10563877,10563878,10563879,10563890,10609844,10564001,10564002,10564003,10564005,10564006,10564007,10564027,10612899,10564084,10564106,10564107,10564108,10564109,10612996,10613002,10610003,10610005,10613007,10613008,10610018,10610019,10610027,10610029,10610040,10610041,10610044,10610050,10610051,10610054,10564219,10564220,10564221,10564222,10564223,10564224,10613074,10564225,10564226,10610093,10610095,10610096,10564258,10564259,10564260,10610167,10610168,10610178,10610181,10610182,10610190,10610191,10610192,10610193,10564379,10564380,10564381,10564382,10564383,10564384,10564409,10564410,10564411,10564412,10564413,10610268,10610293,10613294,10610295,10610323,10610327,10610347,10610355,10610374,10564525,10610381,10610382,10564532,10564535,10564536,10610388,10610391,10610392,10610393,10610394,10610397,10610398,10610399,10564557,10610408,10610411,10564573,10564576,10564598,10610459,10610468,10564628,10564629,10564631,10610483,10564633,10564635,10564636,10610492,10610494,10564646,10564647,10564649,10564651,10564652,10564654,10564656,10564661,10564662,10613522,10564685,10564703,10564758,10564766,10564772,10564813,10564816,10564817,10564821,10564824,10610721,10564872,10564921,10564928,10564929,10564932,10610788,10564959,10564967,10564980,10564995,10565021,10565025,10610880,10565039,10565078,10565090,10565107,10511112,10511113,10511114,10511115,10511116,10511117,10511118,10511119,10511120,10511121,10511122,10511123,10511124,10511125,10511126,10511127,10511128,10511129,10511130,10511131,10511132,10511133,10511134,10511135,10511136,10511137,10511138,10511139,10511140,10511141,10511142,10511143,10511144,10511145,10511146,10511147,10511148,10511149,10511150,10511151,10511152,10511156,10511168,10511169,10511171,10511174,10511175,10511176,10511177,10511199,10511209,10511210,10511211,10511212,10511213,10511214,10511215,10511216,10511217,10511218,10511219,10511220,10511221,10511222,10511228,10511229,10511230,10511231,10517232,10511232,10517233,10511233,10511234,10517238,10517239,10517240,10511248,10511249,10511250,10511251,10511252,10511253,10511258,10511259,10511260,10517272,10517273,10517274,10517275,10517276,10511281,10511282,10511284,10511285,10511286,10511287,10511288,10511289,10517290,10511290,10517291,10511291,10517292,10511292,10517293,10511293,10517294,10511294,10517295,10511295,10511296,10511297,10511298,10511299,10511300,10511301,10511302,10511303,10511304,10511305,10511306,10511307,10511308,10511309,10511310,10511311,10511312,10511313,10511314,10511315,10511316,10517324,10511328,10511329,10511330,10511331,10511332,10511334,10511335,10511336,10511340,10511341,10511342,10511343,10511344,10511345,10511346,10511347,10511348,10511349,10511350,10511351,10511352,10511353,10511354,10511355,10511356,10511357,10511358,10511359,10517360,10511360,10511361,10511362,10511363,10511364,10511365,10511366,10511367,10511368,10511369,10511370,10511371,10511372,10511373,10511374,10511375,10511376,10511377,10511378,10511379,10511380,10511383,10511384,10517385,10511385,10511386,10511388,10511389,10511390,10511391,10511392,10511393,10511394,10511395,10511396,10511397,10511398,10511399,10511400,10511401,10511402,10511403,10511404,10511405,10511407,10511408,10511409,10511410,10511411,10511412,10511413,10511414,10511415,10511416,10511417,10511418,10511419,10511420,10511421,10511422,10511423,10511424,10511425,10511426,10511428,10511429,10511430,10511431,10511432,10511433,10511434,10511435,10511436,10511437,10511438,10511439,10511440,10511441,10511442,10511443,10511444,10511445,10511446,10511447,10511448,10511449,10511450,10511451,10511452,10511453,10511454,10511455,10511456,10511457,10511458,10511459,10511460,10511461,10511478,10517493,10517502,10517514,10517532,10511550,10511554,10517565,10517566,10517567,10517568,10511570,10517573,10511580,10511582,10517594,10517595,10517596,10517597,10511600,10517605,10517606,10517607,10517608,10511609,10517614,10517615,10517616,10517617,10517618,10511633,10517633,10511635,10511651,10511652,10511657,10517673,10517674,10517675,10517676,10517677,10517678,10517679,10511689,10511705,10511730,10511736,10511748,10511753,10511765,10511770,10517809,10511811,10517812,10517815,10517817,10511823,10517830,10517833,10511835,10517836,10517839,10511851,10517860,10517887,10511894,10511898,10517899,10511922,10517933,10517937,10517938,10517950,10517953,10511954,10517966,10511971,10511974,10517986,10511988,10517988,10511991,10518008,10512020,10512023,10518029,10518037,10518048,10518053,10512057,10518060,10518064,10518082,10518085,10518087,10518089,10518131,10518144,10518148,10518317,10518320,10518419,10518443,10518478,10518484,10518487,10512517,10518539,10512562,10512563,10512564,10512565,10512581,10518815,10512863,10512869,10518877,10518879,10518881,10518883,10512897,10518901,10518902,10512904,10512907,10512908,10512909,10512911,10512916,10512926,10512942,10512943,10512945,10518990,10519015,10519025,10519030,10519082,10519090,10419571,10415679,10416706,10415822,10415837,10420078,10420082,10420138,10420142,10420143,10420144,10420146,10420147,10420152,10420169,10420170,10463013,10471168,10471264,10465434,10471567,10463675,10463739,10463740,10465769,10463833,10463931,10469986,10470040,10470046,10470047,10470048,10470049,8563449,8563471,8563548,10462340,10462342,10462343,10462393,10462425) 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'