QUERY error
SELECT staff.*,
staff.kana as staff_kana,
club.time_div_flg,
staff.time_div_flg as staff_time_div_flg,
club.sp_url_1,
club.club_cd,
club.club_name,
club.mail_addr as club_mail_addr,
club_group.club_group_name,
staff.sp_url_1 as staff_sp_url_1,
staff.sp_url_2 as staff_sp_url_2,
staff.sp_url_3 as staff_sp_url_3,
/*
club.title as club_title,
club.keywords as club_keywords,
club.description as club_description,
*/
staff.url_comment_1 as staff_url_comment_1,
staff.url_comment_2 as staff_url_comment_2,
staff.url_comment_3 as staff_url_comment_3
FROM staff left join club on staff.club_cd = club.club_cd left join club_group on club.club_group_cd = club_group.club_group_cd where staff.staff_cd = AND (
staff.act_flg=1
AND (
NOW()
BETWEEN staff.start_time
AND staff.end_time
)
AND staff.del_flg <> 1
) AND (
club.act_flg=1
AND (
NOW()
BETWEEN club.start_time
AND club.end_time
)
AND club.del_flg <> 1
)
You have an error in your SQL syntax near 'AND (
staff.act_flg=1
AND (
NOW()
BETWEEN staff.start_time
AND ' at line 22