SELECT 
  d.descr 
FROM 
  cscart_aval_statuses_descr d 
  INNER JOIN cscart_aval_statuses s ON s.aval_status_id = d.aval_status_id 
WHERE 
  s.aval_status_id = 0 
  AND d.lang_code = 'en' 
  AND s.status = 'A'

Query time 0.00024

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE Impossible WHERE noticed after reading const tables