Warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "AND" at character 2389 in /home/gofindco/public_html/event/website/eventreview.php on line 77
Problem with query SELECT even.code as even_code ,even.name ,even.how_much ,even.description ,even.useful_info ,even.image ,even.attendance ,edat.start_time ,edat.end_time ,edat.start_date as order_date ,TO_CHAR(edat.start_date , 'YYYY-MM-DD') as start_date ,TO_CHAR(edat.end_date , 'YYYY-MM-DD') as end_date ,TO_CHAR(edat.start_date , 'yyyymmdd') as check_date ,to_char(date_trunc('second', current_timestamp + interval '7 hour'), 'yyyymmdd') as creation_date ,to_char(date_trunc('second', current_timestamp + interval '7 hour'), 'DD Month Day') as today_date ,even.currency ,even.free ,even.price_info ,even.booking_company as booking_company ,TRIM(even.contact) as booking_contact ,even.email as booking_email ,even.booking_url as booking_url ,even.booking_fax as booking_fax ,even.booking_cell as booking_cell ,TRIM(even.phone_no) as booking_phone ,even.organizer_company as organizer_company ,even.contact_event as organizer_contact ,even.organizer_email as organizer_email ,even.website_url as organizer_url ,even.fax_no as organizer_fax ,TRIM(even.cell_no) as organizer_cell ,even.organizer_phone as organizer_phone ,vnus.name as vnus_name ,COALESCE(vnus.addr1, even.addr_line1, even.address) as addr_line1 ,COALESCE(vnus.addr2, even.addr_line2) as addr_line2 ,COALESCE(vnus.addr3, even.addr_line3) as addr_line3,COALESCE(vnus.city, even.city) as city ,COALESCE(vnus.postalcode, even.postal_code) as postal_code ,COALESCE(vnus.stateprovince, even.state) as state ,COALESCE(vnus.country, even.country) as country ,COALESCE(vnus.latitude, even.latitude_1||'° '||even.latitude_2||'.'||even.latitude_3) as latitude_1 ,COALESCE(vnus.longitude, even.latitude_1||'° '||even.latitude_2||'.'||even.latitude_3) as longitude_1 FROM events even LEFT OUTER JOIN clients clnt ON (even.clnt_code = clnt.code) LEFT OUTER JOIN venues vnus ON (even.vnus_code = vnus.code) ,event_menus emnu ,event_dates edat ,business_area_types xbat WHERE even.code = emnu.even_code AND edat.even_code = even.code AND even.code = AND even.status = 'A' AND edat.status = 'A' AND emnu.status = 'A' AND even.xbat_code = xbat.code contact support on 0861 GO FIND.
ERROR: syntax error at or near "AND" at character 2389