select tax from options WHERE id=1
SELECT `products`.`site_id`, `products`.`code`, `products`.`english_title`, `products`.`playtime`, `products`.`playtime_plus`, `prices`.`price`, `prices`.`t_normal_price`, `prices`.`t_normal_point`, `prices`.`t_campaign_price`, `prices`.`t_campaign_point`, `prices`.`dl_normal_price`, `prices`.`dl_normal_point`, `prices`.`dl_campaign_price`, `prices`.`dl_campaign_point`, `prices`.`old_normal_price`, `prices`.`old_normal_point`, `prices`.`test_normal_price`, `prices`.`test_normal_point`, `products`.`english_story`, `supervisors`.`id`, `supervisors`.`english_name`, `products`.`english_supervisor_comment`, `products`.`english_staff_comment`, `products`.`img_url`, `products`.`sample_movie_url1`, `products`.`sample_movie_url2`, `products`.`toaster_sale_flg`, `products`.`monthly_sale_flg`, `products`.`publish_flag`, `products`.`img_update_time`, `products`.`release_date`, `products`.`dl_release_date`, `products`.`toaster_campaign_start`, `products`.`toaster_campaign_end`, `products`.`english_note` FROM `products` LEFT JOIN `supervisors` ON `products`.`supervisor_id`=`supervisors`.`id`,`prices`,`sites_products` WHERE `products`.`price_id`=`prices`.`id` AND `products`.`id` = "387" AND `sites_products`.`product_id`=`products`.`id` AND (`products`.`publish_flag`=1 OR `products`.`publish_flag`=4) AND `sites_products`.`site_id`=2