SET CHARACTER SET UTF8

SET @@session.time_zone='+00:00'

SET @@sql_mode='NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'

SELECT * FROM vwr1_site_master WHERE concat_ws('',site_sub_domain,'.',site_domain) = 'willsellsboji.com'

SELECT * FROM vwr1_site_master WHERE site_domain = 'willsellsboji.com' OR INSTR( 'willsellsboji.com', site_domain ) > 0 ORDER BY site_id

SELECT config_name, config_value FROM vwr1_web_config WHERE config_site_id = 70 AND config_name IN ( 'site_title', 'site_working_city_ids', 'site_working_area_ids','site_working_property_type_ids','site_working_sub_type_ids')

SELECT * FROM vwr1_web_config WHERE config_site_id IN(SELECT site_id from vwr1_site_master WHERE site_type='office') AND config_name NOT IN(SELECT config_name FROM vwr1_web_config WHERE config_value!='' AND config_site_id IN(70,0) AND is_trash='No') AND config_name NOT IN ("listings_seo_configurations_old2", "listings_seo_configurations_old") AND is_trash="No"

SELECT * FROM vwr1_web_config WHERE config_site_id IN(70,0) AND config_name NOT IN ("listings_seo_configurations_old2", "listings_seo_configurations_old") AND is_trash="No"

SELECT *, site_domain as main_domain, Concat( CASE WHEN site_sub_domain<>'' THEN concat_ws('',site_sub_domain,'.',site_domain) WHEN site_sub_domain='' THEN site_domain END ) as site_domain FROM vwr1_site_master WHERE site_id IN ('70')

SELECT * FROM vwr1_theme_config WHERE site_id = 70 AND theme_id = 1

SELECT * FROM vwr1_page_master WHERE 1 AND is_trash='No' AND page_site_id = 70 AND page_visible = 'Yes' AND page_type NOT IN ('HiddenLink','ExternalLink','0') ORDER BY page_order ASC , page_title ASC

SELECT * FROM vwr1_theme_master

SELECT * FROM vwr1_page_master WHERE 1 AND is_trash='No' AND page_site_id = 70 AND page_visible = 'Yes' AND page_type NOT IN ('HiddenLink','ExternalLink','0') ORDER BY page_order ASC , page_title ASC

SELECT * FROM vwr1_page_master WHERE page_position = 'Menu' AND page_visible = 'Yes' AND is_trash ='No' AND page_site_id = '70' AND page_content LIKE '%[[PropertySearchForm id=1 ]]%';

SELECT * FROM vwr1_listing_forms WHERE 1 AND is_trash='No' AND is_admin_form='No' ORDER BY title ASC

SELECT * FROM vwr1_session_master SM LEFT JOIN vwr1_auth_user AU ON SM.session_user_id = AU.id WHERE session_id = 'bacbdb8a3ce121311a00e6ce3c8baaf0'

SELECT * FROM vwr1_listing_fields WHERE listing_field='Yes' AND is_trash='No' ORDER BY display_order ASC

SELECT O.*, O.office_city AS office_city_name,S.state_name AS office_state, S.state_code AS office_state_code FROM vwr1_office_roster_master AS O INNER JOIN vwr1_geo_state AS S ON S.state_code = O.office_state WHERE O.is_trash = 'No'

SELECT * FROM vwr1_agent_roster_master WHERE agent_id IN ('129')

SELECT srole_id, srole_name FROM vwr1_sysuser_role WHERE 1 AND is_trash='No' AND is_active="Yes" ORDER BY srole_name ASC

SELECT * FROM vwr1_geo_state WHERE 1 AND is_trash='No' AND state_visible = "Yes" ORDER BY state_name ASC

SELECT * FROM vwr1_geo_state

SELECT * FROM vwr1_page_master WHERE page_site_id = '70' AND page_content LIKE '%[[AgentProfile]]%'

SELECT * FROM vwr1_agent_roster_master WHERE is_default='Yes' AND is_trash='No'

SELECT DISTINCT * FROM vwr1_listing_meta_general WHERE type = 'status' AND meta_rets != '' AND is_trash='No' AND is_visible = 'Yes' ORDER BY display_order, title

SELECT etmpl_cat_id, etmpl_cat_title FROM vwr1_email_template_categories WHERE 1 AND is_trash='No' ORDER BY etmpl_cat_title ASC

SELECT * FROM vwr1_web_config WHERE config_site_id IN(SELECT site_id from vwr1_site_master WHERE site_type='office') AND config_name NOT IN(SELECT config_name FROM vwr1_web_config WHERE config_value!='' AND config_site_id IN(70) AND is_trash='No') AND config_name NOT IN ("listings_seo_configurations_old2", "listings_seo_configurations_old") AND is_trash="No"

SELECT * FROM vwr1_web_config WHERE config_site_id IN(70) AND config_name NOT IN ("listings_seo_configurations_old2", "listings_seo_configurations_old") AND is_trash="No"

SELECT * FROM vwr1_site_master WHERE site_type = "office"

SELECT *, site_domain as main_domain, Concat( CASE WHEN site_sub_domain<>'' THEN concat_ws('',site_sub_domain,'.',site_domain) WHEN site_sub_domain='' THEN site_domain END ) as site_domain FROM vwr1_site_master WHERE site_id IN ('2')

SELECT * FROM vwr1_theme_config WHERE site_id = 2 AND theme_id = 1

SELECT * FROM vwr1_site_master WHERE site_agent_id = '129'

SELECT *, site_domain as main_domain, Concat( CASE WHEN site_sub_domain<>'' THEN concat_ws('',site_sub_domain,'.',site_domain) WHEN site_sub_domain='' THEN site_domain END ) as site_domain FROM vwr1_site_master WHERE site_id IN ('70')

SELECT MM.mlsp_id, MM.mls_disclaimer_big, MM.mls_disclaimer_short, MM.mls_disclaimer_icon, MM.last_run_datetime FROM vwr1_mls_master AS MM WHERE 1 AND MM.mls_market_active = 'Yes'

SELECT * FROM vwr1_lead_campaign WHERE 1 AND ((ldcampaign_start_date = '0000-00-00' AND ldcampaign_end_date = '0000-00-00') OR ('2025-11-06' BETWEEN ldcampaign_start_date AND ldcampaign_end_date)) AND ldcampaign_active = 'Yes' AND FIND_IN_SET(70,ldcampaign_site_ids) AND FIND_IN_SET('Desktop',ldcampaign_device_types) AND is_trash = 'No'

SELECT * FROM vwr1_agent_roster_master WHERE is_default='Yes' AND is_trash='No'

SELECT * FROM vwr1_office_roster_master WHERE office_active='Yes' AND is_trash='No'

SELECT agent_id FROM vwr1_agent_roster_master AS M WHERE is_default = 'Yes' AND agent_active = 'Yes' AND is_trash ='No' and agent_id='3'

SELECT * FROM vwr1_page_master WHERE page_sef_url = 'mall.php' AND page_visible = 'Yes' AND page_site_id = '70' AND is_trash ='No' 404 Page Not Found

404 Page Not Found


We are sorry, the page you requested cannot be found.