Home |  Log In
Latin Dance fashions

Home

Not looking for an average pair of ballroom dance shoes? Slip into a pair of these sleek, sexy boots, designed with the same comfort and versatility of Latin dance shoes. They're stylish, comfortable, and most importantly, perfect to dance in! Wear them with your favorite pair of jeans when you're going for a more casual look or as part of your dance costume for a performance. They're fun and practical!
1030 Got error 122 from storage engine
in:
[select p.products_image, pd.products_name, p.products_quantity, p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p2c.products_id = s.products_id where p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '238' order by p.products_sort_order, pd.products_name]