query
RESULTSET
query
  CONTACTINFO CONTACTTYPE CONTACT_CITY CONTACT_COUNTRY CONTACT_CREATEDBY CONTACT_CREATETS CONTACT_EMAIL CONTACT_GEOCOORDS CONTACT_GEOLAT CONTACT_GEOLNG CONTACT_ID CONTACT_INFO_CO CONTACT_INFO_CZ CONTACT_INFO_DU CONTACT_INFO_EN CONTACT_INFO_ES CONTACT_INFO_FI CONTACT_INFO_FR CONTACT_INFO_GE CONTACT_INFO_NO CONTACT_INFO_PL CONTACT_INFO_RU CONTACT_INFO_SE CONTACT_NAME CONTACT_PHONE CONTACT_PHOTO_FULL CONTACT_PHOTO_THUMB CONTACT_REGIO CONTACT_STATUS CONTACT_STREET CONTACT_STREET_NR CONTACT_UPDATEDBY CONTACT_UPDATETS CONTACT_WEBSITE CONTACT_ZIPCODE LNK_COUNTRY_ID LNK_TYPE_ID SEQ
1 [empty string] Distributors Stuart United States Stijn Bamps 2012-12-19 14:07:00.0 info@belgiumbike.com
binary
-26160011291-60-63-171121684-64-9-108-10019123505964
27.1971905 -80.2568931 1669 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] BelgiumBike LLC +01 (0)772 214 9865 [empty string] [empty string] 0 1 Federal Highway 1098nw Super User 2019-06-25 13:56:00.0 [empty string] 34994 7 2 2
CACHED false
EXECUTIONTIME 47
SQL SELECT C.*, C.contact_info_en as contactinfo, CONTACT.name_en as contacttype, CONTACT.sequence as seq FROM bioracer_contacts C inner join bioracer_contact_types CONTACT on CONTACT.id = C.lnk_type_id inner join bioracer_contact_sports CS on CS.lnk_contact_id = C.contact_id and CS.lnk_sport_id = ? WHERE contact_status = 1 AND lnk_type_id = 2 order by contact_name, contact_country
SQLPARAMETERS
array
1 1

BELGIUMBIKE LLC

Federal Highway 1098nw
34994 Stuart
United States
T - +01 (0)772 214 9865