SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'header_extra_info' ORDER BY sort_order

SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'header_top' ORDER BY sort_order

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '178893' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'column_left' ORDER BY sort_order

Array
(
    [0] => Array
        (
            [layout_module_id] => 293
            [layout_id] => 3
            [code] => category
            [position] => column_left
            [sort_order] => 0
        )

)

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'column_right' ORDER BY sort_order

SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'content_top' ORDER BY sort_order

SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'content_bottom' ORDER BY sort_order

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '263531' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

0 item(s) - $0.00 USD Your shopping cart is empty!

• Cell Phones & Accessories
• Cell Phones & Accessories
• Cell Phones & Accessories
• Smart Watches

Smart Watches

Smart Watches from Cell Phones & Accessories are wearable devices that offer functionalities beyond traditional timekeeping. These devices are designed to be paired with smartphones to provide features such as notifications, fitness tracking, heart rate monitoring, and even contactless payments.

Smart Watches come in various styles and designs to suit different preferences and needs. They are a convenient and stylish way to stay connected and organized on the go.

---

There are no products to list in this category.

Continue