SearchQuery

searchQuery.sql

SELECT
    a.accountId, 
    a.name AS accountName, 
    b.name AS businessName, 
    b.businessId, 
    n.employee_id AS teamUserId 
FROM 
    Account AS a
    JOIN Business AS b ON a.accountId = b.accountId AND b.deleted = 0
    JOIN user_notes AS n ON n.user_id = a.accountId AND n.deleted = 0 
WHERE 
    (b.name LIKE '%business%name%') OR 
    (a.name LIKE '%business%name%') 
ORDER BY 
    b.name ASC 
LIMIT 100