SELECT number FROM randomnumber WHERE number < 7 ORDER BY RAND() limit 1 SELECT tempID,codeID,heading,first,location,company,storytype FROM temp_opps WHERE site = 'LO' and storytype = 'LOtraininglink' order by rand() LIMIT 8 SELECT lk_code,codeID,heading,firstpara,piclow FROM newsnew WHERE (advertorial = 'Y' and clubkit = 'A') and lk_code != '31331337' and lk_code != '5485' and lk_code != '894' ORDER BY codeID DESC limit 3 SELECT * FROM DIGImailing where magazine = 'Leisure Opportunities' and mail_status = 'sent' order by mag_year desc ,mag_issue desc Limit 1 select * from TPcatalogue where sitecodes like '%HC%' and (companyID != '4390' and companyID != '832' and companyID != '3904') order by RAND() SELECT issue FROM TPlive WHERE TPmagazine = 'health club management' SELECT codeID,heading,firstpara,author,straphead,feat_picname FROM features_database WHERE magazine = 'TP' and TPmagazine = 'health club management' and (straphead !='' or straphead is not null) and (firstpara !='' or firstpara is not null) and straphead not like '%product%' and straphead not like '%show%' and straphead not like '%diary%' and straphead not like '%news%' and straphead not like "%editor's letter%" and straphead not like '%letters%' and heading !='' and heading is not null and issue = '#featuresSET.issue#' order by RAND() LIMIT 6 SELECT category, heading, standfirst, codeID FROM features_database WHERE magazine = 'HC' and heading not like '#features.heading#' ORDER BY codeID DESC LIMIT 3 SELECT category, heading, standfirst, codeID FROM features_database WHERE magazine = 'HC' and heading not like '#features.heading#' ORDER BY codeID DESC LIMIT 1,1 SELECT pic_name, feature_name, pic_caption, codeID FROM gallery WHERE email_order = 1 and mag = 'HCM' ORDER BY email_date DESC LIMIT 1 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 jobtitle, salary, location, company, codeID FROM jobsnew WHERE section LIKE '%HAF%' AND active = 'Y' AND featuredjob != 'y' ORDER BY codeID DESC limit 21 SELECT codeID,jobtitle,salary,location,company,co_logo FROM jobsnew WHERE featuredjob = 'y' and active = 'y' and section LIKE '%HAF%' ORDER BY RAND() limit 1 SELECT codeID, heading, firstpara, piclow, storydate, altfirst, author_web, pic_shape,newscodeID FROM newsnew WHERE sectionID LIKE '%HAF%' and (lo = 'Y' OR lo = '1' OR lo = 'A' OR lo = 'B' OR lo = 'C' OR lo = 'D' OR lo = 'E' OR lo = 'F') and piclow not like 'blanknews.gif' and picno not like 'N' ORDER BY codeID DESC limit 6 SELECT codeID, heading, firstpara, storydate FROM newsnew WHERE sectionID LIKE '%HAF%' and (lo = 'Y' OR lo = '1' OR lo = 'A' OR lo = 'B' OR lo = 'C' OR lo = 'D' OR lo = 'E' OR lo = 'F') and ((codeID > '#lastcodeID#' and piclow = 'blanknews.gif') or (codeID < '#lastcodeID#')) ORDER BY codeID DESC limit 20 SELECT codeID,heading FROM newsnew WHERE sectionID LIKE '%HAF%' and ((codeID > '#lastcodeID#' and piclow = 'blanknews.gif') or (codeID < '#lastcodeID#')) and world_region LIKE '%I%' ORDER BY codeID DESC LIMIT 1 SELECT codeID,heading FROM newsnew WHERE sectionID LIKE '%HAF%' and ((codeID > '#lastcodeID#' and piclow = 'blanknews.gif') or (codeID < '#lastcodeID#')) and world_region LIKE '%I%' ORDER BY codeID DESC LIMIT 1,1 SELECT codeID,heading FROM newsnew WHERE sectionID LIKE '%HAF%' and ((codeID > '#lastcodeID#' and piclow = 'blanknews.gif') or (codeID < '#lastcodeID#')) and world_region LIKE '%H%' and codeID not like '#AFR.codeID#' and codeID not like '#AFR1.codeID#' ORDER BY codeID DESC LIMIT 1 SELECT codeID,heading FROM newsnew WHERE sectionID LIKE '%HAF%' and ((codeID > '#lastcodeID#' and piclow = 'blanknews.gif') or (codeID < '#lastcodeID#')) and world_region LIKE '%H%' and codeID not like '#AFR.codeID#' and codeID not like '#AFR1.codeID#' ORDER BY codeID DESC LIMIT 1,1 SELECT codeID,heading FROM newsnew WHERE sectionID LIKE '%HAF%' and ((codeID > '#lastcodeID#' and piclow = 'blanknews.gif') or (codeID < '#lastcodeID#')) and world_region LIKE '%E%' and codeID not like '#AFR.codeID#' and codeID not like '#AFR1.codeID#' and codeID not like '#APA.codeID#' and codeID not like '#APA1.codeID#' ORDER BY codeID DESC LIMIT 1 SELECT codeID,heading FROM newsnew WHERE sectionID LIKE '%HAF%' and ((codeID > '#lastcodeID#' and piclow = 'blanknews.gif') or (codeID < '#lastcodeID#')) and world_region LIKE '%E%' and codeID not like '#AFR.codeID#' and codeID not like '#AFR1.codeID#' and codeID not like '#APA.codeID#' and codeID not like '#APA1.codeID#' ORDER BY codeID DESC LIMIT 1,1 SELECT codeID,heading FROM newsnew WHERE sectionID LIKE '%HAF%' and ((codeID > '#lastcodeID#' and piclow = 'blanknews.gif') or (codeID < '#lastcodeID#')) and world_region LIKE '%C%' and codeID not like '#AFR.codeID#' and codeID not like '#AFR1.codeID#' and codeID not like '#APA.codeID#' and codeID not like '#APA1.codeID#' and codeID not like '#CSA.codeID#' and codeID not like '#CSA1.codeID#' ORDER BY codeID DESC LIMIT 1 SELECT codeID,heading FROM newsnew WHERE sectionID LIKE '%HAF%' and ((codeID > '#lastcodeID#' and piclow = 'blanknews.gif') or (codeID < '#lastcodeID#')) and world_region LIKE '%C%' and codeID not like '#AFR.codeID#' and codeID not like '#AFR1.codeID#' and codeID not like '#APA.codeID#' and codeID not like '#APA1.codeID#' and codeID not like '#CSA.codeID#' and codeID not like '#CSA1.codeID#' ORDER BY codeID DESC LIMIT 1,1 SELECT codeID,heading FROM newsnew WHERE sectionID LIKE '%HAF%' and ((codeID > '#lastcodeID#' and piclow = 'blanknews.gif') or (codeID < '#lastcodeID#')) and world_region LIKE '%F%' and codeID not like '#AFR.codeID#' and codeID not like '#AFR1.codeID#' and codeID not like '#APA.codeID#' and codeID not like '#APA1.codeID#' and codeID not like '#CSA.codeID#' and codeID not like '#CSA1.codeID#' and codeID not like '#EUR.codeID#' and codeID not like '#EUR1.codeID#' ORDER BY codeID DESC LIMIT 1 SELECT codeID,heading FROM newsnew WHERE sectionID LIKE '%HAF%' and ((codeID > '#lastcodeID#' and piclow = 'blanknews.gif') or (codeID < '#lastcodeID#')) and world_region LIKE '%F%' and codeID not like '#AFR.codeID#' and codeID not like '#AFR1.codeID#' and codeID not like '#APA.codeID#' and codeID not like '#APA1.codeID#' and codeID not like '#CSA.codeID#' and codeID not like '#CSA1.codeID#' and codeID not like '#EUR.codeID#' and codeID not like '#EUR1.codeID#' ORDER BY codeID DESC LIMIT 1,1 SELECT codeID,heading FROM newsnew WHERE sectionID LIKE '%HAF%' and ((codeID > '#lastcodeID#' and piclow = 'blanknews.gif') or (codeID < '#lastcodeID#')) and world_region LIKE '%D%' and codeID not like '#AFR.codeID#' and codeID not like '#AFR1.codeID#' and codeID not like '#APA.codeID#' and codeID not like '#APA1.codeID#' and codeID not like '#CSA.codeID#' and codeID not like '#CSA1.codeID#' and codeID not like '#EUR.codeID#' and codeID not like '#EUR1.codeID#' and codeID not like '#MEA.codeID#' and codeID not like '#MEA1.codeID#' ORDER BY codeID DESC LIMIT 1 SELECT codeID,heading FROM newsnew WHERE sectionID LIKE '%HAF%' and ((codeID > '#lastcodeID#' and piclow = 'blanknews.gif') or (codeID < '#lastcodeID#')) and world_region LIKE '%G%' and codeID not like '#AFR.codeID#' and codeID not like '#AFR1.codeID#' and codeID not like '#APA.codeID#' and codeID not like '#APA1.codeID#' and codeID not like '#CSA.codeID#' and codeID not like '#CSA1.codeID#' and codeID not like '#EUR.codeID#' and codeID not like '#EUR1.codeID#' and codeID not like '#MEA.codeID#' and codeID not like '#MEA1.codeID#' and codeID not like '#NAM.codeID#' ORDER BY codeID DESC LIMIT 1 SELECT codeID,heading FROM newsnew WHERE sectionID LIKE '%SAB%' and ((codeID > '#lastcodeID#' and piclow = 'blanknews.gif') or (codeID < '#lastcodeID#')) and codeID not like '#AFR.codeID#' and codeID not like '#AFR1.codeID#' and codeID not like '#APA.codeID#' and codeID not like '#APA1.codeID#' and codeID not like '#CSA.codeID#' and codeID not like '#CSA1.codeID#' and codeID not like '#EUR.codeID#' and codeID not like '#EUR1.codeID#' and codeID not like '#MEA.codeID#' and codeID not like '#MEA1.codeID#' and codeID not like '#NAM.codeID#' and codeID not like '#SAS.codeID#' ORDER BY codeID DESC LIMIT 6 SELECT codeID,pic_shape FROM newsnew WHERE sectionID LIKE '%HAF%' and (lo = 'Y' OR lo = '1' OR lo = 'A' OR lo = 'B' OR lo = 'C' OR lo = 'D' OR lo = 'E' OR lo = 'F') and piclow not like 'blanknews.gif' and picno not like 'N' ORDER BY codeID DESC limit 1,1 SELECT codeID,pic_shape FROM newsnew WHERE sectionID LIKE '%HAF%' and (lo = 'Y' OR lo = '1' OR lo = 'A' OR lo = 'B' OR lo = 'C' OR lo = 'D' OR lo = 'E' OR lo = 'F') and piclow not like 'blanknews.gif' and picno not like 'N' ORDER BY codeID DESC limit 2,1 SELECT showname, fulldate, venue,city,country, codeID FROM diarydates WHERE active = 'y' AND (category LIKE '%hcm%' OR sector LIKE '%haf%') GROUP by companyID ORDER BY startcode ASC,endcode asc limit 13 SELECT heading, location, company, codeID FROM propertylist WHERE active = 'y' ORDER BY codeID DESC limit 9 SELECT heading, altfirst, firstpara, piclow, codeID, lk_code FROM newsnew WHERE (clubkit = 'A' or hcmweb = 'E' or hcmweb = 'F') and advertorial = 'N' ORDER BY codeID desc limit 4 SELECT piclow,codeID,lk_code,heading,firstpara FROM newsnew WHERE liw = '1' ORDER BY RAND() LIMIT 3 SELECT * FROM profile WHERE sitecode like '%HC%' ORDER BY RAND() LIMIT 1 SELECT DISTINCT productcat FROM buyerscompanies WHERE active = 'Y' and industrycat like 'hc' ORDER BY productcat ASC SELECT straphead,codeID,heading,issue,page_no FROM features_database WHERE magazine = 'TP' and TPmagazine = 'health club management' and (straphead !='' or straphead is not null) and issue = '#featuresSET.issue#' group by straphead order by page_no asc SELECT * FROM newsnew WHERE advertorial = 'Y' and (clubkit = 'A' or hcmweb = 'E' or hcmweb = 'F') ORDER BY coname,codeID DESC Health Club Management - daily news, health and fitness jobs, features, products, diary dates and training View other Leisure Media websites --->
#today# Health Club Management: daily news and jobs
 
 
#today#
 
