Long Salsa Dresses
What do you look for in the perfect Salsa dress? Style, movement, comfort, or versatility? We're sure you'll agree that all of these factors are equally important when it comes to Salsa dancewear. Our collection of discounted dancewear and dresses has been selected and approved by professional dancers who understand and appreciate the importance of fine dance wear.
Looking for a Salsa dress to wear to your favorite nightclub? A Tango dress for the upcoming Milonga? A ballroom dress for this weekend's ballroom social? Don't forget to take a look at our selection of ballroom dance shoes to pair with your favorite Latin ballroom dress! We guarantee that our Latin dance dresses will allow you to look and feel your best on the dance floor!
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 = '177' order by p.products_sort_order, pd.products_name]