NOYC Links & Resources

New Orleans Sailing Clubs

SELECT * FROM links1 where category = 'Local' and id <> 23 and id <> 22 and ID <> 8 and ID <> 25 and ID <> 27 and ID <> 28 and ID <> 29 and ID <> 97 and ID <> 139 and ID <> 144 order by title;

#title#

#data1#

60 Second Interviews

SELECT * FROM links1 where keywords like '%60%' or category like '%60%' or link like '%60%' or title like '%60%' or data1 like '%60%' or data2 like '%60%' or data3 like '%60%' order by title;

#title#

#data1#

Governing Bodies:

SELECT * FROM links1 where category = 'Govering Bodies' and ID <> 143;

#title#

#data1#

Publications

SELECT * FROM links1 where category = 'Publications' and ID <> 68;

#title#

#data1#

Regattas:

SELECT * FROM links1 where category = 'Regattas' and ID <> 44 and ID <> 16 and ID <> 46 and ID <> 141 and ID <> 142;

#title#

#data1#

General Sailing:

SELECT * FROM links1 where category = 'General Sailing' and ID <> 20 and ID <> 19 and ID <> 21 and ID <> 98 and ID <>73 and ID <> 63 and ID <> 95 and ID <> 93 and ID <> 139 and ID <> 137 and ID <> 140 order by title;

#title#

#data1#

P.H.R.F. Ratings

SELECT * FROM links1 where category = 'PHRF';

#title#

#data1#

America's Cup:

SELECT * FROM links1 where category = 'AC' and id <> 100 and ID <> 101 and ID <> 138;

#title#

#data1#

One-Design:

SELECT * FROM links1 where category = 'One Design' and ID <> 18 and ID <> 34 and id <> 39 order by title;