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(8068811,10276109,10276114,8835883,8835886,8559452,10943589,10943664,4970612,4970613,4970614,4970615,4970616,4970617,4970618,4970619,4970620,4970621,4970622,4970623,4970624,4970625,4970626,8836328,10104067,8569541,10944253,10944254,10944255,10944256,10944257,10859617,8560294,8560295,7065821,7202631,7202632,10844210,10844229,7202732,8596270,10497609,8619667,8619673,8619693,8560808,10873151,8629606,8573195,10873358,10873359,8561103,8561104,8561181,10929584,8834831,7066831,7074854,8558443,10275246,7067012,10842460,10842589,7067314,3238324,10842659,7201328,8559100,8618110,7075753,7075756,8615196,7198718,3235910,7198768,8564262,10931517,8556558,8615448,8615449,8556559,3236251,3236263,3236299,7072356,8556937,8556950,3926432,8556998,8564776,8557048,10195882,10195883,10195884,10932101,3926704,8557323,8616333,8565301,8616473,8557637,7065325,3927265,10841791,3927471,7073572,10841871,7065593,10841912,3237654,7065760,10933230,10870611,10870612,3924749,8614240,8555377,4938199,4938200,10839379,10839381,8614466,3235180,3235231,7071353,3925300,10839732,10839733,10839798,8563984,8578659,3922875,8542014,10944498,3232962,3233006,10944599,8553617,7069144,7069154,8553634,10944681,3233130,10257439,10257440,10257441,8578960,10944909,10944941,10944942,3233445,3233447,10941256,8072461,8072462,8554295,3923800,7069911,8613600,8613616,8613642,7070283,8613659,3924220,8613671,3924298,3924395,3234426,8555008,3234511,3234517,3234624,10219918,3924633,3924673,3924691,8555259,3924723,10203125,3230941,8633195,8610408,10848510,10433670,3231629,3231634,8611209,8611267,10217268,8552675,8578256,10282843,10837037,10865631,10927488,10847165,10432019,10432025,10432028,8622298,8622511,10617511,10228671,10425373,10847806,10425434,10929635,8573560,10929714,10929720,8837964,8569982,10929870,10929872,10447497,8570088,10930029,8561811,10930161,10447811,10447812,10447813,10447814,10447815,10447816,10447817,10447818,10447819,10447820,10447821,10447822,10447823,10447824,10447825,10447826,10845704,10447827,10447828,10447830,10447831,10447832,10447833,10447834,10447835,10447836,10447837,10447838,8570411,10447840,10447841,10447842,10447843,10447844,10447845,10447846,10447847,10447848,10447849,10447850,10447851,10447852,10447853,10447854,10447855,10447856,10447857,10447858,10447859,10447860,10447861,10447862,10447863,10447864,10447865,10447866,10447867,10447868,10447869,10447870,10447871,10447872,10447873,10447874,10447875,10447876,10447877,10447878,10447906,10930393,10930398,8574319,10930612,10448126,3228745,8838848,3228850,10930955,3228983,3228984,8839071,3229334,3229368,10431600,3229514,7059498,9205335,9189337,8863910,8863966,9165469,9181530,9197632,10939909,10714251,9205879,9205913,10714440,9916209,8864607,9174145,9214195,8565985,10119702,8862028,9211512,10119715,9211521,9211522,10119721,7057727,8862228,9171709,8862298,8862313,8862387,9179981,10612678,3653286,3653287,9164109,8862724,10612876,9164306,7058541,8566924,9204459,9204463,9164605,9188629,8863153,3653880,8863225,10561571,9164778,8863321,8863358,9204930,8863487,8863492,3654199,3654222,9165021,9181156,9213162,9189192,9911524,9193328,9209446,9193713,10513573,9177796,9177797,4974702,9162010,3286021,3286022,3286042,3286043,4975250,9178407,10118619,7056631,9178482,9178503,9178517,9202539,9202568,9202590,9202616,9202660,3651912,9170842,8552149,8552150,9186875,9179043,9179069,8552383,8861668,9211166,8917981,9192564,10427966,9184702,10116998,10428289,10418861,9160978,9161030,9209091,9193180,9193181,10117416,9161260,9174362,3655700,9166608,9166619,8569129,9166631,8865172,9174731,9166789,9166796,9166797,9166798,10471559,3963313,9207001,9199138,6473495,6473521,6473571,9191291,9207396,9183421,6473756,9167634,9175647,9183705,3656918,9183749,9183758,9183763,9199784,9175854,9175858,6667880,6474186,9199930,6474250,9199977,9183977,975994,9200015,9200035,9200036,9200048,9200053,9200058,6668062,9200077,9200078,9200081,9200082,9184086,9200091,9200092,9200115,9200125,9200132,9200139,9200158,9200178,9200250,10913485,10164614,10174618,10159948,10159950,10159951,10159952,10175159,10874922,10905096,7000981,10907854,10917945,10917946,10917947,10917948,10164071,10154349,10179373,10161565,10161566,10161567,10161568,10161569,10161570,10161571,10161572,10161602,10905811,10905812,10948991,10948992,10948993,10625711,10177257,10187340,10177409,10172436,10881485,10631142,10172798,10162966,10631453,10626550,10882365,10882366,10882367,10877439,10877440,10877441,10877442,10611242,10611245,10574413,10574414,10574415,10608479,10608480,10608481,10652692,10608482,10652693,10608483,10569268,10569269,10590834,10590835,10590836,10653903,10582220,10585341,10543319,10543320,10543321,10545530,10545565,10545566,10520293,10538442,10508340,10508341,10498366,10423879,10424030,10424031,8562201,8562597,8562683,10414053,8563430,8563445) 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'