SELECT ``
, (SELECT `option_value` FROM `rXL_wlm_user_options` `T1` WHERE `T1`.`option_name` = 'custom_business' AND `T1`.`user_id` = `WUO`.`user_id` LIMIT 1) AS `Businename`
, (SELECT option_value FROM `rXL_wlm_user_options` `T1` WHERE `T1`.`option_name` = 'custom_address' AND `T1`.`user_id` = `WUO`.`user_id` LIMIT 1) AS `Address`
, (SELECT `option_value` FROM `rXL_wlm_user_options` `T1` WHERE `T1`.`option_name` = 'custom_phone_no' AND `T1`.`user_id` = `WUO`.`user_id` LIMIT 1) AS `PhoneNo`
,(SELECT `option_value` FROM `rXL_wlm_user_options` `T1` WHERE `T1`.`option_name` = 'wlm_origemail' AND `T1`.`user_id` = `WUO`.`user_id` LIMIT 1) AS `email`
,(SELECT `option_value` FROM `rXL_wlm_user_options` `T1` WHERE `T1`.`option_name` = 'custom_website' AND `T1`.`user_id` = `WUO`.`user_id` LIMIT 1) AS `Website`
,(SELECT `option_value` FROM `rXL_wlm_user_options` `T1` WHERE `T1`.`option_name` = 'custom_googlemap' AND `T1`.`user_id` = `WUO`.`user_id` LIMIT 1) AS `map`
, (SELECT `meta_value` FROM `rXL_usermeta` `T1` WHERE `T1`.`meta_key` = 'description' AND `T1`.`user_id` = `WUO`.`user_id` LIMIT 1) AS `Description`
, (SELECT guid FROM `rXL_posts` `T1` WHERE `T1`.`ID` IN (SELECT `UM`.`meta_value` FROM `rXL_usermeta` `UM` WHERE `meta_key` = 'image' AND `UM`.`user_id` = `WUO`.`user_id`) LIMIT 1) AS `guid`
,(SELECT `option_value` FROM `rXL_wlm_user_options` `T1` WHERE `T1`.`option_name` = 'custom_offer' AND `T1`.`user_id` = `WUO`.`user_id` LIMIT 1) AS `Offer`
,(SELECT `option_value` FROM `rXL_wlm_user_options` `T1` WHERE `T1`.`option_name` = 'custom_discount' AND `T1`.`user_id` = `WUO`.`user_id` LIMIT 1) AS `Discount`
,(SELECT `option_value` FROM `rXL_wlm_user_options` `T1` WHERE `T1`.`option_name` = 'custom_landing_page' AND `T1`.`user_id` = `WUO`.`user_id` LIMIT 1) AS `Reservations`
FROM `rXL_wlm_user_options` `WUO` WHERE `custom_address` ='' LIMIT 1
