DWY Broker - David Walters
Contact Michael

All Brokers

Michael Cummins

Advantage Services.Net, Inc

954 527 0457

"this is a test" -

query
RESULTSET
query
  CALC_LENGTH CHECKBOX01 CHECKBOX02 CHECKBOX03 CHECKBOX04 CHECKBOX05 CHECKBOX06 CHECKBOX07 DATA01 DATA02 DATA03 DATA04 DATA05 DATA06 DATA07 DATA08 DATA09 DATA10 DATA11 DATA12 DATA13 DATA14 DATA15 DATA16 DATA17 DATA18 DATA19 DATA20 DATA21 DATA22 DATA23 DATA24 DATA25 EZSELECTNAME EZSELECTNAME2 HASBROCHURE ISARCHIVED ISFEATURED_CHARTER ISFEATURED_SALE LOCATION1_REF LOCATION2_REF LOCATION3_REF LOCATION4_REF MEMO01 MEMO02 MEMO03 MEMO04 MEMO05 MEMO06 MEMO07 OFFICEREF RANDOMSEED USER2_REF USER3_REF USERREF YACHTID YACHTPRIORITY
CACHED false
EXECUTIONTIME 23
SQL SELECT yacht_data.yachtID, yacht_data.data01 + ' (' + data02 + ' ' + data07 + ')' AS ezSelectName, yacht_data.data12 + ' (' + data02 + ')' AS ezSelectName2, yacht_data.yachtPriority, yacht_data.officeREF, yacht_data.isArchived, yacht_data.userREF, yacht_data.calc_length, yacht_data.hasBrochure, yacht_data.user2_REF, yacht_data.user3_REF, yacht_data.location1_REF, yacht_data.location2_REF, yacht_data.location3_REF, yacht_data.location4_REF, yacht_data.isFeatured_Sale, yacht_data.isFeatured_Charter, yacht_data.data01, yacht_data.data02, yacht_data.data03, yacht_data.data04, yacht_data.data05, yacht_data.data06, yacht_data.data07, yacht_data.data08, yacht_data.data09, yacht_data.data10, yacht_data.data11, yacht_data.data12, yacht_data.data13, yacht_data.data14, yacht_data.data15, yacht_data.data16, yacht_data.data17, yacht_data.data18, yacht_data.data19, yacht_data.data20, yacht_data.data21, yacht_data.data22, yacht_data.data23, yacht_data.data24, yacht_data.data25, yacht_data.memo01, yacht_data.memo02, yacht_data.memo03, yacht_data.memo04, yacht_data.memo05, yacht_data.memo06, yacht_data.memo07, yacht_data.checkbox01, yacht_data.checkbox02, yacht_data.checkbox03, yacht_data.checkbox04, yacht_data.checkbox05, yacht_data.checkbox06, yacht_data.checkbox07, randomSeed FROM yacht_data WHERE staffREF = 1 and ( isArchived = 0 OR isArchived IS NULL) ORDER BY data02 DESC