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 = 117 
  AND d.lang_code = 'de' 
  AND s.status = 'A'

Query time 0.00064

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE s const PRIMARY PRIMARY 4 const 1
1 SIMPLE d ref aval_status_id aval_status_id 10 const,const 1 Using index condition

Result

descr
<p style="color: rgb(26, 188, 156);"><span style="color: rgb(26, 188, 156);">Gewöhnlich versandfertig in 1 bis 3 Arbeitstagen nach Geldeingang</span><br /> <span style="color: rgb(255, 0, 0);">Nur noch 3 Stk auf Lager. Größere Menge bitte anfragen.</span></p>