Can't execute statement:
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 'AND deactivated = 0' at line 16
SELECT cost, event_item_id, event_item_title, address, address2,
city, state, zip, web_site, description, start_time, end_time,
start_date, end_date, deactivated, on_going, pdf_file,
DATE_FORMAT(start_date, '%m/%d/%y') as start_date_m_d_y,
DATE_FORMAT(end_date, '%m/%d/%y') as end_date_m_d_y,
DATE_FORMAT(start_date, '%m/%d') as start_date_m_d,
DATE_FORMAT(end_date, '%m/%d') as end_date_m_d,
weekly_monthly, ongoing_weekly_day_sunday,
ongoing_weekly_day_monday, ongoing_weekly_day_tuesday,
ongoing_weekly_day_wednesday, ongoing_weekly_day_thursday,
ongoing_weekly_day_friday, ongoing_weekly_day_saturday,
event_monthly_occurence_week_number, event_monthly_week_day_name, result, display_cost
FROM event_item
WHERE event_item_id =
AND deactivated = 0
Can't execute statement:
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 'AND ec.event_category_id = eic.event_category_id
AND ec.deactivated = 0' at line 4
SELECT ec.event_category_name, ec.event_category_id
FROM event_category ec, event_item_category eic
WHERE event_item_id =
AND ec.event_category_id = eic.event_category_id
AND ec.deactivated = 0
Can't execute statement:
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 'AND eso.event_sponsor_org_id = eis.event_sponsor_org_id' at line 4
SELECT eso.event_sponsor_name, eso.event_sponsor_org_id
FROM event_sponsor_org eso, event_item_sponsor eis
WHERE eis.event_item_id =
AND eso.event_sponsor_org_id = eis.event_sponsor_org_id
Can't execute statement:
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 'AND esp.event_sponsor_person_id = eisp.event_sponsor_person_id' at line 4
SELECT esp.first_name, esp.last_name, esp.event_sponsor_person_id, esp.phone, esp.event_sponsor_person_email
FROM event_sponsor_person esp, event_item_sponsor_person eisp
WHERE eisp.event_item_id =
AND esp.event_sponsor_person_id = eisp.event_sponsor_person_id
