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

SELECT * FROM oc_layout_module WHERE layout_id = '13' 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 = '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)

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

Array
(
)

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

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

SELECT * FROM oc_layout_module WHERE layout_id = '13' 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)

Search - Tag - COUNTRY

PhoenixLiquidation

Search

Search Criteria

Search in subcategories

Search in product descriptions

Products meeting the search criteria

Product Compare (0)

Sort By:

Show:

Country Roads: The Very Best of John Denver (Delta, 1999, CD), Easy Listening

Country Roads: The Very Best of John Denver (Delta, 1999, CD), Easy Listening

.secondary-list-item { list-style-type: none; padding-left: 3em; text-indent: -1em; }Country Roads: ..

$2.38 USD

Fuse Extra Large Universal Phone Case With Clip Mossy Oak Break-up Country

Fuse Extra Large Universal Phone Case With Clip Mossy Oak Break-up Country

Description :Title : Fuse Extra Large Universal Phone Case With Clip Mossy Oak Break-up CountryModel..

$11.16 USD

Shania Twain: Come On Over (Mercury Records 1997) - Country Rock Album CD

Shania Twain: Come On Over (Mercury Records 1997) - Country Rock Album CD

.secondary-list-item { list-style-type: none; padding-left: 3em; text-indent: -1em; }Shania Twain: C..

$6.90 USD

Stand Still Look Pretty (The Wreckers, Maverick, 2006), Audio CD, Folk/Country

Stand Still Look Pretty (The Wreckers, Maverick, 2006), Audio CD, Folk/Country

.secondary-list-item { list-style-type: none; padding-left: 3em; text-indent: -1em; }Stand Still Loo..

$2.04 USD

The Little Bean Cookbook: Wholesome Recipes From A Country Larder (1996 Edition)

The Little Bean Cookbook: Wholesome Recipes From A Country Larder (1996 Edition)

.secondary-list-item { list-style-type: none; padding-left: 3em; text-indent: -1em; }The Little Bean..

$4.35 USD

TOWN AND COUNTRY (DVD) CANADIAN RELEASE

TOWN AND COUNTRY (DVD) CANADIAN RELEASE

Description :Title : TOWN AND COUNTRY (DVD) CANADIAN RELEASEModel : NONEBrand : NEW LINE CINEMAColor..

$1.85 USD

Unchained Melody: The Early Years (LeAnn Rimes, 1997, 1 Disc), Country Music CD

Unchained Melody: The Early Years (LeAnn Rimes, 1997, 1 Disc), Country Music CD

.secondary-list-item { list-style-type: none; padding-left: 3em; text-indent: -1em; }Unchained Melod..

$1.93 USD

Up (Shania Twain, Mercury, 2002, 2 Disc Set), Country Pop Versions

Up (Shania Twain, Mercury, 2002, 2 Disc Set), Country Pop Versions

.secondary-list-item { list-style-type: none; padding-left: 3em; text-indent: -1em; }Up (Shania Twai..

$2.11 USD

$You Can\'t Resist (Patricia Conroy, Intersound, 1994, Country Music)$

You Can\'t Resist (Patricia Conroy, Intersound, 1994, Country Music)

.secondary-list-item { list-style-type: none; padding-left: 3em; text-indent: -1em; }You Can\'t Resi..

$3.08 USD

Showing 1 to 9 of 9 (1 Pages)