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(8068815,8068818,8068819,8068820,8068847,10939584,10939586,10939605,10939606,10939713,10939714,10939715,10939716,10943519,10943520,10943521,10943522,10943523,10943524,10943525,10943526,10943527,10943528,10943529,10943530,10943531,10939810,10939875,7068228,7068247,7068248,7068255,7068256,7068283,7068288,7068289,7068295,4970646,4970647,4970648,4970659,4970660,7068333,10940152,10940162,10940167,10940169,10940186,10940192,10940196,10944011,10944012,10944013,7068612,7068613,7068614,7068615,10940331,7068616,10940332,7068617,7068618,10940333,10940334,7068619,10940335,7068620,7068621,10940336,10940337,7068622,7068623,10940338,10940339,7068624,10940340,7068625,7068626,10940341,7068627,7068628,7068629,7068630,7068631,7068632,7068633,7068634,7068635,7068636,7068637,7068638,7068639,7068640,7068641,7068642,7068643,7068644,7068645,7068646,7068647,7068648,7068649,7068650,7068651,7068652,7068653,7068654,7068655,7068656,7068657,7068658,7068659,7068660,7068661,7068662,7068663,7068664,7068665,7068666,7068667,7068668,7068669,7068670,7068671,7068672,7068673,7068674,7068675,10940425,10940426,10940427,4971077,4971078,4971079,4971080,4971084,10940525,10940526,7065858,7065859,7065893,8067162,8067163,8067164,8067165,8067166,8067167,8067168,7066168,7066365,7066369,7066376,7066384,7066391,7066435,7066436,7066437,10437397,7066467,10437558,8067739,8067786,7066784,7066822,4969178,4969179,10938587,10938588,10938589,10938590,10938591,10938592,10938593,10938594,10938595,10938596,10938597,10938598,10938599,10938600,10938601,10938602,10938603,10938604,10938605,10938606,10938607,10938608,7067182,4969548,7067233,7067234,7067235,7067236,7067241,10939174,10939175,10939176,8068612,8068613,8068614,8068615,7067639,7067640,7067641,8068659,8068660,7067678,8068661,8068662,8068663,8068664,8068665,8068666,8068722,8068723,8068724,10931582,10931640,7064214,7064215,7064216,7064217,7064218,7064219,7064220,7064221,7064222,7064223,7064224,7064225,7064226,7064227,7064228,7064229,7064230,7064231,7064232,7064233,7064234,7064235,7064236,7064237,7064238,7064239,7064240,7064401,10931896,10931897,7064490,7064491,7064531,10932186,10932221,8065964,8066073,8066078,10932472,8066166,4967442,4967443,4967444,4967445,4967446,4967447,4967448,4967449,4967450,4967451,4967452,4967453,4967454,4967455,4967456,4967457,4967458,4967459,4967460,8066197,10932711,10932785,10932786,10932809,10932931,10932946,10932950,8066589,8066590,8066591,8066592,8066593,8066594,8066595,10932966,8066596,10932967,8066597,10932968,8066598,8066599,8066600,8066601,8066602,8066603,8066604,8066605,8066606,8066692,8066693,8066694,8066695,8066696,8066697,8066698,8066699,8066700,8066701,8066702,8066703,8066704,8066705,8066706,8066707,8066708,8066709,8066710,8066711,8066712,10942750,8860979,10942795,8861032,8861072,8861073,8861074,8064251,8064252,8064253,8064254,8064255,8064256,8064257,8064258,8064259,8064260,8064261,8064262,8064263,8064264,8064265,8064266,8064267,8064268,8064269,8064270,8064271,8064272,8064273,8064274,8064275,8064276,8064277,8064278,8064279,8064280,8064281,8064282,8064283,8064284,8064285,8064286,8064287,8064288,8064289,8064290,8064291,8064292,8861190,10943105,10943106,10943107,10943108,8861347,10943198,10943255,8861470,8861498,8861499,8064674,8064675,5999932,10943424,3655535,3655536,3655548,10944384,10940685,10940686,10940687,10940772,10941117,3656197,8859514,8859515,8859516,8859517,8859518,8859519,8859520,8859521,8859522,8859523,8072560,8072561,8072588,8072589,3656633,3656675,10941835,10941836,3656843,10941931,3656920,3656921,3657001,3657002,8860336,8860400,10942320,10942321,10942322,10942323,8969925,10942324,8969926,8969927,8860529,10942410,10923538,10923539,10923540,10928641,10928642,10623345,10623439,10920280,10920281,10920282,10927472,10927473,10927474,10927475,10927476,10927477,10927478,10922485,10922486,10922488,10922489,10927556,10927557,10927558,10927581,10927614,10927632,10927633,10622123,10927637,10927641,10927644,10927645,10927658,10927674,10927680,10927698,10927761,10927762,10927763,10927767,10927773,10927774,10927777,10927778,10622273,10917800,10917801,10917802,10917803,10917804,10927840,10927920,10927921,10622427,10922938,10622429,10622447,10622448,10622449,10927968,10927969,10927970,10927971,10927972,10927973,10927974,10927975,10927976,10927977,10918070,10918071,10928337,10928338,10622871,10620005,10620238,10926036,10926098,10926099,10926100,10926111,10926161,10926162,10926168,10916335,10916336,10916337,10926411,10926439,10926442,10926443,10926444,10926476,10926535,10926536,10926537,10926550,10926551,10921556,10921557,10921558,10921559,10926565,10926598,10926605,10921607,10921608,10921612,10921613,10921619,10926656,10926657,10926658,10926659,10621163,10621444,10921956,10921957,10921958,10921959,10921960,10621459,10621460,10621461,10621462,10621463,10927072,10927073,10927074,10927075,10927076,10927110,10927111,10621620,10621640,10621641,10621642,10922153,10922154,10621697,10922225,10922226,10922230,10922231,10922232,10621728,10922270,10922271,10917282,10922329,10922330,10922331,10922332,10922333,10927358,10927361,10927465,10927466,10927467,10927468,10922468,10927469,10927470,10927471,10610992,10565187,10565188,10565190,10565191,10565194,10565197,10565198,10565199,10565200,10565201,10565202,10565203,10565204,10565205,10565206,10565207,10565208,10565209,10565210,10565211,10565212,10565213,10565214,10565215,10565216,10565217,10565218,10565219,10565220,10565221,10565222,10565223,10565224,10565225,10565226,10565227,10565228,10614078,10565229,10614079,10565230,10565231,10565232,10565233,10565234,10565235,10565236,10565237,10565238,10565239,10565240,10565241,10565242,10565243,10565244,10565245,10565246,10565247,10565248,10565249,10565250,10565251,10565252,10565253,10565254,10565255,10565256,10565257,10565258,10565259,10565334,10559467,10611445,10614493,10565673,10614567,10614568,10614787,10614788,10611857,10614857,10566009,10566024,10566025,10566026,10566027,10566028,10566029,10566030,10566031,10566032,10566033,10566034,10566035,10566036,10566037,10566038,10566043,10611912,10611919,10611929,10611959,10611985,10612050,10612107,10609369,10563590,10563591,10563592,10563593,10563594,10563595,10563596,10563597,10563598,10563599,10563600,10563601,10563602,10557614,10557615,10557616,10612490,10612491,10612492,10612499,10612501,10612505,10563657,10563658,10563659,10563660,10563661,10563662,10563663,10563664,10563665,10563666,10612516,10609556,10612578,10612601,10612666,10612667,10612668,10612679,10612680,10612699,10612704,10609749,10612753,10612754,10612755,10612771,10612781,10612803,10557970,10612824,10557980,10557981,10557982,10557983,10557984,10557985,10557986,10557987,10557988,10557989,10557990,10557991,10557992,10612842,10557993,10557994,10557995,10557996,10557997,10557998,10557999,10558000,10558001,10558002,10558003,10558004,10558005,10558006,10558007,10558008,10558009,10558010,10558011,10558012,10558013,10558014,10612864,10558015,10558016,10558017,10558018,10558019,10612869,10558020,10558021,10558022,10558023,10558024,10558025,10558026,10558027,10558028,10558029,10558030,10558031,10558032,10558033,10558034,10558035,10558036,10558037,10558038,10558039,10558040,10558041,10558042,10558043,10558044,10558045,10558046,10612939,10609976,10609981,10609998,10610027,10610028,10610029,10613057,10613096,10613145,10610172,10610173,10610193,10613259,10610269,10610279,10610314,10558478,10613350,10613369,10610414,10613475,10610477,10558819,10558820,10558821,10610902,10513118,10513119,10513120,10513121,10513122,10513123,10513124,10513125,10513126,10513127,10513128,10513129,10513130,10513131,10513132,10513133,10513220,10513221,10513222,10513223,10513224,10513225,10513226,10513261,10513262,10513263,10513264,10513265,10513266,10513267,10513268,10513269,10513292,10513309,10513311,10513312,10513313,10517320,10517546,10517620,10517621,10511651,10511747,10517749,10517750,10517751,10517752,10512018,10512019,10512141,10512221,10512347,10512348,10512349,10512350,10512351,10512352,10512353,10512354,10512355,10512356,10512357,10512358,10518453,10518454,10512495,10512496,10512497,10512498,10513083,10416262,10416274,10416275,10416337,10416341,10419392,10416411,10415467,10415468,10416494,10416545,10415683,10415684,10415821,10415826,10415834,10415885,10415886,10419941,10415951,10415963,10415964,10419968,10419973,10415979,10416986,10416987,10415995,10417016,10420164,10420165,10420182,10417186,10420190,10417194,10420195,10420196,10420200,10417202,10420208,10420212,10462919,10462920,10462921,10462922,10462923,10462924,10462925,10462926,10462927,10462928,10462929,10462930,10462931,10462932,10462933,10462934,10462935,10462936,10462937,10462938,10462939,10462940,10463399,10471497,10470065,10470070,10462451,10470535,10470649,10464807) 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'