Error in the consult.. 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 'AND location.status != "off" AND location.live_status = "live" GROUP BY...' at line 60SELECT DISTINCT location.*, COUNT(DISTINCT connect_territories.id) AS num_territories, GROUP_CONCAT(DISTINCT connect_territories.territory_id) AS territories, GROUP_CONCAT(DISTINCT territory.name) AS territory_names, home_territory.id AS territory_home, home_territory.name AS territory_home_name, home_territory.alias AS territory_home_alias, CASE WHEN COUNT(DISTINCT home_territory_locations_locations.id) > 1 THEN 1 ELSE 0 END AS home_territory_shared, fran_status.type AS status_type, fran_status.name AS status_name, fran_status.id AS status_id, fran_status.menu_id AS status_menu_id, GROUP_CONCAT(DISTINCT statuses.name ORDER BY statuses.sort_order) as statuses_names, GROUP_CONCAT(DISTINCT statuses.alias ORDER BY statuses.sort_order) as statuses, GROUP_CONCAT(DISTINCT statuses.id ORDER BY statuses.sort_order) as statuses_ids, user.avatar AS user_avatar, CONCAT(user.first_name, " ", user.last_name) AS user_name, user.avatar AS user_avatar, user.id AS user_id, GROUP_CONCAT(DISTINCT groups.id ORDER BY groups.sort_order) as group_ids, GROUP_CONCAT(DISTINCT groups.name ORDER BY groups.sort_order) as group_names , multi_organic_var.value AS "fran_multi_organic_phone" FROM oak_franchise_locations AS location LEFT JOIN oak_franchise_location_territories AS connect_home ON (connect_home.location_id = location.id AND connect_home.home = 1) LEFT JOIN oak_franchise_territories AS home_territory ON (home_territory.id = connect_home.territory_id) LEFT JOIN oak_franchise_location_territories AS home_territory_locations ON (home_territory.id = home_territory_locations.territory_id) LEFT JOIN oak_franchise_location_territories AS connect_territories ON (connect_territories.location_id = location.id ) LEFT JOIN oak_franchise_territories AS territory ON (territory.id = connect_territories.territory_id) LEFT JOIN oak_users AS user ON (location.modified_by = user.id) LEFT JOIN oak_franchise_statuses AS fran_status ON (fran_status.alias = SUBSTRING_INDEX(location.status, ",", 1)) LEFT JOIN oak_franchise_statuses as statuses ON FIND_IN_SET(statuses.alias, location.status) LEFT JOIN oak_franchise_group_locations as connect_groups ON connect_groups.location_id = location.id LEFT JOIN oak_franchise_groups as groups ON groups.id = connect_groups.group_id LEFT JOIN oak_client_location_variables AS multi_organic_var ON multi_organic_var.location_id = location.id AND multi_organic_var.variable = "fran_multi_organic_phone" LEFT JOIN oak_franchise_locations AS home_territory_locations_locations ON home_territory_locations_locations.id = home_territory_locations.location_id AND home_territory_locations_locations.live_status = "live" WHERE 1 AND location.id = AND location.status != "off" AND location.live_status = "live" GROUP BY location.id ORDER BY location.name ;