SELECT c.id, c.customer_type, c.company_type, COALESCE(c.company_name, CONCAT(c.first_name, " ", c.last_name)) as display_name, c.email, c.phone, c.billing_city as city, c.status, "" as client_name FROM customers c