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(3228604,3228955,8569750,7065962,7065963,7065964,7065965,7065966,9216281,9216282,9216321,9216350,8573245,8573246,8573247,8573248,7201162,7201163,7201164,7201165,7201166,7201436,8595082,10973359,10973360,10973361,10859074,9794587,10865522,10865523,10865524,10865525,10865526,10865527,10865528,10865529,10865530,10865531,3927770,7200938,7200939,10856259,10856260,10856261,10856262,10856263,10856264,10856265,10856266,10856267,10856268,10856269,10856270,10856271,10856272,10856273,10856274,10856275,10856276,10856277,10856278,10856279,10856280,10856281,10856282,10856283,10856284,10856285,10856286,10856287,10856288,10856289,10856290,10856291,10856292,10856293,10856294,10856295,10856296,10856297,10856298,10856299,10856300,10856301,10856302,10856303,10856304,10856305,10942029,10942030,10101475,10101476,8860339,8860340,8860341,10856988,10856989,10856990,10856992,10856993,10856994,3923496,8554302,8554331,10854078,10854079,10854080,10854081,10854082,10854083,10854084,10854085,10854086,10854087,10854088,10854089,10854090,10854091,10854092,10854093,10854094,10854095,10854096,10854097,10854098,10854099,7197838,7197839,7197965,8905268,8905269,8905270,8905271,8905272,8905273,8905274,8905275,8905276,8905277,8905278,8905279,8905280,8905281,8905282,8905283,8905284,8905285,8905286,8905287,8905288,10615693,8611324,8611325,7155260,7155261,7155262,7155263,10616894,10427112,10611065,10611066,10611067,10611068,10611069,10611070,10611071,10611072,10611073,10611074,10611075,10611076,10611077,10611078,10611079,10611080,10611081,10611082,10611083,10611084,10611085,10611086,10611087,10611088,10611089,10611090,10611091,10611092,10611093,10611094,10611095,10611096,10611097,10611098,10611099,10611100,10611101,10611102,10611103,10611104,10611105,10611692,10611801,10611802,8862505,8566590,10612821,10612822,10609993,8862940,8852333,8852353,8852354,8852355,9914817,8852554,8852560,8852561,8852568,9173254,10117609,10117697,10117698,10117699,10117700,10117701,10117702,10117703,10117704,10117705,10117706,10117707,10117708,10117709,10117710,10117711,10117712,10117763,10117845,10117874,9912036,9912072,9912073,9912074,9912075,9912076,9912077,9912078,9912079,9912080,9912081,9912082,9912083,9912084,9912085,10118360,8850519,8850520,8850521,8850522,8850523,8850524,8850525,8850526,8850527,8850528,8850529,8850530,8850531,8850532,8850533,8850534,8850535,8850536,8850537,8850538,8850539,8850540,8850541,8850542,8850543,8850544,8850545,8850578,9913026,9913027,6673069,6673070,6673071,10117320,8549989,8549990,8549991,9166881,10468253,10468254,10468255,10468256,976460,976461,10116203,9168129,9168130,9168131,9168132,9168133,9168134,9168135,9168136,9168137,9168138,9168139,9168140,9168141,10427647,10427648,10883977,10884135,10884136,10884137,10884138,10884139,10884140,10884141,10884142,10884143,10884144,10884145,10884146,10884147,10884148,10884149,10884150,10884151,10884152,10884153,10884154,10884155,10884156,10884157,10884158,10884159,10884160,10884161,10884162,10884163,10884164,10161920,10161921,10161922,10161923,10161924,10161925,10161926,10161927,10161928,10162023,10577811,10647389,10532131,10532823,10508590,10508591,10508592,10507736,10507737,10507738,10507739,10507740,10507741,10507742,10507743,10507744,10507745,10507746,10507747,10507748,10507749,10507750,10507751,10507752,10507753,10507803,10506843,10411346,10411347,10411348,10411349,10411350,10411351,10411352,10411353,10411354,10411355,10411356,10411357,10411358,10411359,10411360,10411361,10411362,10411363,10411364,10411365,10411366,10411367,10411368,10411369,10411370,10411371,10411372,10411373,10411374,10411375,10411376,10411377,10411378,10411379,10411380,10411381,10411382,10411383,10411384,10486255,10486256,10486257,10486258,10486259,10486260,10486261,10486262,10486263,10486264,10486265,10486266,10411844,10411845,10411846,10411847,10411848,10411849,10411850,10411851,10409877,10409878,10409879,10409880,10409881,10409882,10409883,10409884,10409885,10409886,10409887,10409888,10409889,10409890,10409891,10409892,10409893,10409894,10409895,10409896,10409897,10409898,10489207,10472530,10472531) 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'