No database selected
SELECT state_name FROM locations WHERE state_prefix LIKE 'wi' ORDER BY state_name
No database selected
SELECT pa_id, pa_name FROM practice_areas
No database selected
SELECT COUNT(*) as ct FROM (client_info LEFT JOIN practice_listings ON ci_id = pl_ci_id) LEFT JOIN placement ON ci_id = p_ci_id WHERE ci_state = 'wi' AND p_county = '' AND p_state = 'wi' AND p_site = 'legalphonebook' AND ci_client_status = 'active' GROUP BY ci_id
Legal Phone Book - SEARCH - Find Lawyers

wi Entertainment Law Lawyers

No database selected
SELECT * FROM (client_info LEFT JOIN practice_listings ON ci_id = pl_ci_id) LEFT JOIN placement ON ci_id = p_ci_id WHERE ci_state = 'wi' AND p_county='' AND p_state='wi' AND p_site='legalphonebook' AND ci_client_status = 'active' GROUP BY ci_id ORDER BY p_placement ASC
No database selected
SELECT * FROM client_info LEFT JOIN practice_listings ON ci_id = pl_ci_id WHERE ci_state = 'wi' AND ci_client_status = 'active' GROUP BY ci_id ORDER BY ci_created ASC LIMIT 0, 6