TEST!

Database error - /data/webroot/ifsec2009/reg/lin/show_sessions.php
Backend said :ERROR: missing FROM-clause entry for table "vis_reg" LINE 1: ... FROM vis_opt WHERE show_id='IFSC2009' AND vis_id=vis_reg.vi... ^
Your query:
SELECT opt_id, sum(qty) as count FROM vis_opt WHERE show_id='IFSC2009' AND vis_id=vis_reg.vis_id AND vis_reg.show_id='IFSC2009' AND vis_reg.status=' ' GROUP BY opt_id