RESULTSET |
query |
|
BROKERBIO |
BROKERDIRECT800 |
BROKERID |
BROKERLEVELREF |
BROKERPASSHASH |
BROKERPASSWORD |
BROKERSEOURL |
BROKER_LOCATIONS |
EMAIL |
HIDEBROKER |
IYBABROKERID |
IYBA_BIOGRAPHY |
IYBA_BROKERTITLE |
IYBA_CELL |
IYBA_DISPLAYPICTURE |
IYBA_PHONE |
JOBTITLE |
LASTLOGGEDON |
LEVELNAME |
LEVELVALUE |
NAME_FIRST |
NAME_FULL1 |
NAME_FULL2 |
NAME_FULL3 |
NAME_LAST |
OFFICEID |
OFFICENAME |
OFFICEREF |
PHONENUMBER |
PHONE_MOBILE |
PHONE_WORK |
PRIORITY |
RANDOMSEED |
SPOTLIGHTVIDEO |
YW_MATCHNAME |
1 |
<p style="text-align: justify;">Ryan Bouse was born and raised here in Stuart, Florida. He is a second generation Floridian. Growing up in Stuart, Ryan has spent most of his life on the water. Ryan has been in the marine industry for 14+ years. Fishing many tournaments and selling tackle from the local tackle shops. Ryan also works as a firefighter/ paramedic for the local fire department. He enjoys spending time with his family in the Bahamas. He has fished and traveled on many different styles of boats. Ryan is here to help you find the right boat for you.</p> |
[empty string] |
123 |
3 |
[empty string] |
[empty string] |
https://www.unitedyacht.com/United-Yacht-Brokers/Ryan-Bouse/123 |
13 |
rbouse@unitedyacht.com |
0 |
80494 |
<p class="ql-align-justify">Ryan Bouse was born and raised here in Stuart, Florida. He is a second generation Floridian. Growing up in Stuart, Ryan has spent most of his life on the water. Ryan has been in the marine industry for 14+ years. Fishing many tournaments and selling tackle from the local tackle shops. Ryan also works as a firefighter/ paramedic for the local fire department. He enjoys spending time with his family in the Bahamas. He has fished and traveled on many different styles of boats. Ryan is here to help you find the right boat for you.</p> |
Yacht Broker |
1-772-408-3868 |
https://media.iyba.pro/biopic/70957859ffabbdee0174fa9d2cdfdbe7.png |
1-772-463-3131 |
Professional Yacht Broker |
[empty string] |
Developer |
11 |
Ryan |
Ryan Bouse |
Bouse, Ryan |
Bouse, Ryan (rbouse@unitedyacht.com) |
Bouse |
2 |
United Yacht Sales Main Office |
2 |
[empty string] |
772-408-3868 |
[empty string] |
[empty string] |
E4D854C2-065F-FC00-B7B4BD60CCE42556 |
[empty string] |
Ryan Bouse |
|
SQL |
SELECT
brokers.brokerID,
brokers.officeREF,
brokers.hideBroker,
brokers.priority,
brokers.name_last,
brokers.name_first,
brokers.name_first + ' ' + brokers.name_last AS name_full1,
brokers.name_last + ', ' + brokers.name_first AS name_full2,
brokers.name_last + ', ' + brokers.name_first + ' (' + brokers.email + ')' AS name_full3,
brokers.jobTitle,
brokers.phone_work,
brokers.phone_mobile,
brokers.email,
brokers.brokerPassword,
brokers.brokerPassHash,
brokers.phoneNumber,
brokers.brokerBio,
brokers.brokerSEOURL,
brokers.brokerDirect800,
brokers.spotlightVideo,
brokers.randomSeed,
brokers.broker_locations,
brokers.brokerLevelREF,
brokers.lastLoggedOn,
brokers.yw_matchname,
brokers.iybaBrokerID,
brokers.iyba_Biography,
brokers.iyba_BrokerTitle,
brokers.iyba_Cell,
brokers.iyba_DisplayPicture,
brokers.iyba_Phone,
broker_level.levelValue,
broker_level.levelName,
userOffices.officeID,
userOffices.officeName
FROM
brokers
LEFT JOIN broker_level ON brokers.brokerLevelREF = broker_level.levelID
LEFT JOIN userOffices ON brokers.officeREF = userOffices.officeID
WHERE brokerID = 123
ORDER BY brokerID |