About Headphones
If you want to lose yourself in your music by eliminating the noise around you, there is no better way than to use headphones. Headphones can be used in both professional settings and non-professional settings. Noise canceling headphones are a great choice for traveling because they allow you to hear only what is coming from your headphones, canceling all other background noise. In ear headphones are a great choice for athletes. With the new technologies in ear headphones have been built to fit comfortably and to stay put. No more worrying about your headphone falling out anymore.
SELECT ps.popular, p.productid, p.modelname, p.filename , c.category, c.filename as cfilename, c.catid , pm.filename as mfilename, pc.standAloneName FROM yew.products_bycat_index bci LEFT JOIN yew.product_categories c ON bci.catid = c.catid LEFT JOIN yew.products p ON bci.productid = p.productid LEFT JOIN yew.products_sort ps ON p.productid = ps.productid LEFT JOIN yew.product_manufacturers pm ON p.manufacturerid = pm.manufacturerid WHERE c.parent = "48" AND ps.popular > 0 ORDER BY c.lft ASC, ps.popular DESC