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
  • images


Information

  • Categories
  • Cities
  • Website
  • Reservations Link
  • Special offer
  • Code

More About