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(8630794,8630795,8630796,8630833,8574473,8574478,8574480,8574490,8574501,8574502,8583186,3229974,10862928,10862929,10862930,10862931,10862932,10862933,10862934,10862935,10862936,10862937,10862938,10862939,10862940,10862941,10862942,10862943,10862944,10862945,10862946,10862947,10862948,10862949,10862950,10862951,10862952,10862953,10862954,10862955,10862956,10862957,10862958,10862970,10862971,10862972,10862973,10862974,10862975,10862976,10862984,8632355,8632356,10863000,8632359,8632360,8622754,8629791,8629793,8629796,7201645,8595142,10859564,10859565,7202598,7065920,8910580,8910594,10857906,10857908,10857909,10857949,10865972,10857998,8908422,8625135,10863920,10863921,10863922,10863923,8564679,11048452,10865031,10865032,10865034,10865037,10865117,3923606,10618300,10618301,10618304,8554290,7196648,7196649,10623491,10623492,7197089,10854903,8904999,8634694,8634695,8634696,8634697,8634702,8634704,8634705,8634706,8634712,8634713,8634715,8634716,8634798,8634799,8634800,8634801,8634802,8634810,8634811,10852496,10852498,10852501,8905364,10850347,10850348,10850349,10850350,10850351,10850352,10850353,10850354,10615238,10615239,10615240,10615241,10615245,10850643,10850645,10850647,10615868,10851167,8540641,10616232,10616270,10616277,10616653,10616654,10851958,10851960,10851962,10851964,7155289,10616816,10611431,10611670,10611671,10611673,10611678,8851440,8851447,8851686,10609946,8852311,8852320,10613159,8852321,10613308,10613309,10610678,10613744,10610753,10610822,10610826,6673559,10117883,9911947,6674083,6674084,6674085,6674086,6674087,6674088,6674089,6674090,6674091,6674092,6674093,6674094,6674095,6674096,6674097,6674098,6674099,6674100,6674101,6674102,6674103,6674104,9912136,6674148,6674151,8849893,6674322,9912442,9912443,9912451,9912509,8851111,8851112,10418316,10418317,10418319,10418322,6672689,6672691,10418428,6672718,10416498,10416499,10416500,10416501,10416502,10416503,10416504,10416505,10416506,10416507,10416508,10416509,10416510,10416511,10416512,10416513,10416514,10416515,10416516,10416517,10416518,10416519,10416520,10416521,10416533,10416534,10416535,10416536,10416537,10416538,10416539,10416540,10416541,10416550,9168749,6673056,6673057,6673058,6673059,6673060,6673113,9911282,10419141,10471108,8550155,976557,976558,976559,10115990,10115991,10116206,10116212,10889175,10884474,10889546,10889633,10889709,10875230,10880323,10885464,10887662,10882939,10882960,10888024,10888026,10888027,10888028,10888030,10888033,10888036,10888037,10888039,10888041,10888044,10888047,10888048,10888054,10888057,10888062,10888063,10888065,10888068,10888071,10888074,10888075,10888078,10888082,10888088,10888093,10888095,10888100,10888104,10888106,10888156,10888174,10888201,10888208,10888211,10888225,10888227,10888241,10888262,10888265,10888266,10888269,10888283,10888284,10888294,10888295,10883455,10161957,10876481,10876828,10882359,10601970,10601971,10601972,10601973,10601981,10601984,10601986,10601988,10601989,10601991,10601998,10602003,10602004,10602006,10602015,10602021,10602035,10602047,10602048,10602049,10602050,10602051,10602052,10602088,10602093,10602102,10602103,10602104,10602106,10602110,10602114,10602215,10602478,10602483,10602484,10602485,10602492,10602493,10602494,10602496,10602497,10602507,10602511,10602518,10602521,10602528,10602529,10602535,10602540,10602542,10602543,10602545,10602550,10602555,10602556,10602573,10602574,10602593,10602604,10602606,10602610,10602614,10602618,10602624,10602625,10602629,10602630,10602631,10602632,10602636,10602649,10602656,10602658,10602659,10602662,10602663,10602664,10602665,10602666,10602667,10602668,10602669,10602670,10602674,10602675,10602679,10602681,10602713,10602740,10602744,10602745,10604210,10604212,10604214,10601414,10601415,10601417,10601418,10601424,10601425,10601428,10601429,10601432,10601433,10601434,10601435,10601473,10601485,10601486,10601490,10601492,10601496,10601498,10601499,10601501,10601502,10601506,10601507,10601508,10601510,10601511,10601513,10601514,10601516,10601518,10601520,10601522,10601524,10601525,10601526,10601528,10601529,10601532,10601533,10601534,10601539,10601543,10601546,10601555,10601561,10601565,10601572,10601573,10601589,10601600,10601601,10601602,10601605,10601606,10601615,10601616,10601624,10601625,10601650,10601651,10601656,10601660,10601667,10601674,10601675,10601716,10601720,10601727,10601736,10601737,10601740,10601741,10601742,10601750,10601752,10601758,10601761,10601766,10601771,10601778,10601780,10601784,10601785,10601788,10601791,10601792,10601797,10601804,10601806,10601807,10601808,10601810,10601814,10601815,10601816,10601819,10601824,10601825,10601826,10601827,10601830,10601831,10601832,10601834,10601835,10601836,10601839,10601843,10601845,10601862,10601863,10601868,10601869,10601870,10601879,10601892,10601893,10601894,10601898,10601899,10601902,10601903,10601909,10601911,10601917,10601923,10601927,10601929,10601932,10601946,10601948,10508493,10505558,10505560,10505561,10411560,10411561,10407714,10407715,10407716,10407717,10407718,10407719,10407720,10407721,10407915,10407917,10407919,10414001,10414002,10414003,10410163,10408195,10412490,10412492,10412493,10412536,10412584,10408643,10408645,10408647,10408649,10408964,10408966,10408969,10415102) 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'