SELECT `shoes`.`id` FROM `shoes_to_colors` LEFT JOIN `shoes` ON `shoes_to_colors`.`shoes_id` = `shoes`.`id` LEFT JOIN `colors` ON `shoes_to_colors`.`colors_id` = `colors`.`id` WHERE `shoes`.`designers_id` = 5 AND `shoes`.`active` = 1 AND `shoes`.`seasons_id` = 43 GROUP BY `shoes`.`id` ORDER BY `shoes`.`sort`,`shoes`.`id`,`colors`.`sort_order` ASC Shoes

New Arrivals


Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /home/irisnyc/public_html/includes/classes/GenericModel.class.php on line 58


Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /home/irisnyc/public_html/includes/classes/GenericModel.class.php on line 58

AVAILABLE COLORS

<   >

© 2008 IRIS NYC, Inc. All Right Reserved

T: 212.645.0950
827 Washington St., at Little West 12th St.
New York, NY 10014