select * from products where pro_name like '%a%line%dresses%' or pro_des like '%a%line%dresses%'union all select * from products where (pro_name like '%a%' or pro_des like '%a%') or(pro_name like '%line%' or pro_des like '%line%') or(pro_name like '%dresses%' or pro_des like '%dresses%') and (pro_name not like '%a%line%dresses%' or pro_des not like '%a%line%dresses%')
Sweetheart Empire Lavender Ruched Chiffon Knee-length Dama Dress
One Shoulder Champagne Dama Dress with Handmade Flower and Belt
Lavender Beaded One Shoulder Chiffon Knee-length Dama Dress
One Shoulder Pleated Pink Chiffon Empire Brush Train Dama Dress
Elegant Hand Made Flowers Jacket in Brown
Champagne Long Sleeves Jacket With Lace
White and Hot Pink A-line Straps Mini-length Quince Dama Dresses
Purple A-line Sweetheart Floor-length Dama Dresses For Quinceanera
Royal Blue A-line One Shoulder Brush Train Cocktail Dresses For Dama
Aqua Blue A-line Halter Knee-length Formal Dresses For Dama with Bow
Lovely Taffeta Open Front Jacket in Champagne
Hot Pink Beading Lace Hot Sale Wraps for 2014
Simple Beading Hand Made Flower Wra
A-line Strapless ea-length Lace with Purple Bow Dresses For Damas
White and Pink A-line Scoop Mini-length Formal Dresses For Dama
Champagne A-line Sccop Mini-length Cocktail Dresses For Dama Ruched
Brown A-line Square Beading Bridesmaid Dama Dresses Knee-length
Cheap Beading Organza White Wraps for Summer
Lace Scoop Beading Organza Shawls for Spring
Elegant Light Blue Strapless Chiffon Formal Dresses for Dama
Baby Pink Sweetheart Quinceanera Gown with Appliques and Overskirt
Popular Purple Sweet Sixteen Dresses with Embroidery and Pick-ups
Custom Made Strapless Embroidery Quinceanera Dress with Overskirt
White Organza Beading Shawls for Summer
Top Selling Open Front Wraps in White
Exquisite Halter Embroidered Olive Green Dress for Quinceaneras
Wonderful Spring Green Paillette Sweet 16 Dress with Appliques
Modest Purple Sweetheart Appliques Quinceanera Gown with Jacket
2015 Instock Bridal Shawl with Open Front
Top Selling Shawl for Wedding Party