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;">Being a Native Floridan, James was naturally drawn towards the waters. From competitive wakeboarding to offshore fishing and diving, James experience with different vessels with all the time he has spent on the water using different vessels and putting them through their paces he will be sure to find the boat that best fits your needs! James brings a fun, energetic personality to the table that will help your experience be a pleasure!</p> |
[empty string] |
282 |
[empty string] |
[empty string] |
[empty string] |
https://www.unitedyacht.com/United-Yacht-Brokers/James-Loisel/282 |
13 |
jloisel@unitedyacht.com |
0 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
Professional Yacht Broker |
[empty string] |
[empty string] |
[empty string] |
James |
James Loisel |
Loisel, James |
Loisel, James (jloisel@unitedyacht.com) |
Loisel |
2 |
United Yacht Sales Main Office |
2 |
[empty string] |
407-257-6706 |
[empty string] |
[empty string] |
21A2BBAB-C6E6-43FC-0B7C184A7BF61AA6 |
[empty string] |
James Loisel |
|
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 = 282
ORDER BY brokerID |