SELECT `r`.`tip_id`, `r`.`bmi_report_id`, `r`.`group_id`, `r`.`report_date`, `r`.`report_code`, `r`.`report_title`, `r`.`report_custom_title`, `r`.`description`, `r`.`first_paragraph`, `r`.`executive_summary`, `r`.`strategic_insights`, `r`.`segmentation_analysis`, `r`.`drivers_opportunities`, `r`.`size_share_analysis`, `r`.`report_highlights`, `r`.`coverage_deliverables`, `r`.`geographic_insights`, `r`.`report_guidance`, `r`.`news_and_developments`, `r`.`key_sources_referred`, `r`.`no_of_pages`, `r`.`active`, `r`.`single_user_price`, `r`.`site_price`, `r`.`enterprise_price`, `r`.`status`, `r`.`geography_type`, `cat_id`, `c`.`cat_name`, `c`.`custom_name`, `r`.`meta_title`, `r`.`meta_description`, `r`.`meta_keywords`, `r`.`image_path1`, `r`.`rd_images`, `r`.`bmi_me_report`, `r`.`team_name`, `r`.`is_410`
FROM `bmi_reports` AS `r`
JOIN `categories` AS `c` ON `c`.`id`=`r`.`cat_id`
WHERE `r`.`report_custom_title` = 'north-america-border-security-market'