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(8068820,7067882,7067885,7075931,10962687,10962688,10962689,11001725,7076042,7076060,7076095,7076144,7076145,10939900,10988886,7076245,7076249,10943942,7068535,8569560,8569612,8569636,7073831,7073871,10963622,10963623,10963624,7073947,7065967,10963669,10963670,10963671,7074062,7074289,10437249,7066380,8067459,7074415,7074453,7074474,7074498,7074517,11029242,11029243,10437577,10437578,10437579,10437580,8067723,8067724,8067725,7066735,7066748,8067859,7067177,10962056,7075438,7075439,7075554,7067656,10962363,7067716,7067726,7067747,10962455,6000191,11011621,11011678,11011679,11011680,11011681,11011682,11011683,6000282,6000286,11011698,11011699,6000297,7064017,7064018,7064032,11011796,11011797,11011798,11011799,11011800,11011801,11011802,11011868,11011875,11011876,11011884,11011910,11011911,11011925,11011926,11011927,11011928,11011929,11011930,11011931,11011932,11011933,11011934,11011935,10931765,11012030,7064373,11012069,11012070,8075326,10999588,10999589,10932350,10932351,10932352,8066006,8066007,8066008,8066009,8066010,8066098,7065045,8066115,7073224,10932664,7065256,10986973,7073525,7073529,7073685,10942580,10942587,10942634,10942719,10942723,8860942,10942761,7071573,7071584,7071609,11011301,11011302,11011374,11011375,11011376,5999980,10943416,10943417,11011393,6000066,6000068,6000074,6000082,7071815,10944418,10944436,10944439,10944440,3655676,3655677,3655678,3655679,3655680,10941153,7069593,8072646,8072651,8072656,8072661,8072666,8072671,8072676,8072681,8072686,8072691,8072696,8072701,8072706,8072711,8072716,8072721,8072726,8072731,8072736,8072741,8072746,8072751,8072756,8072761,8072766,8072771,8072776,8072781,8072786,8072791,8072799,8072807,8072815,8072823,10941689,8072831,8072839,8072851,8072859,8072871,8072879,8072889,8072895,8072907,8072915,8072923,10941784,8072930,8072941,8072948,8072956,10941821,8072964,10941829,8072972,8072980,10941862,11009878,11009879,11009880,11009881,11009882,11009883,11009884,11009885,11009886,11009887,11009888,10941920,10941921,11009905,11009906,11009907,11009908,11009909,11009910,11009911,11009912,11009913,10941963,10941975,10941976,10941980,10941989,7070306,10942029,10942030,7070317,7070318,10942089,8860448,8073462,8860612,7070729,7070741,7070801,10967568,10928627,11006889,11006890,10618364,10618366,10618391,11007063,11007064,11007122,11007133,10994489,10968557,11007684,11007685,11007707,11007708,10619172,10624201,10624202,10624203,10995149,10995150,10995151,11008189,11008190,11008191,11008192,11008193,11008194,11008195,11008196,11008197,11008198,11008199,11008200,11008201,11008202,11008203,11008204,11008205,11008206,11008207,11008208,11008209,11008210,11008211,11008212,11008213,11008214,11008215,11008216,11008217,11008218,11008219,11008220,11008221,11008222,11008223,11008224,11008225,11008226,11008227,11008228,11008229,11008230,11008231,11008232,10619901,10619902,10992552,10992553,10992554,10992572,10992640,10966680,10966681,10966682,10966683,10992816,10992817,10966853,10966854,10617332,10966876,10992917,10927920,10953958,10992958,10992959,10993009,10993104,10928080,10928081,10928082,10928097,10928100,10993129,10993143,10993144,10993145,10993146,10993147,10993148,10993149,10993182,10993183,10993184,10993203,10622773,10622774,10993313,10622776,10622777,10622778,10993327,10993353,10993354,10622891,10615014,10615015,10620070,8570026,10620208,10615270,10615291,10964886,10964887,8570191,10615398,10615417,10615418,10615419,10615420,10615421,8570257,8570265,8570404,10615578,10615579,10926177,10926180,8570500,8570507,10926257,10926258,10926259,10926260,10926261,10926262,10926263,10965369,10991526,10991545,10965556,10616049,10926627,10926628,10926629,10926630,10926631,10952829,10952830,10952831,10922031,10922066,10992121,10992122,10992123,10616596,10922170,10616856,10616887,10992468,10992469,10927441,10992470,10927442,10922455,7059516,9189379,10559200,10559204,10559205,10559206,10559207,10559208,10559209,10559291,10565304,10565305,10611159,10611160,10562334,9173772,9173773,9173774,9173775,9173777,8864316,10559702,10559703,10559704,10559705,10614556,10559706,10559707,10559708,10559709,10559710,10559711,10559712,10559713,10559714,10559715,10559716,10559717,10559718,10559719,10559720,10559721,10559722,10559723,10559724,10559725,10559726,10559727,10559728,10559729,10559730,10559731,10559732,10559733,10559734,10559735,10559736,10559737,10559738,10559739,10559740,10559741,10559742,10559743,10559744,10559745,10559746,10559747,10559748,10559749,10559750,10559751,10559752,10559753,10559754,10559755,8864471,8864529,8864533,8864572,10611714,8864573,8864574,8864600,8864602,8864610,8864611,8864649,8864650,9174131,8864656,8864657,8864687,8864688,8864708,8864716,9174257,7057482,10611989,7057524,7057525,7057527,7057528,7057588,10612087,7057591,9171429,7057651,10612168,10612169,10612265,10612280,10563469,10563470,10563471,10563472,10563473,10563521,10563522,10563523,8862247,9171953,10609772,8862643,9164171,9188193,9188194,9188195,9188196,9188197,9188198,9188199,10612883,7058441,7058442,7058443,7058444,7058479,9172325,9172329,10613034,7058555,7058556,10613085,10613087,7058590,10613088,7058591,10613091,10610098,7058613,10610113,10610114,10610115,7058619,10613119,7058628,8862989,9172469,7058643,7058644,7058645,8863010,8863016,9172495,9172496,9172497,8863023,10610167,10610168,8863030,8863032,8863038,8863039,8863043,8863044,8863048,8863052,8863056,8863060,8863064,8863065,8863068,8863070,8863071,8863072,9164632,10558450,10558451,10561552,8863540,7059292,10613804,10564992,10564993,10610915,10610916,9161485,9161486,9185575,9185579,9185587,9185637,9185650,9185655,10517517,10517518,10515543,9169751,7056039,9185927,10515781,10515782,10515783,7056157,10515907,10515922,10515923,10515924,10515925,10515926,10515927,10515928,10515929,10515930,10515931,10515932,10515933,10515934,10515935,10515936,10515937,10515938,10515939,10515940,10515941,10515942,10515943,10515944,10515945,10515946,10515947,10515948,10515949,9186142,9186162,9186171,9170188,9186199,9186228,9186293,9186294,9186295,10516184,9186375,9186394,4975263,9186476,9186480,9186481,9186587,9186588,9186589,9186623,9186626,10514486,9170817,9171004,7057173,2809651,9171048,10512958,10512959,10512960,10512961,10415255,10419283,10419292,10419297,10416300,10416301,10416304,10416323,10416324,10416329,8918070,9176439,10415388,10417417,10417424,10419428,10419429,10416446,10416447,10416450,10416455,10416461,10416470,10415473,10419501,10417505,10419506,10419511,10419517,10419529,10419530,10419533,10419536,10419537,10417558,7054873,10416657,7054927,9160873,10419799,10419800,4973773,10419851,10415874,9160959,10415888,9160985,10418916,9161023,10417004,4973994,4974005,4974017,4974018,4974043,4974044,4974045,10420125,4974062,4974063,4974064,4974065,4974066,4974067,4974068,10416189,9166301,4971388,9174586,8865131,8865132,10471482,10471483,10471484,10471485,10471486,10471497,6667178,10467766,10467776,8917052,8917058,8917065,8917066,8917067,8917068,8917072,8917078,8917080,8917081,8917082,8917083,8917302,9175702,9175703,9175718,9175734,9175738,9175739,9175741,9175744,9175745,9175748,9175749,9175750,9175751,10468346,8917501,6667902,9167915,8917613,8917621,8917624,8917625,8917636,8917692,8917698,8917752,8917753,8917763,8917764,8917772,9160260,9176264,10628179,10628181,10628292,10159945,10628450,10628649,10628650,10628651,10628653,10628654,10628655,10628656,10628657,10628658,10628659,10628660,10628661,10628662,10628663,10628679,10628682,10628683,10628686,10628687,10628838,10628887,10628888,10628889,10628903,10628926,10629220,10629221,10629222,10629329,10629332,10629335,10160858,10629337,10629338,10629411,10168542,10632069,10632091,10627303,10163986,10163990,10163992,10627910,10630025,10630100,10630150,10630151,10161941,10626440,10626445,10626560,10626561,10626562,10626935,10568305,10568391,10568392,10568393,10568394,10568479,10568480,10568496,10568497,10568498,10568499,10568500,10568501,10579551,10579552,10579553,10579554,10579555,10567597,10579647,10579648,10579649,10579650,10579651,10579652,10579690,10579691,10579692,10579693,10579694,10579695,10579696,10579697,10579698,10579699,10579700,10579703,10579704,10579705,10579706,10579707,10579708,10579709,10579710,10579711,10579712,10579713,10579714,10579715,10579716,10579717,10579718,10579719,10579720,10579721,10579722,10579772,10579773,10579774,10579775,10579776,10579777,10568065,10521192,10527880,10522531,10528564,10528565,10520958,10520959,10520960,10520961,10520962,10520963,10520964,10520965,10422268,10423454,10423455,10423464,10423475,10423483,10423484,10423542,10423543,10423552,10423553,10420700,10420905,10422020,10424064,10422075,10423089,10423094,10477364,10477454,10477455,10477459,10474009,10474011,10476333) 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'