Your Latin dancewear wardrobe wouldn't be complete without the perfect Latin dance skirt! Flowing fabrics and form-fitting, sexy styles make our Latin skirts ideal for putting together the perfect dance outfit for your night out dancing. Create a dance costume for your upcoming performance or competition or simply wear them to dance class.
Keep in mind that you can mix-and-match them with our selection of pretty dance tops. Choose from our ballroom dancewear selection of beautiful ballroom skirts, sexy Salsa skirts, elegant Tango skirts, and comfortable practice dance skirts. No matter how you wear them, the style and movement of our Latin dance skirts will feel great and make heads turn when you're out on the dance floor! Don't forget that our discounted dancewear store offers discounted dance shoes at very favorable prices as well, so check them out and pair them with your favorite Latin dance skirt!
1030 Got error 122 from storage engine
[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 = '165' order by p.products_sort_order, pd.products_name]