select p.* from products p, category c where p.cat_id = '4' and p.cat_id = c.catId and p.active = 1 and c.catStatus = 1 group by p.id order by p.sort_order asc, p.product_name asc johnnyswatches - Catalogue

paypal   master   visa  
https://www.facebook.com/JohnnysWatches?fref=tck   Youtube  

© 2012Johnny's Watches.com
Powerd by Cyberjee.com

 

Home > Catalogue > Johnnys Diamond Women
Johnnys  Diamond Women :: Johnnys  Diamond Women :: Click to View Details
Price: $ 39.95
Qty:
Johnnys Diamond Women :: Johnny Diamond Women :: Click to View Details
Price: $ 39.00
Qty: