SELECT 
	* 
FROM
	ministry_directory_listing_categories t1
INNER JOIN
	ministry_directory t2
WHERE
	t2.listing_type = '3'
AND
	t2.name LIKE '%%'
AND
	t2.address_line_1 LIKE '%%'
AND 
	t2.address_line_2 LIKE '%%'
AND
	t2.address_line_1 LIKE '%%'
AND
	t2.address_line_2 LIKE '%%'
AND
	t2.city LIKE '%%'
AND
	t2.province_state_county LIKE '%%'
AND
	t2.country LIKE '%%'
AND
	t2.postal_zip_code LIKE '%%'
AND
	t1.ministry_directory_category_reference = '46'
ORDER BY
	t2.name ASC