" ORDER BY product_desc DESC, `virtuemart_product_id` DESC LI...' at line 1 SQL=SELECT p.`virtuemart_product_id`, `l`.`product_name`,`l`.product_desc FROM `#__virtuemart_products` as p INNER JOIN `#__virtuemart_products_en_gb` as l using (`virtuemart_product_id`) LEFT JOIN `#__virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id` LEFT JOIN `#__virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` WHERE ( `pc`.`virtuemart_category_id` = 279 AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`="1" ) AND p.`virtuemart_product_id`!="2234" AND `l`.product_desc <= "

Hands Free Hoco L9 Original Series Earphones Stereo Lightning Λευκά με Μικρόφωνο και Πλήκτρο Λειτουργίας

 

Headphones for iPhone - HOCO L9. They provide high-quality, clear sound. Equipped with a built-in microphone.

Multi-task remote control allows you switch songs and adjust the volume.

Large internal speaker with a diameter of 14mm will satisfy the most demanding audio tastes.

TPE cord prevents tangling as well as provides flexibility and tensile strength.

Optimal cable length (1.2m) affects comfortable use and does not restrict movement while listening to music.

Built-in microphone supports call conversation.

Specification:
Cable: TPE
Length: 1.2 m
Weight: 10g
Speaker: 14 mm
Audio jack: Lighting

" ORDER BY product_desc DESC, `virtuemart_product_id` DESC LIMIT 1

Go Back Home