select email from subscriptions where subID = "#URL.subID#" SELECT * FROM profile WHERE codeID = #URL.codeID# INSERT INTO profile_counter (sitecode, viewdate,company, linktype, companyID, profileID,SPIData,IPaddress,emailaddress) VALUES ('#URL.sitecode#','#today#','#Recordset1.coname#','#URL.linktype#','#Recordset1.companyID#','#Recordset1.codeID#',"#SPIData#","#userIP#","#emailaddress#") SELECT * FROM newsnew WHERE codeID = #URL.codeID# SELECT newscodeID FROM newsTRACKER WHERE codeID = #URL.codeID# SELECT * FROM newsnew WHERE newscodeID = #newsfind.newscodeID# INSERT INTO news_counter (sitecode, datestamp, newsheading, newscode, companyID, author, date_ofinput,SPIData,IPaddress,emailaddress) VALUES ('#URL.sitecode#','#today#','#Recordset1.heading#','#Recordset1.newscodeID#','','#Recordset1.author#','#Recordset1.authordate#',"#SPIData#","#userIP#","#emailaddress#") SELECT jobcodeID FROM jobsnew WHERE codeID = #URL.codeID# SELECT * FROM jobsnew WHERE jobcodeID = '#Recordset11.jobcodeID#' and active = 'y' order by codeID desc limit 1 SELECT * FROM jobsnew WHERE jobcodeID = '#Recordset11.jobcodeID#' order by codeID desc limit 1 INSERT INTO jobs_counter (sitecode, datestamp,jobtitle, JOBcode, companyID, jobcompany, joblocation, date_ofinput,jobcodeid,SPIData,IPaddress,emailaddress) VALUES ('#URL.sitecode#','#today#','#Recordset1.jobtitle#','#Recordset1.codeID#','#Recordset1.companyID#','#Recordset1.company#','#Recordset1.location#','#Recordset1.authordate#','#Recordset1.jobcodeID#',"#SPIData#","#userIP#","#emailaddress#") select microsite from jobscompanies where companyID = '#recordset1.companyID#' SELECT * FROM profile WHERE codeID = #URL.codeID# INSERT INTO profile_counter (sitecode, viewdate,company, linktype, companyID, profileID,SPIData,IPaddress,emailaddress) VALUES ('#URL.sitecode#','#today#','#Recordset1.coname#','#URL.linktype#','#Recordset1.companyID#','#Recordset1.codeID#',"#SPIData#","#userIP#","#emailaddress#") SELECT * FROM training WHERE codeID = #URL.codeID# INSERT INTO train_counter (sitecode,datestamp,company,traincode,companyID,date_ofinput,SPIData,IPaddress,emailaddress) VALUES ('#URL.sitecode#','#today#','#Recordset1.company#','#Recordset1.codeID#','#Recordset1.companyID#','#Recordset1.date_on#',"#SPIData#","#userIP#","#emailaddress#") SELECT * FROM training WHERE codeID = #URL.codeID# INSERT INTO train_counter (sitecode, datestamp,company, traincode, companyID, date_ofinput,SPIData,IPaddress,emailaddress) VALUES ('#URL.sitecode#','#today#','#Recordset1.company#','#Recordset1.codeID#','#Recordset1.companyID#','#Recordset1.date_on#',"#SPIData#","#userIP#","#emailaddress#") SELECT * FROM propertylist WHERE codeID = #URL.codeID# INSERT INTO prop_counter (sitecode,datestamp,propheading,propcode,companyID,prop_or_tend,date_ofinput,SPIData,IPaddress,emailaddress,company) VALUES ('#URL.sitecode#','#today#','#Recordset1.heading#','#Recordset1.codeID#','#Recordset1.companyID#','#Recordset1.type#','#Recordset1.dateofinput#',"#SPIData#","#userIP#","#emailaddress#",'#Recordset1.company#')