Database error: Invalid SQL: SELECT COUNT(*) AS cnt FROM vwr1_listing_master as LM WHERE 1  AND  LM.is_mark_for_deletion = 'N' AND  LM.is_display_listing = 'Y' AND   LM.street IN('Brown's Bay') AND   LM.city IN('West Okoboji') AND   LM.state IN('IA') AND   LM.category IN('Sale') AND  LM.list_price_current >= 10000 AND (status IN('Active','New') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS'  UNION ALL SELECT COUNT(*) AS cnt FROM vwr1_listing_master_inactive as LM WHERE 1  AND  LM.is_mark_for_deletion = 'N' AND  LM.is_display_listing = 'Y' AND   LM.street IN('Brown's Bay') AND   LM.city IN('West Okoboji') AND   LM.state IN('IA') AND   LM.category IN('Sale') AND  LM.list_price_current >= 10000 AND (status IN('Active','New') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' 

MySQL Error: 1064 (You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 's Bay') AND   LM.city IN('West Okoboji') AND   LM.state IN('IA') AND   LM.cat...' at line 1)