The most popular music device on the planet is the Apple iPod, which as expanded to include the Apple iPhone and Apple iPod Touch, sometimes called the iTouch, and just recently the Apple iPad tablet. But in order to get the most from these devices you need accessories: speakers, docks, chargers, wireless broadcasters, cases, cables and more. Cases provide protection from everyday use and accidental drops and spills. Chargers provide a constant charge or refill the battery's capacity. There are cables that split the audio for more than one listener, or attach the device to computers and stereos. FM transmitters broadcast your music to a nearby radio so you can enjoy your music while driving in the car. Docks and speakers let you listen to your music on larger systems and not just through headphones.
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 = "163" AND ps.popular > 0 ORDER BY c.lft ASC, ps.popular DESC