Sign up for FREE weekly emails
latest jobs
Companies now recruiting
Latest health & fitness jobs powered by
#JobsP.jobtitle#
Salary: #JobsP.salary#
Location: #JobsP.location#
Company: #JobsP.company#
More>>
#Jobs.jobtitle#
 Salary: #Jobs.salary#
 Location: #Jobs.location#
Company: #Jobs.company#
More>>
in this issue
#prof1.SHORTdescr#

property & tenders
#Prop.heading#
 Location: #Prop.location# Company: #Prop.company#
 More>>
More property/tenders>>
 
news headlines
#Top.heading#
#Top.heading#
By #Top.author_web#
#Top.altfirst# More>>
   <cfoutput>#Top.heading#</cfoutput>
#Top.heading#
<cfoutput>#Top.heading#</cfoutput>   #Top.heading#
By #Top.author_web#
#Top.altfirst# More>>
 
ASIA-PACIFIC>>
#APA.heading#
EUROPE>>
#EUR.heading#
NORTH AMERICA>>
#NAM.heading#
SOUTH ASIA>>
#SAS.heading#
ASIA-PACIFIC>>
#APA.heading#
#APA1.heading#
C & S AMERICA>>
#CSA.heading#
#CSA1.heading#
EUROPE>>
#EUR.heading#
#EUR1.heading#
MIDDLE EAST>>
#MEA.heading#
#MEA1.heading#
NORTH AMERICA>>
#NAM.heading#
SOUTH ASIA>>
#SAS.heading#
#Top.heading#
#Top.heading#
By #Top.author_web#
#Top.altfirst# More>>		   <cfoutput>#Top.heading#</cfoutput>
 
