	Item Name-	Price
	Albert Nipon Suit Albert Nipon suit. Jacket has curved lapel and three buttons. Tiered hemline. Skirt has front and back darts and back zip. Skirt is approx. 26" long....	$215.00 Add:
	Boss Navy Two Button Wool Suit This is Janine's (Kate Burton) screen worn, hero navy two button wool with topstitch 'Boss' jacket, (size 8) and navy matching skirt 'Boss' skirt....	$249.99 Add:
	Costume National Black 2 Piece Suit Black wool "Costume National" single button 2 piece suit.	$199.99 Add:
	Dolce & Gabbana Charcoal Suit Charcoal wool (76%) / nylon (19%) / spandex (5%) tweed "Dolce & Gabbana" single button vest (size 38), charcoal wool (76%) / nylon (19%) / spandex...	$399.00 Add:
	Dolce & Gabbana Ivory Skirt Suit Ivory with gold buttons "Dolce and Gabbana" 5 button 2 piece skirt suit. (24" skirt length)	$99.99 Add:
	Dolce & Gabbana Skirt Suit Black w/ self embroidered design nylon (90%) / elastane(10%) "Dolce and Gabbana" 3 button 2 piece skirt suit.	$499.00 Add:
	Dolce & Gabbana Skirt Suit Charcoal virgin wool (90%) / acetate (10%) tweed w/ satin patches at top of skirt "Dolce & Gabbana" 3 button 2 piece skirt suit.	$299.99 Add:
	Dolce & Gabbana Suit Black w/ self embroidered design cotton (31%) / nylon (38%) / polyester (14%) / silk (17%) "Dolce and Gabbana" 5 button 2 piece skirt suit.	$499.00 Add:
	Dolce & Gabbana Woven Skirt Suit Multicolor blue and green woven silk "Dolce & Gabbana" buttonless 2 piece skirt suit. This suit is from Ally McBeal!	$499.99 Add:
	Gucci 2 Piece Skirt Suit Brown cotton (97%) / elastane (3%) "Gucci" single button 2 piece skirt suit.	$499.99 Add:

Displaying 1 to 10 (of 27 products)

1 2 3 [Next >>]

1054 Unknown column 'p.products_id' in 'on clause'
in:
[select distinct p.products_id, p.products_image, p.products_tax_class_id, p.products_date_added, p.products_price, pd.products_id, pd.products_url from zen_products p, zen_products_description pd left join zen_specials s on p.products_id = s.products_id, zen_products_to_categories p2c, zen_categories c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and pd.products_id = p.products_id and c.parent_id = '23' and p.products_status = 1 ]