SELECT fulldate, showname, venue,city,country, codeID FROM diarydates WHERE active = 'Y' AND sector LIKE '%sab%' ORDER BY startcode ASC,endcode asc limit 5 SELECT piclow,codeID,lk_code,heading,firstpara FROM newsnew WHERE lkweb = 'A' ORDER BY codeID DESC LIMIT 2 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, 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%" and sectionID LIKE "%PRO%" ORDER BY codeID DESC LIMIT 5,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%" and sectionID LIKE "%PRO%" ORDER BY codeID DESC LIMIT 6,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%" and sectionID LIKE "%PRO%" ORDER BY codeID DESC LIMIT 5,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%" and sectionID LIKE "%PRO%" ORDER BY codeID DESC LIMIT 7,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%" and sectionID LIKE "%PRO%" ORDER BY codeID DESC LIMIT 8,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%" and sectionID LIKE "%PRO%" ORDER BY codeID DESC LIMIT 6,1 SELECT * FROM jobssection WHERE jobssection.active = 'Y' ORDER BY sectionorder ASC SELECT heading,firstpara,storydate,codeID FROM newsnew where sectionID LIKE "%SAB%" and sectionID LIKE "%PRO%" AND sectionID not like '%SUP%' and codeID < #fivestory.codeID# and codeID < #sixstory.codeID# ORDER BY codeID DESC LIMIT 5,5 SELECT heading,firstpara,storydate,codeID FROM newsnew where sectionID LIKE "%SAB%" and sectionID LIKE "%PRO%" AND sectionID not like '%SUP%' and codeID < #fivestory.codeID# and codeID < #sixstory.codeID# ORDER BY codeID DESC LIMIT 10,5 SELECT codeID FROM newsnew where sectionID LIKE "%SAB%" and sectionID LIKE "%PRO%" AND sectionID not like '%SUP%' and codeID < #fivestory.codeID# and codeID < #sixstory.codeID# ORDER BY codeID DESC LIMIT 14,1 SELECT * FROM propertylist WHERE (type = 'property' or type = 'tender') AND active = 'y' 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
#today# | Daily spa news & jobs
search jobs
search news
 
#StartRow_J# to #EndRow_J# of #J.RecordCount# properties/tenders
#J.type#
#J.dateofinput#
#j.heading#
Location:#J.location# Company: #J.company#



 
#TopStory.heading#
#TopStory.altfirst# more
  
#ThirdStory.heading#
#ThirdStory.altfirst# more
 
#fourstory.heading#
#fourstory.altfirst# more
#fiveStory.heading#
#fiveStory.altfirst# more
  
#sixStory.heading#
#sixStory.altfirst# more

#brief1.storydate#
#brief1.heading#
#brief1.firstpara# more
 

#brief2.storydate#
#brief2.heading#
#brief2.firstpara# more
 
    Jobs page: TFM_Previous = PageNum_J - 1;If (TFM_Previous GTE 1) { if (TFM_Previous LT 1) TFM_Previous = 1; WriteOutput(''); WriteOutput(" Previous ");} For (i = TFM_startLink; i LTE TFM_endLink; i = i + 1) { If(i NEQ PageNum_J) { WriteOutput('#i#'); }Else{ WriteOutput('#i#'); }If(i neq TFM_endLink) WriteOutput(" ");} TFM_Next = PageNum_J + 1;If (TFM_Next - 1 LT TotalPages_J) { WriteOutput(''); WriteOutput(' Next');}  

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