KAJAL STYLE<\/p>\r\n\r\n
FASHION FABULOUS VOL 1<\/p>\r\n\r\n
<\/p>\r\n\r\n
FABRIC DETAIL<\/p>\r\n\r\n
Top: Heavy Rayon Crepe Silk Nikhar Silk Georgette Muslin Fancy Embroidery Work Handwork Khatli Work<\/p>\r\n\r\n
<\/p>\r\n\r\n
Skirt: Rayon Print Banglore Model Print Nikhar Silk With Foil Print<\/p>\r\n\r\n
<\/p>\r\n\r\n
Size: M 19 L 20 XL 22 XXL 23 3XL 24<\/p>\r\n\r\n
<\/p>\r\n\r\n
Length: 46 to 48<\/p>\r\n\r\n
<\/p>\r\n\r\n
Designs: 8 <\/p>\r\n\r\n
<\/p>\r\n\r\n
Price: 799\/-+GST<\/p>\r\n","single_catalog":"0","product_date":"2020-11-03","pre_book":"0","ribbon":""}},{"product":{"product_id":"4082","dealer_id":"0","product_sku":"SBKLFRFVOL1","product_hsn":"5407","product_name":"SHUBHKALA FRILL & FLARE VOL 1","product_seo_url":"shubhkala-frill-flare-vol-1","product_image":"images\/product\/2020\/10\/shubhkala-frill-flare-vol-1-2020-10-21_12_07_02.jpeg","product_qty":"200","catalog_pcs":"10","product_price":"899","product_sale_price":"8990","product_gst":"5","product_weight":"10","product_stitch":"Full Stitched","catalog_type":"FULL SET","moq":"1","top_fabric":"Rayon Cotton Crepe Plain","bottom_fabric":"Crepe Foil Printed","dupatta_fabric":"","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","blouse_pcs":"","ideal_for":"","color":"10","bottom":"SKIRT","product_short_description":"Cotton Printed Designer Top with skirts","product_full_description":"SHUBHKALA FRILL & FLARE VOL 1 FABRIC DETAIL Top: Rayon Cotton Crepe Plain Bottom: Crepe Foil Printed Size: 28\u00e2\u20ac\u009d to 36\u00e2\u20ac\u009d in M SIZE and 36\u00e2\u20ac\u009d to 44\u00e2\u20ac\u009d in XL Designs: 10 Price: 899\/-+GST","product_status":"Publish","product_length":"","product_meta_title":"Wholesaler Supplier Of SHUBHKALA Western Dresses, Wholesaler Supplier Of LYMI, Wholesaler Supplier Of Designer Western Dresses And Designer, Wholesaler Supplier Of FRILL & FLARE VOL 1 By LYMI, SHUBHKALA Western Dresses In Cheapest Rate, SHUBHKALA Western Dresses In Lowest Price, SHUBHKALA Western Dresses In Wholesale Price, Best Wholesaler In Surat, Best Wholesaler In Gujarat, Wholesaler Supplier Of Embroidered Western Dresses, Wholesaler Of Printed Western Dresses, Wholesaler Of Ladies Designer Dress Materials, Wholesaler Supplier Of Cotton Western Dresses, Wholesaler Supplier Of Pakistani Western Dresses, Wholesaler Of Ladies Designer Stitch Western Dresses, Retailer Of Western Dresses, Retailer Of Designer Ladies Western Dresses, Best Retailer In Surat, Best Retailer In Gujarat.","product_meta_keyword":"","product_meta_description":"Cotton Printed Designer Top with skirts","disable_date":"2020-10-30","upcoming":"0","product_type":"Ready to Ship","other_detail":"","single_catalog":"0","product_date":"2020-10-21","pre_book":"0","ribbon":""}},{"product":{"product_id":"3719","dealer_id":"0","product_sku":"NSVOL4","product_hsn":"5407","product_name":"NITARA SPARKLES VOL 4","product_seo_url":"nitara-sparkles-vol-4","product_image":"images\/product\/2020\/09\/nitara-sparkles-vol-4-2020-09-28_13_13_11.jpg","product_qty":"150","catalog_pcs":"5","product_price":"1170","product_sale_price":"5850","product_gst":"5","product_weight":"5","product_stitch":"Full Stitched","catalog_type":"FULL SET","moq":"1","top_fabric":"Silk With Embroidery Belt","bottom_fabric":"Chanderi Table Print","dupatta_fabric":"","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","blouse_pcs":"","ideal_for":"","color":"5","bottom":"","product_short_description":"EMBROIDERED DESIGNER WESTERN SUIT","product_full_description":"SPARKLES VOL 4 Fabric Details: Top: Silk With Embroidery Belt Bottom: Chanderi Table Print Pcs: 5 Size: L, XL, XXL Price: 1170\/- + GST","product_status":"Publish","product_length":"","product_meta_title":"Wholesaler Supplier Of NITARA Western Dresses, Wholesaler Supplier Of NITARA, Wholesaler Supplier Of Designer Western Dresses And Designer, Wholesaler Supplier Of SPARKLES VOL 4 Western Dresses By NITARA, NITARA Western Dresses In Cheapest Rate, NITARA Western Dresses In Lowest Price, NITARA Western Dresses In Wholesale Price, Best Wholesaler In Surat, Best Wholesaler In Gujarat, Wholesaler Supplier Of Embroidered Western Dresses, Wholesaler Of Printed Western Dresses, Wholesaler Of Ladies Designer Dress Materials, Wholesaler Supplier Of Cotton Western Dresses, Wholesaler Supplier Of Pakistani Western Dresses, Wholesaler Of Ladies Designer Stitch Western Dresses, Retailer Of Western Dresses, Retailer Of Designer Ladies Western Dresses, Best Retailer In Surat, Best Retailer In Gujarat","product_meta_keyword":"WESTERN SUIT Manufacturer In Surat , WESTERN SUIT Wholesaler , Long WESTERN SUIT Wholesaler, Bridal WESTERN SUIT Wholesaler , Wedding WESTERN SUIT Wholesaler ,Cotton WESTERN SUIT Wholesale Dealer , Designer WESTERN SUIT Supplier , Wholesale Indian WESTERN SUIT , Wholesale WESTERN SUIT In Surat, Ready Made WESTERN SUIT Wholesale, Ready Made WESTERN SUIT Wholesale In India , Winter Wear WESTERN SUIT Dealer In Surat , WESTERN SUIT Supplier In Surat, WESTERN SUIT Wholesale Dealer In Surat.","product_meta_description":"EMBROIDERED DESIGNER WESTERN SUIT","disable_date":"2020-10-08","upcoming":"0","product_type":"Ready to Ship","other_detail":"","single_catalog":"0","product_date":"2020-09-28","pre_book":"0","ribbon":""}},{"product":{"product_id":"3594","dealer_id":"0","product_sku":"AKAI","product_hsn":"5407","product_name":"ANYUKA ALOHI","product_seo_url":"anyuka-alohi","product_image":"images\/product\/2020\/09\/anyuka-alohi-2020-09-21_15_19_18.jpg","product_qty":"300","catalog_pcs":"14","product_price":"1050","product_sale_price":"14700","product_gst":"5","product_weight":"14","product_stitch":"Full Stitched","catalog_type":"FULL SET","moq":"1","top_fabric":"MUSLIN ,RAYON,SLUB COTTON,KHADI,","bottom_fabric":"MUSLIN ,RAYON,SLUB COTTON,KHADI,POLY CREPE","dupatta_fabric":"","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","blouse_pcs":"","ideal_for":"","color":"14","bottom":"","product_short_description":"","product_full_description":"ALOHI TOP: \u00e2\u20ac\u00a2\tAN 95: MUSLIN \u00e2\u20ac\u00a2\tAN 96: RAYON \u00e2\u20ac\u00a2\tAN 97:RAW SILK \u00e2\u20ac\u00a2\tAN 98:LINEN FLEX \u00e2\u20ac\u00a2\tAN 99:SLUB COTTON \u00e2\u20ac\u00a2\tAN100:RAYON \u00e2\u20ac\u00a2\tAN101:MUSLIN \u00e2\u20ac\u00a2\tAN102:RAYON \u00e2\u20ac\u00a2\tAN103:MUSLIN \u00e2\u20ac\u00a2\tAN104:KHADI \u00e2\u20ac\u00a2\tAN105:RAYON \u00e2\u20ac\u00a2\tAN106:RAYON \u00e2\u20ac\u00a2\tAN107:MUSLIN \u00e2\u20ac\u00a2\tAN108:MUSLIN","product_status":"Publish","product_length":"","product_meta_title":"Wholesaler Supplier Of Anyuka Kurti, Wholesaler Supplier Of Anyuka, Wholesaler Supplier Of Designer Kurti And Designer, Wholesaler Supplier Of Isha By Anyuka, Anyuka Kurti In Cheapest Rate, Anyuka Kurti In Lowest Price, Anyuka Kurti In Wholesale Price, Best Wholesaler In Surat, Best Wholesaler In Gujarat, Wholesaler Supplier Of Embroidered Kurti, Wholesaler Of Printed Kurti, Wholesaler Of Ladies Designer Dress Materials, Wholesaler Supplier Of Cotton Kurti, Wholesaler Of Ladies Designer Stitch Kurti, Retailer Of Kurti, Retailer Of Designer Ladies Kurti, Best Retailer In Surat, Best Retailer In Gujarat.","product_meta_keyword":"Kurti Wholesaler , Printed Kurti Wholesaler , Cotton Kurti Wholesale Dealer , Designer Kurti Supplier , Wholesale Indian Kurti , Wholesale Kurti In Surat, Ready Made Kurti Wholesale, Ready Made Kurti Wholesale In India , Winter Wear Kurti Dealer In Surat , Kurti Supplier In Surat, Embroidery Kurti, Printed Kurti, Kurti With Bottom , Tail Cut Kurti, A Line Kurti, Frock Kurti, Trail Cut Kurti, Anarkali Kurti, Dhoti Style Kurti, Flared Style Kurti, Empire Waist Kurti, Shirt Style With Collar Kurti, Indo Western Style Kurti, Gown Style Kurti, Pakistani Kurti, Color -Block Kurti, Printed Kurti, Angrakha Kurti, High-Low Kurti, Kaftans Style Kurti, Princess Cut Kurti, Asymmetric Kurti, C-Cut Kurti, Tulip Kurti, Overlay Kurti, Reversible Kurti, Long Straight Kurti, Pin tuck Kurti, Double Layered Kurti, Slit Kurti, Denim Kurti, Kurti With Jacket, Tiered Kurti","product_meta_description":"EMBROIDEREED FANCY KURTI & PRINTED KURTI","disable_date":"2020-09-30","upcoming":"0","product_type":"","other_detail":"","single_catalog":"0","product_date":"2020-09-21","pre_book":"0","ribbon":""}},{"product":{"product_id":"2105","dealer_id":"0","product_sku":"RTCMS","product_hsn":"5407","product_name":"RANI TRENDZ CHINI MINI SKIRT","product_seo_url":"rani-trendz--chini-mini-skirt","product_image":"images\/product\/2020\/02\/rani-trendz--chini-mini-skirt-2020-02-06_12_56_50.jpg","product_qty":"50","catalog_pcs":"6","product_price":"125","product_sale_price":"750","product_gst":"5","product_weight":"6","product_stitch":"Full Stitched","catalog_type":"FULL SET ","moq":"1","top_fabric":"","bottom_fabric":"GEORGETTE","dupatta_fabric":"","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","blouse_pcs":"","ideal_for":"","color":"MULTI","bottom":"","product_short_description":"BRAND NAME- RANI TRENDZ CATALOG NAME- CHINI MINI SKIRT","product_full_description":" Rani trends CHINI MINI SKIRT @ 125\/- GST EXTRA Size and fabric detail in photo","product_status":"Publish","product_length":"","product_meta_title":" WHOLESELLER SUPPLIER FOR WESTERN ","product_meta_keyword":"LADIES SKART , DESIGNER SKART, FANCY SKART","product_meta_description":"WHOLESELLER SUPPLIER FOR LADIES SKART , DESIGNER SKART, FANCY SKART","disable_date":"2020-02-16","upcoming":"0","product_type":"Ask Availibility","other_detail":"","single_catalog":"0","product_date":"2020-02-06","pre_book":"0","ribbon":""}}],"dsd":"select pm.* from relation_master as rm left join product_master as pm on pm.product_id=rm.product_id where 1=1 and rm.type_id='63' and rm.type='cat' group by rm.product_id order by pm.product_date desc LIMIT 20, 20"}