Allied Member Directory Search

Search our full Allied member directory by company/firm, city, keyword, or level in the fields below:

Database Error; SQL: SELECT DISTINCT `t`.* FROM `wordpress_pods_allieds` AS `t` WHERE ( t.expired = 0 and t.level != 'N/A' AND like '%3%' ) ORDER BY CASE t.level WHEN 'Gold' THEN 1 WHEN 'Silver' THEN 2 WHEN 'Blue' THEN 3 WHEN 'Basic' THEN 4 else 5 END ASC, `t`.`name`, `t`.`id` LIMIT 50, 25; Response: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'like '%3%' ) ORDER BY CASE t.l' at line 7