SELECT CompanyID, CompanyName, Add1, Add2, Add3, CityNameCo , CountryID, Pincode, TelStdCode, TelNo, FaxStdCode, FaxNo, email, website, Activities, isElite, eliteuserfilepath, EliteEnteredDate, EliteValidTillDate, producttitle, ProductDesc, productimagefilepath, eliteConfirmed, CompanyProdID , CountryNameCo , InternetTypeCode, brandimage, brandname, countryshortcodeco , score, '' as CategoryList , dontshowincountries, Google_store_applink, Apple_store_applink,price,pricecurrency,productrating,whatsappnoforchat FROM ( SELECT CompanyID, CompanyName, Add1, Add2, Add3, CityNameCo , CountryID, Pincode, TelStdCode, TelNo, FaxStdCode, FaxNo, email, website, Activities, isElite, eliteuserfilepath, EliteEnteredDate, EliteValidTillDate, producttitle, ProductDesc, productimagefilepath, eliteConfirmed, CompanyProdID , CountryNameCo , InternetTypeCode, brandimage, brandname, countryshortcodeco , score, '' as CategoryList , dontshowincountries, Google_store_applink, Apple_store_applink,price,pricecurrency,productrating,whatsappnoforchat , ROW_NUMBER() OVER (PARTITION BY CompanyID ORDER BY score DESC, eliteConfirmed DESC, InternetTypeCode ASC) AS rn FROM ( ( select a.CompanyID,CompanyName,Add1,Add2,Add3,CityNameCo,a.CountryID,Pincode,TelStdCode,TelNo,FaxStdCode,FaxNo,email,website,Activities,isElite, eliteuserfilepath,EliteEnteredDate,EliteValidTillDate,producttitle,ProductDesc,productimagefilepath,eliteConfirmed ,CompanyProdID, CountryNameCo,InternetTypeCode,'' as brandimage,'' as brandname,countryshortcodeco,dontshowincountries,Google_store_applink,Apple_store_applink,price,pricecurrency, productrating,whatsappnoforchat , 65 as score from mstcompany_forsearch a inner join trncompanyprod_forsearch b on a.companyid=b.companyid where match (producttitle) against ('htd belts') > 6 and ( AfricaElite='1') and b.Productid=10639 limit 0, 250 ) UNION ALL ( select a.CompanyID,CompanyName,Add1,Add2,Add3,CityNameCo,a.CountryID,Pincode,TelStdCode,TelNo,FaxStdCode,FaxNo,email,website,Activities,isElite, eliteuserfilepath,EliteEnteredDate,EliteValidTillDate,producttitle,ProductDesc,productimagefilepath,eliteConfirmed ,CompanyProdID, CountryNameCo,InternetTypeCode,'' as brandimage,'' as brandname,countryshortcodeco,dontshowincountries,Google_store_applink,Apple_store_applink,price,pricecurrency, productrating,whatsappnoforchat , 50 as score from mstcompany_forsearch a inner join trncompanyprod_forsearch b on a.companyid=b.companyid where ( AfricaElite='1') and b.Productid=10639 limit 0, 250 ) UNION ALL ( select a.CompanyID,CompanyName,Add1,Add2,Add3,CityNameCo,a.CountryID,Pincode,TelStdCode,TelNo,FaxStdCode,FaxNo,email,website,Activities,isElite, eliteuserfilepath,EliteEnteredDate,EliteValidTillDate,producttitle,ProductDesc,productimagefilepath,eliteConfirmed ,CompanyProdID, CountryNameCo,InternetTypeCode,'' as brandimage,'' as brandname,countryshortcodeco,dontshowincountries,Google_store_applink,Apple_store_applink,price,pricecurrency, productrating,whatsappnoforchat , match (producttitle) against ('"htd belts"') + 5 as score from mstcompany_forsearch a inner join trncompanyprod_forsearch b on a.companyid=b.companyid where match (producttitle) against ('"htd belts"') > 10 and ( AfricaElite='1') limit 0, 250 ) UNION ALL ( select a.CompanyID,CompanyName,Add1,Add2,Add3,CityNameCo,a.CountryID,Pincode,TelStdCode,TelNo,FaxStdCode,FaxNo,email,website,Activities,isElite, eliteuserfilepath,EliteEnteredDate,EliteValidTillDate,producttitle,ProductDesc,productimagefilepath,eliteConfirmed ,CompanyProdID, CountryNameCo,InternetTypeCode,'' as brandimage,'' as brandname,countryshortcodeco,dontshowincountries,Google_store_applink,Apple_store_applink,price,pricecurrency, productrating,whatsappnoforchat , 15 as score from mstcompany_forsearch a inner join trncompanyprod_forsearch b on a.companyid=b.companyid where a.Countryid ='49' and b.Productid=10639 and isElite = 0 AND EliteValidTillDate < '2025-06-28' limit 0, 250 ) UNION ALL ( select a.CompanyID,CompanyName,Add1,Add2,Add3,CityNameCo,a.CountryID,Pincode,TelStdCode,TelNo,FaxStdCode,FaxNo,email,website,Activities,isElite, eliteuserfilepath,EliteEnteredDate,EliteValidTillDate,producttitle,ProductDesc,productimagefilepath,eliteConfirmed ,CompanyProdID, CountryNameCo,InternetTypeCode,'' as brandimage,'' as brandname,countryshortcodeco,dontshowincountries,Google_store_applink,Apple_store_applink,price,pricecurrency, productrating,whatsappnoforchat , match (producttitle) against ('htd belts') + 2 as score from mstcompany_forsearch a inner join trncompanyprod_forsearch b on a.companyid=b.companyid where match (producttitle) against ('htd belts') > 6 and isElite=0 and a.Countryid ='49' and b.Productid=10639 limit 0, 250 ) UNION ALL ( select a.CompanyID,CompanyName,Add1,Add2,Add3,CityNameCo,a.CountryID,Pincode,TelStdCode,TelNo,FaxStdCode,FaxNo,email,website,Activities,isElite, eliteuserfilepath,EliteEnteredDate,EliteValidTillDate,producttitle,ProductDesc,productimagefilepath,eliteConfirmed ,CompanyProdID, CountryNameCo,InternetTypeCode,'' as brandimage,'' as brandname,countryshortcodeco,dontshowincountries,Google_store_applink,Apple_store_applink,price,pricecurrency, productrating,whatsappnoforchat , match (producttitle) against ('"htd belts"') as score from mstcompany_forsearch a inner join trncompanyprod_forsearch b on a.companyid=b.companyid where match (producttitle) against ('"htd belts"') > 6 and isElite = 0 and a.Countryid ='49' limit 0, 250 ) UNION ALL ( select a.CompanyID,CompanyName,Add1,Add2,Add3,CityNameCo,a.CountryID,Pincode,TelStdCode,TelNo,FaxStdCode,FaxNo,email,website,Activities,isElite, eliteuserfilepath,EliteEnteredDate,EliteValidTillDate,producttitle,ProductDesc,productimagefilepath,eliteConfirmed ,CompanyProdID, CountryNameCo,InternetTypeCode,'' as brandimage,'' as brandname,countryshortcodeco,dontshowincountries,Google_store_applink,Apple_store_applink,price,pricecurrency, productrating,whatsappnoforchat , match (producttitle) against ('htd belts') as score from mstcompany_forsearch a inner join trncompanyprod_forsearch b on a.companyid=b.companyid where match (producttitle) against ('htd belts') > 6 and isElite = 0 and a.Countryid ='49' limit 0, 250 ) UNION ALL ( select a.CompanyID,CompanyName,Add1,Add2,Add3, CityNameCo,a.CountryID,Pincode,TelStdCode,TelNo,FaxStdCode,FaxNo,email,website,Activities,isElite, eliteuserfilepath,'' as EliteEnteredDate,'' as EliteValidTillDate,'' as producttitle,'' as ProductDesc,'' as productimagefilepath,'0','' as CompanyProdID,CountryNameCo,'' as InternetTypeCode,'' as brandimage,'' as brandname,countryshortcodeco,dontshowincountries,Google_store_applink,Apple_store_applink,'' as price,'' as pricecurrency,'' as productrating,whatsappnoforchat , 6 as score from mstcompany_forsearch a where match(activities) AGAINST ('htd belts') > 15 limit 0, 250 ) ) AS unioned ) AS ranked WHERE rn = 1 ORDER BY score desc ,EliteConfirmed desc , InternetTypeCode asc , productimagefilepath desc Htd Belts Suppliers in Namibia , Top Suppliers of Htd Belts in Namibia
HTD BELTS in Namibia
Namibia Yellow Pages Online NAMIBIA YELLOW PAGESONLINE
Global Site for local Search

HTD BELTS in Namibia

Looking for HTD BELTS in Namibia ? Where to Get HTD BELTS Suppliers in Namibia?

Showing 1 - 8 of 8 Results found for the search HTD BELTS in 0.84 sec.

SPN SPARE PARTS NETWORK (LLC)

belts and bearings in uae, belts and bea ...

BLACK BELT

BLACK BELT

SKY BELT ELECTROMECHANICAL CONT LLC

SKY BELT ELECTROMECHANICAL CONT LLC

CONTINENTAL CONVEYORS PVT. LTD.,

CONTINENTAL CONVEYORS PVT. LTD.,

HTD BELTS from JAMEA AL ANWAR TRADING

JAMEA AL ANWAR TRADING

JAMEA AL ANWAR TRADING

PIX TRANSMISSIONS LIMITED

PIX TRANSMISSIONS LIMITED

HTD BELTS from ARIHANT BELTING PVT LTD

ARIHANT BELTING PVT LTD

ARIHANT BELTING PVT LTD

AG BELTING PVT LTD

AG BELTING PVT LTD


Page : 1 |