select text,codeid,link from sitelinks where menu = 'y' and LM != 'y' order by text asc select text,codeid,link from sitelinks where menu = 'y' and LM = 'y' order by text asc SELECT codeID, heading, firstpara, piclow, lk_code FROM newsnew WHERE spabus = 'D' ORDER BY codeID DESC SELECT * FROM diarydates WHERE sector LIKE '%SAB%' and active = 'y' ORDER BY code ASC SELECT * FROM diarydates WHERE codeID=#URL.codeID# SELECT * FROM orgphone ORDER BY name ASC SELECT coname, bannerlocation, code, LMdir, dirhead FROM bannerads WHERE LMdir = 'b' and coname not like 'Spa Bus Dir: Raison Detre' ORDER BY RAND() SELECT date, month, year, showname, venue, codeID FROM diarydates WHERE active = 'Y' and sector like '%sab%' ORDER BY code ASC SELECT coname, bannerlocation, code FROM bannerads WHERE LOtrain = 'S' ORDER BY RAND() SELECT codeID, heading, firstpara, piclow, firstpara, storydate, altfirst FROM newsnew WHERE piclow not like 'blanknews.gif' and picno not like 'N' and sectionID not like '%SUP%' and sectionID LIKE "%SAB%" ORDER BY codeID DESC LIMIT 1 SELECT codeID, heading, firstpara, piclow, firstpara, storydate, altfirst FROM newsnew WHERE piclow not like 'blanknews.gif' and picno not like 'N' and sectionID not like '%SUP%' and sectionID LIKE "%SAB%" ORDER BY codeID DESC LIMIT 1,1 SELECT codeID, heading, firstpara, piclow, firstpara, storydate, altfirst FROM newsnew where heading not like '#TopStory.heading#' and heading not like '#fourstory.heading#' and sectionID not like '%SUP%' and piclow like 'blanknews.gif'and sectionID LIKE "%SAB%" ORDER BY codeID DESC LIMIT 1 SELECT codeID, heading, firstpara, piclow, firstpara, storydate, altfirst FROM newsnew where piclow not like 'blanknews.gif' and picno not like 'N' and sectionID not like '%SUP%'and sectionID LIKE "%SAB%" ORDER BY codeID DESC LIMIT 2,1 SELECT codeID, heading, firstpara, piclow, firstpara, storydate, altfirst FROM newsnew where piclow not like 'blanknews.gif' and picno not like 'N' and sectionID not like '%SUP%'and sectionID LIKE "%SAB%" ORDER BY codeID DESC LIMIT 3,1 SELECT codeID, heading, firstpara, piclow, firstpara, storydate, altfirst FROM newsnew where heading not like '#TopStory.heading#' and heading not like '#fourstory.heading#' and sectionID not like '%SUP%' and piclow like 'blanknews.gif' and sectionID LIKE "%SAB%" ORDER BY codeID DESC LIMIT 1,1 SELECT codeID, heading, firstpara, piclow, firstpara, storydate, altfirst FROM newsnew where heading not like '#TopStory.heading#' and heading not like '#fourstory.heading#' and sectionID not like '%SUP%' and piclow like 'blanknews.gif' and sectionID LIKE "%SAB%" ORDER BY codeID DESC LIMIT 2,1 SELECT codeID, heading, firstpara, piclow, firstpara, storydate, altfirst FROM newsnew where piclow not like 'blanknews.gif' and picno not like 'N' and sectionID not like '%SUP%'and sectionID LIKE "%SAB%" ORDER BY codeID DESC LIMIT 4,1 SELECT codeID, heading, firstpara, piclow, firstpara, storydate, altfirst FROM newsnew where piclow not like 'blanknews.gif' and picno not like 'N' and sectionID not like '%SUP%' and sectionID LIKE "%SAB%" ORDER BY codeID DESC LIMIT 5,1 SELECT codeID, heading, firstpara, piclow, firstpara, storydate, altfirst FROM newsnew where heading not like '#TopStory.heading#' and heading not like '#fourstory.heading#' and sectionID not like '%SUP%' and piclow like 'blanknews.gif' and sectionID LIKE "%SAB%" ORDER BY codeID DESC LIMIT 3,1 SELECT * FROM jobssection WHERE jobssection.active = 'Y' ORDER BY sectionorder ASC SELECT coname, bannerlocation, code FROM bannerads WHERE LOjoblink = 'Y' and coname like '%SONA%' limit 1 SELECT coname, bannerlocation, code FROM bannerads WHERE LOjoblink = 'Y' and coname not like '#LOjoblink.coname#' and SOjoblink = 'Y' ORDER BY RAND() SELECT coname, bannerlocation, code FROM bannerads WHERE LOtrain = 'Y' and SOjoblink = 'Y' ORDER BY RAND() SELECT heading,firstpara,storydate,codeID FROM newsnew where sectionID LIKE "%SAB%" AND sectionID not like '%SUP%' and codeID < #fivestory.codeID# and codeID < #sixstory.codeID# ORDER BY codeID DESC LIMIT 5 SELECT heading,firstpara,storydate,codeID FROM newsnew where sectionID LIKE "%SAB%" AND sectionID not like '%SUP%' and codeID < #fivestory.codeID# and codeID < #sixstory.codeID# ORDER BY codeID DESC LIMIT 5,5 SELECT codeID FROM newsnew where sectionID LIKE "%SAB%" AND sectionID not like '%SUP%' and codeID < #fivestory.codeID# and codeID < #sixstory.codeID# ORDER BY codeID DESC LIMIT 9,1 SELECT jobtitle,salary,location,company,codeID FROM jobsnew WHERE LO = 'Y' AND active = 'Y' and section LIKE "%SAB%"ORDER BY codeID DESC TFM_LimitLinksEndCount = 10;TFM_startLink = Max(1,PageNum_J - int(TFM_LimitLinksEndCount/2));TFM_temp = TFM_startLink + TFM_LimitLinksEndCount - 1;TFM_endLink = min(TFM_temp, TotalPages_J);If (TFM_endLink NEQ TFM_temp) { TFM_startLink = max(1,TFM_endLink - TFM_LimitLinksEndCount + 1);}TFM_LimitLinksEndCount = 10;TFM_startLink = Max(1,PageNum_J - int(TFM_LimitLinksEndCount/2));TFM_temp = TFM_startLink + TFM_LimitLinksEndCount - 1;TFM_endLink = min(TFM_temp, TotalPages_J);If (TFM_endLink NEQ TFM_temp) { TFM_startLink = max(1,TFM_endLink - TFM_LimitLinksEndCount + 1);} spa opportunities: spa jobs and spa news for the spa and resorts industry worldwide SELECT * FROM bannerads where lmdir = 'pageflip' and SOPPS = 'y' order by RAND() LIMIT 1
#today# | Daily spa news & jobs
search jobs
search news
call or email
Emma Matthews
now to book your
advertisement
To book a traininglink call or email the
spa opportunities
team now
 

search diary dates


event details

#diary.showname#

#diary.date# #diary.month# #diary.year#
#diary.venue#

#diary.summary#
contact: #diary.contactname#
tel: #diary.tel#
fax: #diary.fax#
email #diary.email#
web: #diary.website#


#t.date# #t.month# #t.year#
#t.showname#
#t.venue#


#DD.date# #DD.month# #DD.year#
#DD.showname#
#DD.venue#
#LKTop.heading#
#LKTop.firstpara# more
To Advertise please call Astrid Ros on +44 (0)1462 471911
 


Published by The Leisure Media Company Ltd Portmill House, Portmill Lane, Hitchin, Herts SG5 1DJ. Tel: +44 (0)1462 431385 | Contact us | About us | © Cybertrek Ltd