SELECT company,companyID,count(*) as total
FROM jobsnew
WHERE active = 'y'
GROUP BY companyID
ORDER BY company
SELECT codeID,jobtitle,salary,location,company,co_logo
FROM jobsnew
WHERE (featuredjob = 'y' and active = 'y')
ORDER BY RAND()
SELECT * FROM profile WHERE sitecode like '%LO%' order by RAND()
select * from TPcatalogue where sitecodes like '%LO%' order by RAND() LIMIT 3
SELECT codeID,heading,first,location,company,storytype
FROM temp_opps
WHERE site = 'LO' and storytype = 'jobs' and codeID != 260483
ORDER BY tempID ASC
SELECT tempID,codeID,heading,first,location,company,storytype
FROM temp_opps
WHERE site = 'LO' and storytype != 'jobs'
ORDER BY tempID ASC
SELECT tempID,codeID,heading,first,location,company,storytype
FROM temp_opps
WHERE site = 'LO' and (storytype = 'brief1' or storytype = 'brief2')
ORDER BY tempID ASC
SELECT tempID
FROM temp_opps
WHERE site = 'LO' and storytype = 'uknews' and heading = 'hospitality'
ORDER BY tempID ASC
select codeID from temp_opps where site = 'LO' and storytype = 'LOfranchiseLink'
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
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);}Leisure Opportunities: Leisure Jobs, News and Training from Leisure Opportunities
#today#Leisure jobs, training & news, tenders & property for the leisure industry
