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 ('grp cable tray') > 6 and ( AfricaElite='1') and b.Productid= 6376 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= 6376 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 ('"grp cable tray"') + 5 as score from mstcompany_forsearch a inner join trncompanyprod_forsearch b on a.companyid=b.companyid where match (producttitle) against ('"grp cable tray"') > 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= 6376 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 ('grp cable tray') + 2 as score from mstcompany_forsearch a inner join trncompanyprod_forsearch b on a.companyid=b.companyid where match (producttitle) against ('grp cable tray') > 6 and isElite=0 and a.Countryid ='49' and b.Productid= 6376 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 ('"grp cable tray"') as score from mstcompany_forsearch a inner join trncompanyprod_forsearch b on a.companyid=b.companyid where match (producttitle) against ('"grp cable tray"') > 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 ('grp cable tray') as score from mstcompany_forsearch a inner join trncompanyprod_forsearch b on a.companyid=b.companyid where match (producttitle) against ('grp cable tray') > 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 ('grp cable tray') > 15 limit 0, 250 ) ) AS unioned ) AS ranked WHERE rn = 1 ORDER BY score desc ,EliteConfirmed desc , InternetTypeCode asc , productimagefilepath desc Grp Cable Tray Suppliers in Namibia , Top Suppliers of Grp Cable Tray in Namibia
GRP CABLE TRAY in Namibia
Namibia Yellow Pages Online NAMIBIA YELLOW PAGESONLINE
Global Site for local Search

GRP CABLE TRAY in Namibia

Looking for GRP CABLE TRAY in Namibia ? Where to Get GRP CABLE TRAY Suppliers in Namibia?

Showing 1 - 31 of 31 Results found for the search GRP CABLE TRAY in 0.91 sec.

ELECTRAKING FZC

Cable Tray

BEST INDUSTRIES (FZE)

ALUMINIUM CABLE TRAY IN UAE

ONTIDES INTERNATIONAL FZC

Cable Tray Roller supplier in Oman

ARABIAN INTERNATIONAL INDUSTRIES LLC

ARABIAN INTERNATIONAL INDUSTRIES LLC

SARVASVA INDUSTRIES

SARVASVA INDUSTRIES

ROY ENGINEERING WORKS

ROY ENGINEERING WORKS

ROY ENGINEERING WORKS

ROY ENGINEERING WORKS

SHARDA CABLE TRAYS PVT LTD

SHARDA CABLE TRAYS PVT LTD

SHARDA CABLE TRAYS PVT. LTD.

SHARDA CABLE TRAYS PVT. LTD.

MDM.ENGINEERING AND TECHNOLOGIES

MDM.ENGINEERING AND TECHNOLOGIES

ROY ENGINEERING WORKS

ROY ENGINEERING WORKS

SUPER CABLE TRAY PVT. LTD.

SUPER CABLE TRAY PVT. LTD.

SHARDA CABLE TRAYS PVT LTD

SHARDA CABLE TRAYS PVT LTD

S.K.S INDUSTRIES PRIVATE LIMITED

S.K.S INDUSTRIES PRIVATE LIMITED

SAI SEEYA

SAI SEEYA

SHARDA CABLE TRAYS PVT. LTD.

SHARDA CABLE TRAYS PVT. LTD.

SUPER CABLE TRAY PVT. LTD.

SUPER CABLE TRAY PVT. LTD.

ARABIAN INTERNATIONAL INDUSTRIES LLC

ARABIAN INTERNATIONAL INDUSTRIES LLC

BRILLTECH ENGINEERS PVT. LTD.

BRILLTECH ENGINEERS PVT. LTD.

AM-TECH

AM-TECH

GRP CABLE TRAY from ORION CABLE TRAYS FZ-LLC

ORION CABLE TRAYS FZ-LLC

ORION CABLE TRAYS FZ-LLC

GRP CABLE TRAY from MEKANDEL TRADING CO LLC

MEKANDEL TRADING CO LLC

MEKANDEL TRADING CO LLC

GRP CABLE TRAY from BONN METAL CONSTRUCTION INDUSTRIES

BONN METAL CONSTRUCTION INDUSTRIES

BONN METAL CONSTRUCTION INDUSTRIES

TRANSDELTA INTERNATIONAL INDUSTRIES

TRANSDELTA INTERNATIONAL INDUSTRIES

POWERTRACK STEEL INDUSTRIES LLC

POWERTRACK STEEL INDUSTRIES LLC

POWERTRACK STEEL INDUSTRIES LLC

POWERTRACK STEEL INDUSTRIES LLC

POWERTRACK STEEL INDUSTRIES LLC

POWERTRACK STEEL INDUSTRIES LLC

POWERTRACK STEEL INDUSTRIES LLC

POWERTRACK STEEL INDUSTRIES LLC

POWERTRACK STEEL INDUSTRIES LLC

POWERTRACK STEEL INDUSTRIES LLC

POWERTRACK STEEL LTD

POWERTRACK STEEL LTD


Page : 1 |