Spa Business: Uniting the world of spas

SELECT number FROM randomnumber WHERE number < 6 ORDER BY RAND() limit 1 SELECT jobtitle, salary, location, company, codeID, section FROM jobsnew WHERE section LIKE '%sab%' AND active = 'Y' AND featuredjob != 's' ORDER BY codeID DESC LIMIT 10 SELECT codeID,jobtitle,salary,location,company,co_logo FROM jobsnew WHERE featuredjob = 's' and active = 'y' ORDER BY RAND() limit 2 SELECT heading from advertorial where advertorial = 'N' and service = 'SBW' order by RAND() LIMIT 1 SELECT heading from advertorial where (advertorial = 'N' and service = 'SBW') and heading not like '#adv.heading#' order by RAND() LIMIT 1 SELECT heading from advertorial where (advertorial = 'N' and service = 'SBW') and heading not like '#adv.heading#' and heading not like '#adv1.heading#' order by RAND() LIMIT 1 SELECT heading from advertorial where (advertorial = 'N' and service = 'SBW') and heading not like '#adv.heading#' and heading not like '#adv1.heading#' and heading not like '#adv2.heading#' order by RAND() LIMIT 1 SELECT heading from advertorial where (advertorial = 'N' and service = 'SBW') and heading not like '#adv.heading#' and heading not like '#adv1.heading#' and heading not like '#adv2.heading#' and heading not like '#adv3.heading#' order by RAND() LIMIT 1 SELECT heading from advertorial where (advertorial = 'N' and service = 'SBW') and heading not like '#adv.heading#' and heading not like '#adv1.heading#' and heading not like '#adv2.heading#' and heading not like '#adv3.heading#' and heading not like '#adv4.heading#' order by RAND() LIMIT 1 SELECT heading from advertorial where (advertorial = 'N' and service = 'SBW') and heading not like '#adv.heading#' and heading not like '#adv1.heading#' and heading not like '#adv2.heading#' and heading not like '#adv3.heading#' and heading not like '#adv4.heading#' and heading not like '#adv5.heading#' order by RAND() LIMIT 1 SELECT * FROM DIGImailing where magazine = 'Spa Opportunities' and mail_status = 'sent' order by mag_year desc ,mag_issue desc Limit 1 SELECT heading, altfirst, firstpara, piclow, codeID, lk_code FROM newsnew WHERE (LKweb = 'A' or LKweb = 'E' or LKweb = 'F') and advertorial = 'N' and heading not like 'ghdspa%' ORDER BY codeID desc limit 9 SELECT piclow,codeID,lk_code,heading,firstpara FROM newsnew WHERE liw = '1' ORDER BY RAND() LIMIT 3 SELECT * FROM newsnew WHERE (advertorial = 'Y' and LKweb = 'A') and heading not like '#adv.heading#' and heading not like '#adv1.heading#' and heading not like '#adv2.heading#' and heading not like '#adv3.heading#' and heading not like '#adv4.heading#' and heading not like '#adv5.heading#' and heading not like '#adv6.heading#' ORDER BY codeID DESC limit 3 SELECT * FROM newsnew where advertorial = 'y' and (LKweb = 'Spa' or LKweb = 'a') ORDER BY coname,codeID DESC SELECT * FROM profile WHERE sitecode like '%SB%' ORDER BY RAND() LIMIT 1 SELECT DISTINCT productcat FROM buyerscompanies WHERE active = 'Y' and industrycat like 'spa' ORDER BY productcat ASC select * from TPcatalogue where sitecodes like '%SB%' order by RAND() LIMIT 4 SELECT issue FROM TPlive WHERE TPmagazine = 'Spa Business' SELECT * FROM features_database WHERE codeID = 6633 or codeID = 6703 order by rand() SELECT codeID,heading,firstpara,author,straphead,feat_picname FROM features_database WHERE magazine = 'TP' and TPmagazine = 'Spa Business' 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 codeID,heading,straphead,issue,page_no FROM features_database WHERE magazine = 'TP' and TPmagazine = 'Spa Business' and (straphead !='' or straphead is not null) and issue = '#featuresSET.issue#' order by page_no asc 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 codeID, heading, firstpara, piclow, firstpara, storydate, altfirst, author_web, pic_shape FROM newsnew WHERE piclow not like 'blanknews.gif' and picno not like 'N' and sectionID not like '%SUP%' and sectionID LIKE "%SAB%" and world_region != 'A' ORDER BY codeID DESC limit 6 SELECT codeID, heading, firstpara, storydate 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 ((codeID > '#lastcodeID#' and piclow = 'blanknews.gif') or (codeID < '#lastcodeID#')) and sectionID LIKE '%SAB%' and sectionID NOT LIKE '%ARC%' and sectionID NOT LIKE '%DES%' and world_region != 'A' ORDER BY codeID DESC limit 14 SELECT showname, fulldate, venue,city,country, codeID FROM diarydates WHERE active = 'y' and sector like '%SAB%' ORDER BY startcode ASC, endcode asc limit 8 SELECT heading, location, company, codeID FROM propertylist WHERE type = 'property' AND active = 'y' and propspa = 'y' ORDER BY codeID DESC limit 15 SELECT heading, location, company, codeID FROM propertylist WHERE (type = 'property' OR type = 'Tender') AND active = 'y' and propspa != 'y' ORDER BY codeID DESC limit #propquant# SELECT codeID,heading,firstpara FROM newsnew WHERE sectionID LIKE '%ARC%' and ((codeID > '#lastcodeID#' and piclow = 'blanknews.gif') or (codeID < '#lastcodeID#')) ORDER BY codeID DESC LIMIT 8 SELECT codeID,heading,firstpara FROM newsnew WHERE sectionID LIKE '%DES%' and sectionID NOT LIKE '%ARC%' and ((codeID > '#lastcodeID#' and piclow = 'blanknews.gif') or (codeID < '#lastcodeID#')) ORDER BY codeID DESC LIMIT 3 SELECT codeID,heading FROM newsnew WHERE sectionID LIKE '%SAB%' 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 '%SAB%' 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 '%SAB%' 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 '%SAB%' 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 '%SAB%' 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 '%SAB%' 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 '%SAB%' 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 '%SAB%' 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 '%SAB%' 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 '%SAB%' 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 '%SAB%' 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 '%SAB%' 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,pic_shape FROM newsnew WHERE piclow not like 'blanknews.gif' and picno not like 'N' and sectionID not like '%SUP%' and sectionID LIKE "%SAB%" and world_region != 'A' ORDER BY codeID DESC limit 1,1 SELECT codeID,pic_shape FROM newsnew WHERE piclow not like 'blanknews.gif' and picno not like 'N' and sectionID not like '%SUP%' and sectionID LIKE "%SAB%" and world_region != 'A' ORDER BY codeID DESC limit 2,1 SELECT codeID,heading FROM newsnew WHERE sectionID LIKE '%HAF%' 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 Spa Business: Uniting the world of spas