SELECT text,link from intranet_links where sub_head = 'Leisure Media Websites' and text != 'leisuremedia.com' and text != 'leisuresubs.com' order by text ASC 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 DISTINCT productcat FROM buyerscompanies WHERE active = 'Y' and productcat != '' ORDER BY productcat ASC SELECT jobtitle, salary, location, company, codeID FROM jobsnew WHERE (wlj = 'Y' or section like '%EXA%') AND active = 'Y' ORDER BY codeID DESC limit 4 SELECT * FROM profile WHERE sitecode like '%LM%' ORDER BY RAND() LIMIT 1 SELECT * FROM TPlive WHERE TPmagazine = 'Leisure Management' select * from TPcatalogue where sitecodes like '%LM%' order by RAND() LIMIT 1 SELECT * FROM features_database WHERE codeID = 2473 or codeID = 2443 or codeID = 2523 or codeID = 2543 order by rand() SELECT codeID,heading,firstpara,author,straphead,feat_picname FROM features_database WHERE magazine = 'TP' and TPmagazine = 'leisure management' and (straphead !='' or straphead is not null) and straphead not like '%product%' and straphead not like '%show%' and straphead not like '%news%' and issue = '#featuresSET.issue#' order by RAND() LIMIT 6 SELECT codeID,heading,firstpara,author,straphead,feat_picname FROM features_database WHERE magazine = 'TP' and TPmagazine = 'leisure management' and (straphead !='' or straphead is not null) and straphead not like '%product%' and straphead not like '%show%' and straphead not like '%news%' and issue = '#featuresSET.issue#' order by RAND() LIMIT 6 SELECT codeID,heading,straphead,issue,page_no FROM features_database WHERE magazine = 'TP' and TPmagazine = 'leisure management' and (straphead !='' or straphead is not null) and issue = '#featuresSET.issue#' order by page_no asc SELECT * FROM buyerscompanies WHERE code = #URL.code# ORDER BY code DESC SELECT CodeID, heading,firstpara,storydate,piclow,lkemail,sectionID,lk_code FROM newsnew WHERE lk_code = '#URL.code#' and piclow != 'blanknews.gif' group by heading ORDER BY codeID DESC limit 3 SELECT jobtitle, salary, location, company, codeID, co_logo FROM jobsnew WHERE wlj = 'Y' AND active = 'Y' and salarydata like '%#URL.salarydata#%' and world_region like '%#URL.region#%' 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);} SELECT storydate, heading, firstpara, codeID, piclow FROM newsnew WHERE (story like '%#URL.newssearch#%' or heading like '%#URL.newssearch#%') and ( wln = 'O' OR world_region LIKE '%B%' OR world_region LIKE '%C%' OR world_region LIKE '%D%' OR world_region LIKE '%E%' OR world_region LIKE '%F%' OR world_region LIKE '%G%' OR world_region LIKE '%H%' OR world_region LIKE '%I%') AND (story LIKE '%#URL.newssearch#%' OR heading LIKE '%#URL.newssearch#%') ORDER BY codeID DESC SELECT storydate, heading, firstpara, codeID, piclow FROM newsnew WHERE (heading like '%#URL.newssearch#%' OR firstpara like '%#URL.newssearch#%' OR story like '%#URL.newssearch#%') AND ( wln = 'O' OR world_region LIKE '%B%' OR world_region LIKE '%C%' OR world_region LIKE '%D%' OR world_region LIKE '%E%' OR world_region LIKE '%F%' OR world_region LIKE '%G%' OR world_region LIKE '%H%' OR world_region LIKE '%I%') 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);} SELECT * FROM profile WHERE codeID = #URL.codeID# SELECT * FROM profile where sitecode != '' order by RAND() SELECT jobtitle, salary, location, company, codeID, co_logo FROM jobsnew WHERE (codeID = 999999 or codeID = 999999) and active = 'y' ORDER BY RAND() SELECT coname,town,county,country,weblinkaddress,first,coname,brochure_text,lk_logo,code,cosearch,brochure_link,brochure_text FROM buyerscompanies WHERE coname LIKE '#URL.company#%' and active = 'Y' and lk_logo_active = 'Y' and productcat != '' ORDER BY coname ASC SELECT coname,town,county,country,weblinkaddress,first,coname,brochure_text,lk_logo,code,cosearch,brochure_link,brochure_text FROM buyerscompanies WHERE coname LIKE '#URL.company#%' and active = 'Y' and lk_logo_active = 'N' and productcat != '' ORDER BY coname ASC SELECT coname FROM buyerscompanies WHERE coname LIKE '#URL.company#%' and active = 'Y' and productcat != '' ORDER BY coname ASC SELECT coname,town,county,country,weblinkaddress,first,coname,brochure_text,lk_logo,code,cosearch,brochure_link,brochure_text FROM buyerscompanies WHERE productcat = '#URL.prodcat#' and active = 'Y' and lk_logo_active = 'Y' ORDER BY coname ASC SELECT coname,town,county,country,weblinkaddress,first,coname,brochure_text,lk_logo,code,cosearch,brochure_link,brochure_text FROM buyerscompanies WHERE productcat = '#URL.prodcat#' and active = 'Y' and lk_logo_active = 'N' ORDER BY coname ASC SELECT coname FROM buyerscompanies WHERE productcat = '#URL.prodcat#' and active = 'Y' ORDER BY coname ASC SELECT coname,town,county,country,weblinkaddress,first,coname,brochure_text,lk_logo,code,cosearch,brochure_link,brochure_text FROM buyerscompanies WHERE (keywords LIKE '%#URL.keywords#%' OR coname LIKE '%#URL.keywords#%') and active = 'Y' and lk_logo_active = 'Y' ORDER BY coname ASC SELECT coname,town,county,country,weblinkaddress,first,coname,brochure_text,lk_logo,code,cosearch,brochure_link,brochure_text FROM buyerscompanies WHERE (keywords LIKE '%#URL.keywords#%' OR coname LIKE '%#URL.keywords#%') and active = 'Y' and lk_logo_active = 'N' ORDER BY coname ASC SELECT coname FROM buyerscompanies WHERE (keywords LIKE '%#URL.keywords#%' OR coname LIKE '%#URL.keywords#%') and active = 'Y' ORDER BY coname ASC SELECT DISTINCT productcat FROM buyerscompanies WHERE active = 'Y' and productcat != '' and (productcat like 'A%' or productcat like 'B%' or productcat like 'C%' or productcat like 'D%' or productcat like 'E%' or productcat like 'F%') ORDER BY productcat ASC SELECT DISTINCT productcat FROM buyerscompanies WHERE active = 'Y' and productcat != '' and (productcat like 'G%' or productcat like 'H%' or productcat like 'I%' or productcat like 'J%' or productcat like 'K%' or productcat like 'L%'or productcat like 'M%'or productcat like 'N%'or productcat like 'O%'or productcat like 'P%') ORDER BY productcat ASC SELECT DISTINCT productcat FROM buyerscompanies WHERE active = 'Y' and productcat != '' and (productcat like 'Q%' or productcat like 'R%' or productcat like 'S%') ORDER BY productcat ASC SELECT DISTINCT productcat FROM buyerscompanies WHERE active = 'Y' and productcat != '' and (productcat like 'T%' or productcat like 'U%' or productcat like 'V%' or productcat like 'W%' or productcat like 'X%' or productcat like 'Y%' or productcat like 'Z%') ORDER BY productcat ASC SELECT DISTINCT productcat FROM buyerscompanies WHERE active = 'Y' and industrycat like 'LM' ORDER BY productcat ASC SELECT coname,town,county,country,weblinkaddress,first,coname,brochure_text,lk_logo,code,cosearch,brochure_link,brochure_text FROM buyerscompanies WHERE productcat LIKE '#URL.prodcat#' and active = 'Y' and lk_logo_active = 'Y' and productcat != '' ORDER BY RAND() SELECT coname,town,county,country,weblinkaddress,first,coname,brochure_text,lk_logo,code,cosearch,brochure_link,brochure_text FROM buyerscompanies WHERE productcat LIKE '#URL.prodcat#' and active = 'Y' and lk_logo_active = 'N' and productcat != '' ORDER BY coname ASC SELECT coname FROM buyerscompanies WHERE productcat LIKE '#URL.prodcat#' and active = 'Y' and productcat != '' ORDER BY coname ASC SELECT DISTINCT productcat FROM buyerscompanies WHERE active = 'Y' and productcat != '' ORDER BY productcat ASC SELECT * FROM TPcatalogue where sitecodes != '' order by RAND() SELECT codeID, companyID, jobtitle FROM jobsnew WHERE codeID = #URL.codeID# and active = 'y' SELECT codeID, companyID, jobtitle FROM jobsnew WHERE codeID = #URL.codeID# SELECT * FROM jobsnew WHERE codeID = #URL.codeID# and active = 'y' SELECT * FROM jobsnew WHERE companyID = '#jobactive1.companyID#' and jobtitle = '#jobactive1.jobtitle#' and active = 'y' ORDER by codeID desc limit 1 SELECT jobtitle, salary, location, company, codeID FROM jobsnew WHERE company = '#jobdetail.company#' and codeID != '#URL.codeID#' AND active = 'Y' ORDER BY codeID DESC limit 5 SELECT * FROM newsnew WHERE advertorial = 'Y' and piclow not like 'blanknews.gif' and picno not like 'N' and lkemail != 'N' ORDER BY coname,codeID DESC SELECT codeID, heading, firstpara, piclow, storydate FROM newsnew WHERE (wln = 'y' OR wln = 'O' OR world_region LIKE '%B%' OR world_region LIKE '%C%' OR world_region LIKE '%D%' OR world_region LIKE '%E%' OR world_region LIKE '%F%' OR world_region LIKE '%G%' OR world_region LIKE '%H%' OR world_region LIKE '%I%') and piclow not like 'blank%' ORDER BY codeID DESC limit 3 SELECT showname, fulldate, venue,city,country, codeID FROM diarydates WHERE active = 'y' ORDER BY startcode ASC, endcode asc limit 4 SELECT heading, location, company, codeID FROM propertylist WHERE active = 'y' ORDER BY codeID DESC limit 4 SELECT heading, location, company, codeID FROM propertylist WHERE type = 'Tender' and active = 'y' ORDER BY codeID DESC limit 3 SELECT * FROM buyerscompanies WHERE code = #URL.codeID# ORDER BY code DESC SELECT CodeID, heading,firstpara,storydate,piclow,lkemail,sectionID,lk_code FROM newsnew WHERE lk_code = '#URL.codeID#' and piclow != 'blanknews.gif' group by heading ORDER BY codeID DESC limit 3 SELECT codeID, heading, firstpara, piclow, storydate, altfirst, author_web, pic_shape FROM newsnew WHERE sectionID LIKE '%SAR%' 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 SELECT heading, storydate,story,piclow,author_web,companyID,firstpara FROM newsnew WHERE codeID = #URL.codeID# SELECT heading,location, price,details as story,company,address,address2,city,county,postcode,country,email,website,co_logo FROM propertylist WHERE codeID = #URL.codeID# SELECT heading, storydate,story,piclow,author_web,companyID,LK_code,advertorial FROM newsnew WHERE codeID = '#URL.codeID#' SELECT * FROM buyerscompanies WHERE code LIKE '#NEWS.LK_code#' ORDER BY coname ASC SELECT heading, storydate,story,piclow,author_web,companyID,LK_code FROM newsnew WHERE codeID = '#URL.codeID#' SELECT * FROM buyerscompanies WHERE code LIKE '#NEWS.LK_code#' ORDER BY coname ASC SELECT piclow,codeID,lk_code,heading,firstpara FROM newsnew WHERE (lkweb = 'A' OR lkweb = 'spa' OR spabus = 'D' OR spabus = 'E') ORDER BY codeID DESC LIMIT 1 SELECT piclow,codeID,lk_code,heading,firstpara FROM newsnew WHERE (beautykit = 'A') and heading != '#SPAK.heading#' ORDER BY codeID DESC LIMIT 1 SELECT piclow,codeID,lk_code,heading,firstpara FROM newsnew WHERE (clubkit = 'A' OR clubkit = 'club' OR hcmweb = 'E' OR hcmweb = 'F' OR hcmemail = 'E' OR hcmemail = 'F') and heading != '#SPAK.heading#' and heading != '#YK.heading#' ORDER BY codeID DESC LIMIT 1 SELECT piclow,codeID,lk_code,heading,firstpara FROM newsnew WHERE (sportkit = 'A' OR sportkit = 'sport' OR smweb = 'E' OR smweb = 'F' OR smemail = 'E' OR smemail = 'F') and heading != '#SPAK.heading#' and heading != '#YK.heading#' and heading != '#CK.heading#' ORDER BY codeID DESC LIMIT 1 SELECT piclow,codeID,lk_code,heading,firstpara FROM newsnew WHERE (barkit = 'A' OR barkit = 'bar' OR foodkit = 'A' OR foodkit = 'food') and heading != '#SPAK.heading#' and heading != '#YK.heading#' and heading != '#CK.heading#' and heading != '#SK.heading#' ORDER BY codeID DESC LIMIT 1 SELECT piclow,codeID,lk_code,heading,firstpara FROM newsnew WHERE (gamingkit = 'A' or gamingkit = 'game') and heading != '#SPAK.heading#' and heading != '#YK.heading#' and heading != '#CK.heading#' and heading != '#SK.heading#' and heading != '#BK.heading#' ORDER BY codeID DESC LIMIT 1 SELECT piclow,codeID,lk_code,heading,firstpara FROM newsnew WHERE (funkit = 'A' OR funkit = 'fun' OR attemail = 'F' OR attemail = 'G') and heading != '#SPAK.heading#' and heading != '#YK.heading#' and heading != '#CK.heading#' and heading != '#SK.heading#' and heading != '#BK.heading#' and heading != '#GK.heading#' ORDER BY codeID DESC LIMIT 1 SELECT piclow,codeID,lk_code,heading,firstpara FROM newsnew WHERE (museumkit = 'A') and heading != '#SPAK.heading#' and heading != '#YK.heading#' and heading != '#CK.heading#' and heading != '#SK.heading#' and heading != '#BK.heading#' and heading != '#GK.heading#' and heading != '#FK.heading#' ORDER BY codeID DESC LIMIT 1 SELECT piclow,codeID,lk_code,heading,firstpara FROM newsnew WHERE (green = 'A') and heading != '#SPAK.heading#' and heading != '#YK.heading#' and heading != '#CK.heading#' and heading != '#SK.heading#' and heading != '#BK.heading#' and heading != '#GK.heading#' and heading != '#FK.heading#' and heading != '#MK.heading#' ORDER BY codeID DESC LIMIT 1 SELECT * FROM DIGImailing where codeID = '#URL.codeID#' and mail_status = 'sent' SELECT * FROM DIGImailing where magazine = '#URL.mag#' and mail_status = 'sent' order by mag_year desc ,mag_issue desc limit 1 SELECT * FROM DIGImailing where magazine = '#URL.mag#' and mail_status = 'sent' and codeID != #profSET.codeID# order by mag_year desc ,mag_issue desc SELECT * FROM DIGImailing where magazine = '#URL.mag#' and mail_status = 'sent' order by mag_year desc ,mag_issue desc Limit 26 SELECT codeID,heading,firstpara,straphead,feat_picname,page_no FROM features_database WHERE magazine = 'TP' and TPmagazine = '#URL.mag#' and issue = '#profSET.issue#' 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 '%news%' and straphead not like '%director%' and straphead not like '%letters%' order by RAND() LIMIT 1 SELECT codeID,heading,straphead,page_no,firstpara,feat_picname FROM features_database WHERE (magazine = 'TP' and TPmagazine = '#URL.mag#' and issue = '#profSET.issue#') and codeID not like '#J1.codeID#' order by page_no asc SELECT * FROM DIGImailing where magazine = '#URL.mag#' and mail_status = 'sent' order by mag_year desc ,mag_issue desc Limit 26 SELECT codeID,heading,firstpara,straphead,feat_picname,page_no FROM features_database WHERE magazine = 'TP' and TPmagazine = '#URL.mag#' and issue = '#prof1.issue#' 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 '%news%' and straphead not like '%director%' and straphead not like '%letters%' order by RAND() LIMIT 1 SELECT codeID,heading,straphead,page_no,firstpara,feat_picname FROM features_database WHERE (magazine = 'TP' and TPmagazine = '#URL.mag#' and issue = '#prof1.issue#') and codeID not like '#J1.codeID#' order by page_no asc SELECT codeID, heading, firstpara, storydate, piclow FROM newsnew WHERE (wln = 'y' OR wln = 'O' OR world_region LIKE '%B%' OR world_region LIKE '%C%' OR world_region LIKE '%D%' OR world_region LIKE '%E%' OR world_region LIKE '%F%' OR world_region LIKE '%G%' OR world_region LIKE '%H%' OR world_region LIKE '%I%') ORDER BY codeID DESC SELECT codeID, heading, firstpara, storydate, piclow FROM newsnew WHERE sectionID like '%SAB%' and sectionID not like '%SUP%' ORDER BY codeID DESC SELECT codeID, heading, firstpara, storydate, piclow FROM newsnew WHERE sectionID like '%HAF%' and sectionID not like '%SUP%' and world_region = '#URL.world_region#' ORDER BY codeID DESC SELECT storydate, heading, firstpara, codeID, piclow FROM newsnew WHERE (lo = 'Y' OR lo = '1' OR lo = 'A' OR lo = 'B' OR lo = 'C' OR lo = 'D' OR lo = 'E' OR lo = 'F') AND (story LIKE '%#URL.newssearch#%' OR heading LIKE '%#URL.newssearch#%') ORDER BY codeID DESC SELECT heading,location,company,codeID,co_logo FROM propertylist WHERE active = 'y' ORDER BY codeID DESC SELECT heading,location,company,codeID,co_logo FROM propertylist WHERE active = 'y' AND type = 'tender' ORDER BY codeID DESC SELECT heading,location,company,codeID FROM propertylist WHERE active = 'y' AND type = 'property' and companyID = #URL.companyID# ORDER BY codeID DESC SELECT jobtitle, salary, location, co_logo, company, codeID, section FROM jobsnew WHERE (wlj = 'Y' or section like '%EXA%') 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);} 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
#today# Daily jobs, news, training & property worldwide
#URL.subject#jobsproductsproductsjobsfeaturesnews#URL.pagetype#.gif" width="642" height="20" border="0" usemap="#MapMap2" />
 
 
Sign up for FREE weekly emails
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 | © Cybertrek Ltd