select *,(select count(*) from mc where mc.b_uid=bc.b_uid ) as mc_cnt from bc where 1 and DelFlag='N' and b_lang='en' order by b_no asc
TK TRAVEL
select *,(select count(*) from mc where mc.b_uid=bc.b_uid ) as mc_cnt from bc where 1 and b_uid='125' and DelFlag='N' and b_lang='en' order by b_no asc
  • 1:1 Inquires
  • Group query
  • Reviews
  • Travel Photo
  • Travel Info.
  • Car Rental
  • Disc. Tickets
  • Hotels