SPA & BEAUTY>>
#SPA.heading#
#SPA.heading#
health club management features
#features.heading#

#features.straphead#:

#features.heading#

#features.firstpara# View>>
  #features.heading#

#features.straphead#:

#features.heading#

#features.firstpara# View>>
  #features.heading#

#features.straphead#:

#features.heading#

#features.firstpara# View>>
  #features.heading#

#features.straphead#:

#features.heading#

#features.firstpara# View>>
news in brief
#Top.heading#

#Top.storydate#

#Top.heading#

#Top.firstpara# More>>
 
#Top.heading#

#Top.storydate#

#Top.heading#

#Top.firstpara# More>>
 
#Top.heading#

#Top.storydate#

#Top.heading#

#Top.firstpara# More>>


 
#Shorts.storydate#

#Shorts.heading#

#Shorts.firstpara# More>>
#Shorts.storydate#

#Shorts.heading#

#Shorts.firstpara# More>>
 
#Shorts.storydate#

#Shorts.heading#

#Shorts.firstpara# More>>



featured suppliers
  Powered by fitness-kit.net
#J.heading#
#J.heading#

#J.firstpara#
More>>
 
#J.heading#
#J.heading#

#J.firstpara#
More>>
 
#J.heading#
#J.heading#

#J.firstpara#
More>>
product news
#main.heading#

