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;">I personally have filled many roles from deckhand to captain as well as a broker to yacht owner. Finally ending up as owner and CEO of Lima Yacht Sales, LLC division of United Yacht Sales. My goal is to assemble the finest, most knowledgeable brokers to assist our respected clients. Please contact myself or any of the Lima Yacht Sales Division brokers for a consultation for a purchase of a new or used vessel. Ask for a free evaluation of your yacht to be put on the market.</p> |
[empty string] |
69 |
3 |
D1CD41078D50C60E2B75446FC904CCC2988FBF84 |
JohnDial |
https://www.unitedyacht.com/United-Yacht-Brokers/John-Dial/69 |
13 |
john-limayachts@unitedyacht.com |
0 |
80471 |
<p class="ql-align-justify">I personally have filled many roles from deckhand to captain as well as a broker to yacht owner. Finally ending up as owner and CEO of Lima Yacht Sales, LLC division of United Yacht Sales. My goal is to assemble the finest, most knowledgeable brokers to assist our respected clients. Please contact myself or any of the Lima Yacht Sales Division brokers for a consultation for a purchase of a new or used vessel. Ask for a free evaluation of your yacht to be put on the market.</p> |
Yacht Broker |
1-561-445-0078 |
https://media.iyba.pro/biopic/4474406faadc255fc5b7b7fc9be80afb.png |
1-772-463-3131 |
Professional Yacht Broker |
2020-05-15 09:41:00.0 |
Developer |
11 |
John |
John Dial |
Dial, John |
Dial, John (john-limayachts@unitedyacht.com) |
Dial |
25 |
United Yacht Sales | Lima Yacht Division |
25 |
[empty string] |
561-445-0078 |
[empty string] |
[empty string] |
F5B49044-0686-2D8F-DDC92E305B6364C6 |
[empty string] |
John Dial |
|
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 = 69
ORDER BY brokerID |