insert IGNORE into tmpmstcompany select a.CompanyID,CompanyName,Add1,Add2,Add3,city,a.CountryID,Pincode,TelStdCode,TelNo,FaxStdCode,FaxNo,email,website,Activities,isElite, eliteuserfilepath,EliteEnteredDate,EliteValidTillDate,producttitle,ProductDesc,productimagefilepath,eliteConfirmed ,CompanyProdID,countrynameco,InternetTypeCode,25 as score from mstcompany a inner join trncompanyprod b on a.companyid=b.companyid inner join mstproduct c on b.productid=c.productid where isElite=0 and b.Productid='4937' limit 0,1000
CHENNAI YELLOW PAGES ONLINE
and then add to homescreen