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(10950704,8573257,8573258,8573334,10858266,10858267,10858268,10858269,10858270,10858271,10858272,10858273,10858274,10858275,10858276,10858277,10858278,10858279,10858280,10858281,10858282,10858283,10858284,10858285,10858286,10858287,10858288,10858289,10858290,10858291,10858292,10858293,10858294,10858295,10858296,10858297,10858298,10858299,10858300,7201731,7201732,7201733,8910671,10838784,7197987,8905367,8905368,3232906,10615287,8540601,8611338,10616716,10614277,10614278,10611775,10611776,10611777,10611820,10612058,7055496,10117835,10117877,9912191,10118565,7016309,7016310,7016311,7016312,7016313,7016314,7016315,7016316,7016317,7016318,7016319,7016320,7016321,7016322,7016323,7016324,7016325,7016326,7016327,7016328,7016329,7016330,7016331,7016332,7016333,7016334,7016335,7016336,7016337,7016338,7016339,7016340,7016341,7016342,7016343,7016344,7016345,7016346,7016347,7016348,7016349,7016350,7016351,7016352,7016353,7016354,7016355,7016356,7016357,7016358,7016359,7016360,7016361,7016362,7016363,7016364,7016365,7016366,7016367,7016368,7016369,7016370,7016371,7016372,7016373,7016374,7016375,7016376,7016377,7016378,7016379,7016380,7016381,7016382,7016383,7016384,7016385,7016386,7016387,7016388,7016389,7016390,7016391,7016392,7016393,7016394,7016395,7016396,7016397,7016398,7016399,7016400,7016401,7016402,7016403,7016404,7016405,7016406,7016407,7016408,7016409,7016410,7016411,7016412,7016413,7016414,7016415,7016416,7016417,7016418,7016419,7016420,7016421,7016422,7016423,7016424,7016425,7016426,7016427,7016428,7016429,7016430,7016431,7016432,7016433,7016434,7016435,7016436,7016437,7016438,7016439,7016440,7016441,7016442,7016443,7016444,7016445,7016446,7016447,7016448,7016449,7016450,7016451,7016452,7016453,7016454,7016455,7016456,7016457,7016458,7016459,7016460,7016461,7016462,7016463,7016464,7016465,7016466,7016467,7016468,7016469,7016470,7016471,7016472,7016473,7016474,7016475,7016476,7016477,7016478,7016479,7016480,7016481,7016482,7016483,7016484,7016485,7016486,7016487,7016488,7016489,7016490,7016491,7016492,7016493,7016494,7016495,7016496,7016497,7016498,7016499,7016500,7016501,7016502,7016503,7016504,7016505,7016506,7016507,7016508,7016509,7016510,7016511,7016512,7016513,7016514,7016515,7016516,7016517,7016518,7016519,7016520,7016521,7016522,7016523,7016524,7016525,7016526,7016527,7016528,7016529,7016530,7016531,7016532,7016533,7016534,7016535,7016536,7016537,7016538,7016539,7016540,7016541,7016542,7016543,7016544,7016545,7016546,9913100,7016547,7016548,7016549,7016550,7016551,7016552,7016553,7016554,7016555,7016556,7016557,7016558,7016559,7016560,7016561,7016562,7016563,7016564,7016565,7016566,7016567,7016568,7016569,7016570,7016571,7016572,7016573,7016574,7016575,7016576,7016577,7016578,7016579,7016580,7016581,7016582,7016583,7016584,7016585,7016586,7016587,7016588,7016589,7016590,7016591,7016592,7016593,7016594,7016595,7016596,7016597,7016598,7016599,7016600,7016601,7016602,7016603,7016604,7016605,7016606,7016607,7016608,7016609,7016610,7016611,7016612,7016613,7016614,7016615,7016616,7016617,7016618,7016619,7016620,7016621,7016622,7016623,7016624,7016625,7016626,7016627,7016628,7016629,7016630,7016631,7016632,7016633,7016634,7016635,7016636,7016637,7016638,7016639,7016640,7016641,7016642,7016643,7016644,7016645,7016646,7016647,7016648,7016649,7016650,7016651,7016652,7016653,7016654,7016655,7016656,7016657,7016658,7016659,7016660,7016661,7016662,7016663,7016664,7016665,7016666,7016667,7016668,7016669,7016670,7016671,7016672,7016673,7016674,7016675,7016676,7016677,7016678,7016679,7016680,7016681,7016682,7016683,7016684,7016685,7016686,7016687,7016688,7016689,7016690,7016691,7016692,7016693,7016694,7016695,7016696,7016697,7016698,7016699,7016700,7016701,7016702,7016703,7016704,7016705,7016706,7016707,7016708,7016709,7016710,7016711,7016712,7016713,7016714,7016715,7016716,7016717,7016718,7016719,7016720,7016721,7016722,7016723,7016724,7016725,7016726,7016727,7016728,7016729,7016730,7016731,7016732,7016733,7016734,7016735,7016736,7016737,7016738,7016739,7016740,7016741,7016742,7016743,7016744,7016745,7016746,7016747,7016748,7016749,7016750,7016751,7016752,7016753,7016754,7016755,7016756,7016757,7016758,7016759,7016760,7016761,7016762,7016763,7016764,7016765,7016766,7016767,7016768,7016769,7016770,7016771,7016772,7016773,7016774,7016775,7016776,7016777,7016778,7016779,7016780,7016781,7016782,7016783,7016784,7016785,7016786,7016787,7016788,7016789,7016790,7016791,7016792,7016793,7016794,7016795,7016796,7016797,7016798,7016799,7016800,7016801,7016802,7016803,7016804,7016805,7016806,7016807,7016808,7016809,7016810,7016811,7016812,7016813,7016814,7016815,7016816,7016817,7016818,7016819,7016820,7016821,7016822,7016823,7016824,7016825,7016826,7016827,7016828,7016829,7016830,7016831,7016832,7016833,7016834,7016835,7016836,7016837,7016838,7016839,7016840,7016841,7016842,7016843,7016844,7016845,7016846,7016847,7016848,7016849,7016850,7016851,7016852,7016853,7016854,7016855,7016856,7016857,7016858,7016859,7016860,7016861,7016862,7016863,7016864,9168380,8550236,10468438,10628154,10884736,10884737,10884738,10884739,10884740,10884741,10884742,10884743,10162031,10162033,10631403,10631404,10631405,10631406,10631407,10631408,10631409,10631410,10631411,10626473,10887437,10887438,10887439,10887440,10412806,10412807,10412808,10412809,10412810,10412811,10412812,10412813,10412814,10412815,10412816,10412817,10412818,10412819,10412820,10412821,10412822,10412823,10412824,10412825,10412826,10412827,10412828,10412829,10412830,10412831,10412832,10412833,10412834,10412835,10412836,10412837,10412838) 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'