Mechanical Parts & Spares
Manufacturers, Suppliers & Exporters of Mechanical Components & Spare Parts
TradeXL is a directory of mechanical components and mechanical spare parts manufacturers, suppliers and exporters. We bring the buyers and sellers together and help them find most reliable and feasible choice to find the best products.
Manufacturers, suppliers & exporters of mechanical parts and mechanical components listed here deal in a wide range of products including gaskets, dies, valves, bearings, seals, gears and assembling services.
To increase the business leads for mechanical components or Mechanical parts, add your products at Tradexl under the mechanical components & Spare Parts category and get the enquiries on daily basis.
If you are a buyer of mechanical parts or mechanical components, submit your buy requirments on this page or can send your enquiry directly to Machincal Components & Spare Parts Manufacturers, Suppliers & Exporters.
Get details of the suppliers and manufacturers by filling the enquiry form. You can also contact the desired company directly by sending an email or SMS.
Database Error
A Database Error Occurred
Error Number: 1055
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'tradexl_sitev1jan15.product_tbl.p_user_Id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SELECT `product_tbl`.`p_user_Id`, `product_by_user`.`product_By_User_Name`, `product_by_user`.`product_By_User_url`
FROM `product_tbl`
JOIN `product_by_user` ON `product_by_user`.`product_By_User_Id`=`product_tbl`.`p_user_Id`
JOIN `user_registration` ON `user_registration`.`user_Id`=`product_by_user`.`user_Id`
JOIN `city` ON `city`.`city_id`=`user_registration`.`user_City`
JOIN `product_meta` ON `product_meta`.`prod_url`=`product_by_user`.`product_By_User_url`
WHERE `product_tbl`.`p_cat_Id` = '13'
AND `product_tbl`.`p_subcat_Id` = '265'
AND `product_by_user`.`status_Flag` = 'Accepted'
AND `user_registration`.`live_status` = 1
AND `product_meta`.`status` = 1
GROUP BY `product_by_user`.`product_By_User_url`
LIMIT 5
Filename: models/Common_model.php
Line Number: 131