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(8630629,8630630,8630631,8630632,8630633,8630634,8630635,8630636,8630637,8630638,8630639,8630640,8630641,8630642,8630758,8630759,8630760,8630765,8630766,8630767,8630768,8630769,8630770,8630771,8630772,8630773,8630774,8630775,8630776,8630777,8630778,8630779,8630780,8630781,8630782,8630783,8630784,8630785,8630786,8630787,8630788,8630789,8630790,8630791,8630792,8630793,8630794,8630795,8630796,8630797,8630798,8630799,8630800,8630801,8630802,8630803,8630804,8630805,8630806,8630807,8630808,8630809,8630810,8630811,8630812,8630813,8630814,8630815,8630816,8630817,8630818,8630819,8630820,8630821,8630822,8630823,8630824,8630825,8630826,8630827,8630828,8630829,8630830,8630831,8630832,8630833,8630834,8630835,8630836,8630837,8630838,8630839,8630840,8630841,8630842,8630843,8630844,8630845,8630846,8630847,8630848,8630849,8630850,8630851,8630852,8630853,8630854,8630855,8630856,8630857,8630858,8630859,8630860,8630861,8630862,8630863,8630864,8630865,8630866,8630867,8630868,8630869,8630870,8630871,8630872,8630873,8630874,8630875,8630876,8630877,8630878,8630879,8630880,8630881,8630882,8630883,8630884,8630885,8630886,8630887,8630888,8630889,8630890,8630891,8630892,8630893,8630894,8630895,8630896,8630897,8630898,8630899,8630900,8630901,8630902,8630903,8630904,8630905,8630906,8630907,8630908,8631139,8631140,8569510,8569511,3229008,8631518,8631519,8631800,8631801,8631802,8631803,8631804,8631805,8631806,8631812,8631813,8631814,8631842,8631843,8631844,9216233,9216234,9216235,9216243,9216244,9216245,9216246,9216247,9216251,9216252,9216253,9216278,9216279,9216280,9216281,9216282,9216283,9216284,9216285,9216286,9216287,9216288,9216289,9216290,9216291,9216292,9216293,9216294,9216295,9216296,9216297,9216298,9216299,9216300,9216301,9216302,9216303,9216304,9216305,9216306,9216307,9216308,9216309,9216310,9216311,9216312,9216313,9216314,9216315,9216316,9216317,9216318,9216319,9216320,9216321,9216322,9216323,9216324,9216325,9216326,9216327,9216328,9216329,9216330,9216331,9216332,9216333,9216334,9216335,9216336,9216337,9216338,9216339,9216340,9216341,9216342,9216343,9216344,9216345,9216346,9216347,9216348,9216349,9216350,9216351,9216352,9216353,9216354,9216355,9216356,9216357,9216358,9216359,9216360,9216361,9216362,9216363,9216364,9216365,9216366,9216367,9216368,9216369,9216370,9216371,9216372,9216373,9216374,9216375,9216376,9216377,9216378,9216379,9216380,9216381,9216382,9216383,9216384,9216385,9216386,9216387,9216388,9216389,9216390,9216391,9216392,9216393,9216394,9216395,9216396,9216397,9216398,9216399,9216400,9216401,9216402,9216403,9216404,9216405,9216406,9216407,9216408,9216409,9216410,9216411,9216412,9216413,9216414,9216415,9216416,9216417,9216418,9216419,9216420,9216421,9216422,9216423,9216424,9216425,9216426,9216427,9216428,9216429,9216430,9216431,9216432,9216433,9216434,9216435,9216436,9216437,9216438,9216439,9216440,9216441,9216442,9216443,9216444,9216445,9216446,9216447,9216448,9216449,9216450,9216451,9216452,9216453,9216454,9216455,9216456,9216457,9216458,9216459,9216460,9216461,9216462,9216463,9216464,9216465,9216466,9216467,9216468,9216469,9216470,9216471,9216472,9216473,9216474,9216475,9216476,9216477,9216570,9216571,10844749,8629690,8629691,8629692,8629693,8629811,8629812,3228001,3228002,10447616,10447617,9214448,10962506,7067931,7072148,7072149,7072150,7072151,7072152,10842926,10842927,10103307,8559177,8628031,8628032,8628033,7201736,7201738,7201739,7201740,7201756,7201758,8628250,8628258,7201862,10960305,8628334,7201959,7201961,7201974,7201975,3899420,8628726,8628727,7073170,8628836,8628837,8628838,8628839,8628840,8628841,8628842,8628843,8628844,10844055,10844056,10844068,9794592,8629501,8629534,7200582,7200583,7200584,7200585,3927868,7200787,8558636,8558637,8558645,8558654,10839695,8624687,10839953,8625172,8625173,8625174,8625175,8625176,8625196,8625364,8625366,8625371,10100878,8625419,8625420,8625421,3926383,3926384,10101335,3926660,3926661,7070473,8612813,3233760,3234356,3234357,3234358,3234359,3234360,3234361,3234362,3234363,3234364,3234365,3234366,3234367,3234368,3234369,3234370,3234371,3234372,3234373,8624261,8624262,8624379,8624460,8624461,8624462,8624463,8624464,8624465,8624466,8624467,8624468,8624469,8624470,8634673,8634674,8634675,8634676,8634677,8634678,8634679,8634680,8634681,8634682,8634684,8632625,8632627,8632632,8632642,8632643,10615329,10615330,8570517,10615598,10611025,10121826,10611808,9196253,10613017,10613475,9173272,9173273,10517801,10517802,10517803,10517804,10517805,10517806,10517807,10517808,10516193,9176448,9192486,9192497,8569150,8569201,9190704,8917030,9191524,8551241,10627405,10627406,10627407,10908034,10908035,10908036,10908037,10580128,10580129,10604984,10604985,10604986,10604987,10604988,10604989,10606260,10606880,10606922,10528213,10544343,10508332,10508333,10487262,10487263,10487264,10487265,10487266,10487267,10487268,10487269,10487270,10487271,10487272,10487273,10487274,10487275,10487276,10487277,10487278,10487279,10487280,10487281,10487282,10487283,10487284,10487285,10487286,10487287,10487288,10487289,10487290,10487291,10487292,10487293,10487294,10487295,10487296,10487297,10487298,10487299,10487300,10487301,10487302,10487303,10487304,10487305,10487306,10487307,10487308,10487309,10487310,10487311,10487312,10487313,10487314,10487315,10487316,10487317,10487318,10487319,10487320,10487321,10487322,10487323,10487324,10487325,10487326,10487327,10487328,10487329,10487330,10487331) 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'