select count(*) as count from parts, businesses where (part_name like '%pump%' or part_number like '%pump%' or description like '%pump%' or manufacturer like '%pump%') AND parts.business_id = businesses.business_id AND businesses.suspended = 'n' AND parts.category_id =1 AND active=1 ORDER BY part_name asc
select part_id, part_name, part_number, manufacturer, description, salvage_price, wholesale_price, list_price, quantity, city, state from parts, businesses where (part_name like '%pump%' or part_number like '%pump%' or description like '%pump%' or manufacturer like '%pump%') AND parts.business_id = businesses.business_id AND businesses.suspended = 'n' AND parts.category_id =1 AND active=1 ORDER BY part_name asc LIMIT 100, 100
select count(*) as count from parts, businesses where (part_name like '%pump%' or part_number like '%pump%' or description like '%pump%' or manufacturer like '%pump%') AND parts.business_id = businesses.business_id AND businesses.suspended = 'n' AND parts.category_id =2 AND active=1 ORDER BY
select part_id, part_name, part_number, manufacturer, description, salvage_price, wholesale_price, list_price, quantity, city, state from parts, businesses where (part_name like '%pump%' or part_number like '%pump%' or description like '%pump%' or manufacturer like '%pump%') AND parts.business_id = businesses.business_id AND businesses.suspended = 'n' AND parts.category_id =2 AND active=1 ORDER BY
select count(*) as count from parts, businesses where (part_name like '%pump%' or part_number like '%pump%' or description like '%pump%' or manufacturer like '%pump%') AND parts.business_id = businesses.business_id AND businesses.suspended = 'n' AND parts.category_id =3 AND active=1 ORDER BY part_name asc
select part_id, part_name, part_number, manufacturer, description, salvage_price, wholesale_price, list_price, quantity, city, state from parts, businesses where (part_name like '%pump%' or part_number like '%pump%' or description like '%pump%' or manufacturer like '%pump%') AND parts.business_id = businesses.business_id AND businesses.suspended = 'n' AND parts.category_id =3 AND active=1 ORDER BY part_name asc LIMIT 100, 100
select count(*) as count from parts, businesses where (part_name like '%pump%' or part_number like '%pump%' or description like '%pump%' or manufacturer like '%pump%') AND parts.business_id = businesses.business_id AND businesses.suspended = 'n' AND parts.category_id =4 AND active=1 ORDER BY part_name asc
select part_id, part_name, part_number, manufacturer, description, salvage_price, wholesale_price, list_price, quantity, city, state from parts, businesses where (part_name like '%pump%' or part_number like '%pump%' or description like '%pump%' or manufacturer like '%pump%') AND parts.business_id = businesses.business_id AND businesses.suspended = 'n' AND parts.category_id =4 AND active=1 ORDER BY part_name asc LIMIT 100, 100You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
select count(*) as count from parts, businesses where (part_name like '%pump%' or part_number like '%pump%' or description like '%pump%' or manufacturer like '%pump%') AND parts.business_id = businesses.business_id AND businesses.suspended = 'n' AND parts.category_id =5 AND active=1 ORDER BY You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
select part_id, part_name, part_number, manufacturer, description, salvage_price, wholesale_price, list_price, quantity, city, state from parts, businesses where (part_name like '%pump%' or part_number like '%pump%' or description like '%pump%' or manufacturer like '%pump%') AND parts.business_id = businesses.business_id AND businesses.suspended = 'n' AND parts.category_id =5 AND active=1 ORDER BY
select count(*) as count from parts, businesses where (part_name like '%pump%' or part_number like '%pump%' or description like '%pump%' or manufacturer like '%pump%') AND parts.business_id = businesses.business_id AND businesses.suspended = 'n' AND active=1 ORDER BY
select part_id, part_name, part_number, manufacturer, description, salvage_price, wholesale_price, list_price, quantity, city, state from parts, businesses where (part_name like '%pump%' or part_number like '%pump%' or description like '%pump%' or manufacturer like '%pump%') AND parts.business_id = businesses.business_id AND businesses.suspended = 'n' AND active=1 ORDER BY
Search Results
Your search has returned items in Appliances and HVAC, items in Industrial Controls, items in Small Engines, items in Other, and items in Geek Stuff.
