SELECT * FROM ( SELECT *, 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 ('truck loading machine') > 6 and eliteConfirmed = 1 and ( GCCElite='1') and b.Productid='19287' limit 0, 1000 } 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 eliteConfirmed = 1 and ( GCCElite='1') and b.Productid='19287' limit 0, 1000 } 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 ='7' and b.Productid='19287' and isElite = 0 AND EliteValidTillDate < '2025-06-26' limit 0, 1000 ) 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 ,14 as score from mstcompany_forsearch a inner join trncompanyprod_forsearch b on a.companyid=b.companyid where isElite=0 and a.Countryid ='7' and b.Productid='19287' limit 0, 1000 ) 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 , 12 as score from mstcompany_forsearch a inner join trncompanyprod_forsearch b on a.companyid=b.companyid where match (producttitle) against ('truck loading machine') > 6 and isElite = 0 and a.Countryid ='7' limit 0, 1000 ) 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 , 7 as score from mstcompany_forsearch a inner join trncompanyprod_forsearch b on a.companyid=b.companyid where a.Countryid ='7' and match(activities) AGAINST ('"truck loading machine"') > 7 limit 0, 1000 ) 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 , 6 as score from mstcompany_forsearch a inner join trncompanyprod_forsearch b on a.companyid=b.companyid where match(activities) AGAINST ('truck loading machine') > 15 limit 0, 1000 ) ) AS unioned ) AS ranked WHERE rn = 1 ORDER BY score desc ,EliteConfirmed desc , InternetTypeCode asc , c.productimagefilepath desc Truck Loading Machine Suppliers in Bahrain , Top Suppliers of Truck Loading Machine in Bahrain
TRUCK LOADING MACHINE in Bahrain
Bahrain Yellow Pages Online BAHRAIN YELLOW PAGESONLINE
Global Site for local Search

TRUCK LOADING MACHINE in Bahrain

Looking for TRUCK LOADING MACHINE in Bahrain ? Where to Get TRUCK LOADING MACHINE Suppliers in Bahrain?

Showing 1 - 32 of 32 Results found for the search TRUCK LOADING MACHINE in 0.04 sec.

JEMS SOLUTIONS COMPANY W.L.L

Truck Crane Supply, Repairs, Upgrades Co ...

JEMS ENGINEERING & TECHNICAL SOLUTIONS COMPANY W.L.L

Truck Cranes Supply & Services in Bahrai ...

TRUCK LOADING MACHINE from GURMEET MACHINERY CORPORATION

GURMEET MACHINERY CORPORATION

LATHE MACHINE

NOVA WEIGH INDUSTRIES

NOVA WEIGH INDUSTRIES

NOVA WEIGH INDUSTRIES

NOVA WEIGH INDUSTRIES

NOVA WEIGH INDUSTRIES

NOVA WEIGH INDUSTRIES

NOVA WEIGH INDUSTRIES

NOVA WEIGH INDUSTRIES

NOVA WEIGH INDUSTRIES

NOVA WEIGH INDUSTRIES

NOVA WEIGH INDUSTRIES

NOVA WEIGH INDUSTRIES

NOVA WEIGH INDUSTRIES

NOVA WEIGH INDUSTRIES

MICROTECH ENGG. CO.

BUSINESS AND TRADE ORGANIZATIONS

NOVA WEIGH INDUSTRIES

NOVA WEIGH INDUSTRIES

MICROTECH ENGG. CO.

ELECTRONIC WEIGHING SCALES

MICROTECH ENGG. CO.

BUSINESS AND TRADE ORGANIZATIONS


Page : 1 |