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 = '15032' 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)
Cell Phones & Accessories
PhoenixLiquidation

  • Your shopping cart is empty!





Cell Phones & Accessories

Refine Search

Product Compare (0)
Tzumi 5650WM 5W Wireless Soft Charging Pad IPhone 8 And UP + Samsung Galaxy
Tzumi 5650wm 5w Wireless Soft Charging Pad Iphone 8 And Up And Samsung Galaxy

Tzumi 5650wm 5w Wireless Soft Charging Pad Iphone 8 And Up And Samsung Galaxy

(Grade A) NEW without original box or with open/repackaged box

Our Price: $4.16 USD

Tzumi Electronics 3762WM Tripod With Shutter Remote, Black

Tzumi Electronics 3762WM Tripod With Shutter Remote, Black

(Grade A) NEW without original box or with open/repackaged box

Our Price: $4.16 USD

Urban Armor Gear Composite Case With Hd Screen Protector For Samsung Galaxy S4
Urban Armor Gear Oem Hybrid Case Military Grade For Samsung Galaxy S6 White
Ventev Rapid Charge Qualcomm 2.0 Usb Charging Hub Rq600 - 6 Devices

Ventev Rapid Charge Qualcomm 2.0 Usb Charging Hub Rq600 - 6 Devices

Brand New

Our Price: $17.74 USD

Verizon 6-Pack Tempered Glass Screen Protector for Samsung Galaxy Note 4
Verizon Privacy Protector For IPhone 5 5s 5c SE - Scratch-Resistant Alpha Glass
Verizon Swivel Belt Clip Holster Vzw771hol Casio Hitachi G'zone Commando (c771)
Zagg Gs6hxc-f00 Invisibleshield Hdx Screen Protector For Samsung Galaxy S6

Zagg Gs6hxc-f00 Invisibleshield Hdx Screen Protector For Samsung Galaxy S6

(Grade A) NEW without original box or with open/repackaged box

Our Price: $8.16 USD

Zagg Invisible Shield HD Screen Protector for Samsung Galaxy S4 (Pack of 3)
Zagg Invisibleshield Screen Protector For Samsung Galaxy S III - Clear SAMGALS3E
ZAGG IPPGLC-F00 InvisibleShield Glass Screen Protector For IPhone 6+/6s+/7+/8+

ZAGG IPPGLC-F00 InvisibleShield Glass Screen Protector For IPhone 6+/6s+/7+/8+

(Grade A) NEW without original box or with open/repackaged box

Our Price: $4.06 USD

Zagg Scratch Resistant Screen Protector Military Grade For Htc One (m8) - Clear
Showing 376 to 389 of 389 (26 Pages)