Warning: Use of undefined constant ALMOST_PERFECTS_ID - assumed 'ALMOST_PERFECTS_ID' (this will throw an Error in a future version of PHP) in /var/www/clients/client1/web1/web/missegle-2020/class/View/Shop/AlmostPerfects.php on line 25

Warning: Use of undefined constant LAST_CHANCES_ID - assumed 'LAST_CHANCES_ID' (this will throw an Error in a future version of PHP) in /var/www/clients/client1/web1/web/missegle-2020/class/View/Shop/AlmostPerfects.php on line 29

MySQL
Unknown column 'LAST_CHANCES_ID' in 'WHERE'

Query
select * from `article` where id IN (SELECT id_art FROM ligmen WHERE id_men = LAST_CHANCES_ID) ORDER BY note DESC LIMIT 6