Client List

select clients_id, clients_name, clients_url, clients_blurb, clients_location, client_types_name, industries_name from clients, industries, client_types where clients_industries_id = industries_id and clients_client_types_id = client_types_id and clients_visible = '1' order by industries_name, clients_name