A Database Error Occurred

Error Number: 1064

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 'long-beach' at line 7

SELECT `riptides`.`id`, `riptides`.`date`, `riptides`.`inside_leads`, `riptides`.`outside_leads`, `riptides`.`speed_leads`, `riptides`.`member_firms`, `riptides`.`attendance`, `riptides`.`next_date`, `riptides`.`next_loc`, `riptides`.`next_program`, `riptides`.`next_program2`, `riptides`.`next_program3`, `riptides`.`book_location`, `riptides`.`book_start`, `riptides`.`book_end`, `riptides`.`book_jackpot`, `riptides`.`focus_member`, `riptides`.`focus_text`, `riptides`.`announcements`, `riptides`.`board_meeting`, `riptides`.`meetings`, `riptides`.`graphic`, `riptides`.`publish`, `program2`.`first_name` as program_first_name, `program2`.`last_name` as program_last_name, `program`.`company` as program_company, `book`.`company` as book_company, `book`.`address1` as book_address, `book`.`city` as book_city, `book`.`state` as book_state, `book`.`zip` as book_zip, `book`.`phone1` as book_phone1, `focus`.`first_name` as focus_first_name, `focus`.`last_name` as focus_last_name, `focus`.`company` as focus_company, `focus`.`address1` as focus_address, `focus`.`city` as focus_city, `focus`.`phone1` as focus_phone, `focus`.`email` as focus_email, `focus`.`website` as focus_website, `focus`.`photo` as focus_photo FROM (`riptides`) LEFT JOIN `members` as program ON `program`.`id` = `riptides`.`next_program` LEFT JOIN `members` as program2 ON `program2`.`id` = `riptides`.`next_program2` LEFT JOIN `members` as book ON `book`.`id` = `riptides`.`book_location` LEFT JOIN `members` as focus ON `focus`.`id` = `riptides`.`focus_member` WHERE `riptides`.`id` = cosmetic-dentistry-long-beach