select * from products where pro_name like '%Train%dresses%' or pro_des like '%Train%dresses%'union all select * from products where (pro_name like '%Train%' or pro_des like '%Train%') or(pro_name like '%dresses%' or pro_des like '%dresses%') and (pro_name not like '%Train%dresses%' or pro_des not like '%Train%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

Baby Pink Empire One Shoulder Brush Train Formal Dresses For Dama

Royal Blue A-line One Shoulder Brush Train Cocktail Dresses For Dama

Light Yellow Sweetheart Brush Train 15 Dresses For Damas Beaded

Royal Blue Straps Brush Train Chiffon Ruched 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

Exquisite Halter Embroidered Olive Green Dress for Quinceaneras

Aqua Sweetheart Brush Train Quince Dresses with Hand Made Flowers

Wonderful Spring Green Paillette Sweet 16 Dress with Appliques

Modest Purple Sweetheart Appliques Quinceanera Gown with Jacket

Court Train Quinceanera Dresses in Apple Green with Taffeta

Chapel Train Burgundy Pick-ups Appliques Sweet 16 Dresses

A-line Sweetheart Embroidery and Beading Baby Blue Sweet 15 Dresses

Quinceanera Dress Strapless with Embroidery and Beading in Baby Blue

Baby Pink Sweetheart Quinceanera Dress with Beaded Sweetheart

A-line Strapless Appliques Paillette Sweet Sixteen Dresses in Blue

Aqua Blue Sweetheart Appliques Lace up Quinceanera Dresses

Ruching Sweetheart Baby Pink Quinceanera Dress with Layered Ruffles

Dark Purple Brush Train Beading and Ruching 2013 Sweet 16 Dresses

Dark Purple Brush Train Beading and Ruffles Sweet Sixteen Dresses

Brush Train and Boning Details Hot Pink Princess Beading Dresses 15

Hot Pink Quinceanera Dress Hand Made Flowers With Embroidery

Appliques Layered Ruffles Colorful Dresses 15 Wear For Graduation

Long Sleeves and Appliques Decorated Quinceanera Dress in Fushsia

Halter Top and Pick-ups Quinceanera Dress with Beading Embroidery