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 ('godrej hand pallet truck') > 6 and eliteConfirmed = 1 and ( GCCElite='1') and b.Productid='19496' 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 eliteConfirmed = 1 and ( GCCElite='1') and b.Productid='19496' 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 , 40 as score from mstcompany_forsearch a inner join trncompanyprod_forsearch b on a.companyid=b.companyid where match (producttitle) against ('"godrej hand pallet truck"') > 10 and eliteConfirmed = 1 and ( GCCElite='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 ='24' and b.Productid='19496' and isElite = 0 AND EliteValidTillDate < '2025-06-27' 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 ('godrej hand pallet truck') + 2 as score from mstcompany_forsearch a inner join trncompanyprod_forsearch b on a.companyid=b.companyid where match (producttitle) against ('godrej hand pallet truck') > 6 and isElite=0 and a.Countryid ='24' and b.Productid='19496' 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 ('"godrej hand pallet truck"') as score from mstcompany_forsearch a inner join trncompanyprod_forsearch b on a.companyid=b.companyid where match (producttitle) against ('"godrej hand pallet truck"') > 6 and isElite = 0 and a.Countryid ='24' 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 ('godrej hand pallet truck') as score from mstcompany_forsearch a inner join trncompanyprod_forsearch b on a.companyid=b.companyid where match (producttitle) against ('godrej hand pallet truck') > 6 and isElite = 0 and a.Countryid ='24' 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 , 7 as score from mstcompany_forsearch a inner join trncompanyprod_forsearch b on a.companyid=b.companyid where a.Countryid ='24' and match(activities) AGAINST ('"godrej hand pallet truck"') > 10 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 , 6 as score from mstcompany_forsearch a inner join trncompanyprod_forsearch b on a.companyid=b.companyid where match(activities) AGAINST ('godrej hand pallet truck') > 15 limit 0, 250 ) ) AS unioned ) AS ranked WHERE rn = 1 ORDER BY score desc ,EliteConfirmed desc , InternetTypeCode asc , productimagefilepath desc Godrej Hand Pallet Truck Suppliers in Oman , Top Suppliers of Godrej Hand Pallet Truck in Oman
GODREJ HAND PALLET TRUCK in Oman
Oman Yellow Pages Online OMAN YELLOW PAGESONLINE
Global Site for local Search

GODREJ HAND PALLET TRUCK in Oman

Looking for GODREJ HAND PALLET TRUCK in Oman ? Where to Get GODREJ HAND PALLET TRUCK Suppliers in Oman?

Showing 1 - 34 of 34 Results found for the search GODREJ HAND PALLET TRUCK in 0.96 sec.

ADAMS TOOL HOUSE

verified
Pallet Truck 2.0 Ton

Chat on Whats App Whatsapp

ACE CENTRO ENTERPRISES

verified
POWERED HAND TRUCK FOR PALLET STACKING

Chat on Whats App Whatsapp

SPARK TECHNICAL SUPPLIES FZE

verified
Hydraulic Hand Pallet Truck in UAE

ADEX INTL

verified
HAND PALLET TRUCK IN UAE

Chat on Whats App Whatsapp

A ONE TOOLS TRADING LLC

verified
Hydraulic Hand Pallet Truck 2500 kg

Chat on Whats App Whatsapp

EXCEL TRADING LLC (OPC)

verified
HAND PALLET TRUCK

Chat on Whats App Whatsapp

WORLD WIDE TRADERS

HAND PALLET TRUCK SUPPLIER IN UAE

TEEJAN EQUIPMENT LLC

WEIGHING SCALE HAND PALLET TRUCK

CARMEL TRADING & SERVICE SPC

TIPPER TRUCK/DUMP TRUCK FOR SALE IN OMAN ...

PALLETCO LLC

PLASTIC PALLET

OMAN WORLD

TRUCK DEALERS

GLOBAL FMS

TRUCK EQUIPMENT & PARTS

OMAN WORLD

TRUCK EQUIPMENT & PARTS


Page : 1 |