#main.heading#

FROM FITNESS-KIT.NET

#main.firstpara#
More>>
 
#main.heading#

#main.heading#

FROM FITNESS-KIT.NET

#main.firstpara#
More>>
 
#main.heading#

#main.heading#

FROM FITNESS-KIT.NET

#main.firstpara#
More>>
 
#main.heading#

#main.heading#

FROM FITNESS-KIT.NET

#main.firstpara#
More>>
find a supplier
Find the right products and services for your company
Search
 
or by
Company A - Z
A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z
Product A - Z
A - F   G - P   Q - S   T - Z
 
#square.bannerlocation# Click here to visit the #square.company# website>>
catalogue gallery
Click on a catalogue to view it online


 
Advertise in our
Catalogue gallery

and get your products in front of over 360,000 potential buyers.
Call +44(0)1462 431385

   
 

 
Advertise in our Catalogue gallery. Click here for more details or call now +44(0)1462 431385

company profile
#prof.coname#

#prof.aboutline#

#prof.first#
View full profile>>
 

health club management directory
ADVERTISE in the Health Club Management directory for less than £40 a month.
Call Display Sales on +44 (0) 1462 431385
#Dir.dirhead#
 
#Dir2.dirhead#
Vouchers/Days/Breaks
Gym Passes
Detox
Fitness Deals
#square.bannerlocation# Click here to visit the #square.company# website>>
diary dates
Powered by leisurediary.com

 




#DD.fulldate#

#DD.showname#

#DD.venue#, #DD.city#, #DD.country#

More>>


To ADVERTISE on the health club
mangement website call Display Sales on
 +44 (0) 1462 431385
#square.bannerlocation# Click here to visit the #square.company# website>>
Published by The Leisure Media Company, Portmill House, Portmill Lane, Hitchin, Herts SG5 1DJ.
Tel: +44 (0)1462 431385 Fax: +44 (0)1462 433909 | Contact us | About us | Advertise | © Cybertrek Ltd