select category.name,product.* from product join category on product.category_id=category.id where product.category_id='3'
World's Most Affordable Neon Signs - Unbeatable Prices       Free Shipping Worldwide       Exclusive Quality & Personalized Craft
Search
3 $34.99
Search
Close
view all
Close
Quick Login
Close
SHIPPING! Continue shopping to add more products and receive free shipping
Go To Cart Check out