SELECT 
  a.artist_id, 
  a.name, 
  pa.is_remixer 
FROM 
  cscart_label_manager_artists AS a 
  LEFT JOIN cscart_label_manager_product_artists AS pa ON pa.artist_id = a.artist_id 
WHERE 
  pa.product_id = 43813