{"status":"ok","count":12,"catalog":[{"product":{"product_id":"1385","dealer_id":"0","product_sku":"SAP","product_hsn":"5407","product_name":"SHAHNAZ ARTS PANIHARI","product_seo_url":"shahnaz-arts-panihari","product_image":"images\/product\/2019\/12\/panihari-2019-12-17_14_07_39.jpg","product_qty":"100","catalog_pcs":"8","product_price":"680","product_sale_price":"5440","product_gst":"5","product_weight":"8","product_stitch":"Unstitched","catalog_type":"FULL SET ","moq":"1","top_fabric":"HEAVY PASHMINA PRINT WITH HEAVY SELF EMBRODERY ","bottom_fabric":"PASHMINA PRINT","dupatta_fabric":"HEAVY PASHMINA SHAWL PRINT FOIL WITH FOUR SIDE PIPING & TASSEL","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","blouse_pcs":"","ideal_for":"","color":"MULTI","bottom":"","product_short_description":"SHAHNAZ ARTS PRESENT PANIHARI","product_full_description":"PANIHARI, TOP-HEAVY PASHMINA PRINT WITH HEAVY SELF EMBROIDERY, BOTTOM-PASHMINA PRINT, DUAPPTA-HEAVY PASHMINA SHAWL PRINT FOIL WITH FOUR SIDE PIPING & TASSEL","product_status":"Publish","product_length":"","product_meta_title":" WHOLESELLER SUPPLIER FOR SALWAR SUIT","product_meta_keyword":"LADIES SALWAR SUIT , DESIGNER SALWAR SUIT, FANCY SALWAR SUIT","product_meta_description":"WHOLESELLER SUPPLIER FOR LADIES SALWAR SUIT , DESIGNER SALWAR SUIT, FANCY SALWAR SUIT","disable_date":"2019-12-28","upcoming":"0","product_type":"Upcomming","other_detail":"","single_catalog":"0","product_date":"2019-12-17","pre_book":"0","ribbon":""}},{"product":{"product_id":"1147","dealer_id":"0","product_sku":"SHAHNAZGULSHAN VOL 4","product_hsn":"5407","product_name":"SHAHNAZ ARTS","product_seo_url":"shahnaz-arts","product_image":"images\/product\/2019\/11\/shahnaz-arts-2019-11-22_16_43_03.jpg","product_qty":"100","catalog_pcs":"8","product_price":"551","product_sale_price":"4408","product_gst":"5","product_weight":"8","product_stitch":"Unstitched","catalog_type":"FULL SET ","moq":"1","top_fabric":"HEAVY PASMINA PRINT","bottom_fabric":" PASMINA","dupatta_fabric":" PASMINA","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","blouse_pcs":"","ideal_for":"","color":"MULTI","bottom":"","product_short_description":"BRAND NAME- SHAHNAZ ARTS CATLOUGE NAME- GULSHAN VOL 4","product_full_description":"GULSHAN VOL 4 TOP HEAVY PASMINA PRINT BOTTOM PASMINA DUPPTA PASMINA SHAWL DES 8 RATE 551\/- GST EXTAR SHAHNAZ ARTS SURAT","product_status":"Publish","product_length":"","product_meta_title":" WHOLESELLER SUPPLIER FOR SALWAR SUIT","product_meta_keyword":"LADIES SALWAR SUIT , DESIGNER SALWAR SUIT, FANCY SALWAR SUIT","product_meta_description":"WHOLESELLER SUPPLIER FOR LADIES SALWAR SUIT , DESIGNER SALWAR SUIT, FANCY SALWAR SUIT","disable_date":"2019-12-02","upcoming":"0","product_type":"","other_detail":"","single_catalog":"0","product_date":"2019-11-22","pre_book":"0","ribbon":""}},{"product":{"product_id":"997","dealer_id":"0","product_sku":"SHAHNAZGUJARISH","product_hsn":"5407","product_name":"SHAHNAZ ARTS GUJARISH","product_seo_url":"shahnaz-arts--gujarish","product_image":"images\/product\/2019\/10\/shahnaz-arts--gujarish-2019-10-21_12_24_28.jpg","product_qty":"100","catalog_pcs":"8","product_price":"549","product_sale_price":"4392","product_gst":"5","product_weight":"10","product_stitch":"Unstitched","catalog_type":"FULL SET ","moq":"1","top_fabric":"HEAVY PASMINA PRINT","bottom_fabric":"PASHMINA","dupatta_fabric":"PASMINA SHAWL PRINT BOX PALLU WITH TASSEL","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","blouse_pcs":"","ideal_for":"","color":"MULTI","bottom":"","product_short_description":"BRAND NAME- SHAHNAZ ARTS CATLOUGE NAME- GUJARISH","product_full_description":"GUJARISH TOP HEAVY PASMINA PRINT BOTTOM PASMINA DUPPTA PASMINA SHAWL PRINT BOX PALLU WITH TASSEL DES 8 RATE 549+ GST SHAHNAZ ARTS SURAT","product_status":"Publish","product_length":"","product_meta_title":" WHOLESELLER SUPPLIER FOR SALWAR SUIT","product_meta_keyword":"LADIES SALWAR SUIT , DESIGNER SALWAR SUIT, FANCY SALWAR SUIT","product_meta_description":"WHOLESELLER SUPPLIER FOR LADIES SALWAR SUIT , DESIGNER SALWAR SUIT, FANCY SALWAR SUIT","disable_date":"2019-11-01","upcoming":"0","product_type":"","other_detail":"","single_catalog":"0","product_date":"2019-10-21","pre_book":"0","ribbon":""}},{"product":{"product_id":"930","dealer_id":"0","product_sku":"SHAHNAZ GAJRA","product_hsn":"5407","product_name":"SHAHNAZ ARTS GAJRA","product_seo_url":"shahnaz-arts-gajra","product_image":"images\/product\/2019\/10\/shahnaz-arts-gajra-2019-10-15_16_58_19.jpg","product_qty":"100","catalog_pcs":"8","product_price":"525","product_sale_price":"4200","product_gst":"5","product_weight":"10","product_stitch":"Unstitched","catalog_type":"FULL SET ","moq":"1","top_fabric":"HEAVY PASMINA WITH DIGITAL STYLE PRINT","bottom_fabric":"PASHMINA","dupatta_fabric":"PASMINA SHAWL","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","blouse_pcs":"","ideal_for":"","color":"MULTI","bottom":"","product_short_description":"BRAND NAME- SHAHNAZ ARTS CATLOUGE NAME- GAJRA","product_full_description":"GAJRA TOP HEAVY PASMINA WITH DIGITAL STYLE PRINT BOTTOM PASMINA DUPPTA PASMINA SHAWL DES 8 RATE 525+ GST SHAHNAZ ARTS SURAT","product_status":"Publish","product_length":"","product_meta_title":" WHOLESELLER SUPPLIER FOR SALWAR SUIT","product_meta_keyword":"LADIES SALWAR SUIT , DESIGNER SALWAR SUIT, FANCY SALWAR SUIT","product_meta_description":"WHOLESELLER SUPPLIER FOR LADIES SALWAR SUIT , DESIGNER SALWAR SUIT, FANCY SALWAR SUIT","disable_date":"2019-10-25","upcoming":"0","product_type":"","other_detail":"","single_catalog":"0","product_date":"2019-10-15","pre_book":"0","ribbon":""}},{"product":{"product_id":"828","dealer_id":"0","product_sku":"SHAHNAZGULSHAN 3","product_hsn":"5407","product_name":"SHAHNAZ ARTS GULSHAN VOL 3","product_seo_url":"shahnaz-arts-gulshan-vol-3","product_image":"images\/product\/2019\/10\/shahnaz-arts-gulshan-vol-3-2019-10-09_17_04_54.jpg","product_qty":"100","catalog_pcs":"8","product_price":"525","product_sale_price":"4200","product_gst":"5","product_weight":"10","product_stitch":"Unstitched","catalog_type":"FULL SET ","moq":"1","top_fabric":" HEAVY PASMINA DOBBY PRINT","bottom_fabric":" PASMINA TWILL DYED","dupatta_fabric":"PASMINA SHAWL","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","blouse_pcs":"","ideal_for":"","color":"MULTI","bottom":"","product_short_description":"BRAND NAME - SHAHNAZ ARTS CATLOUGE NAME - GULSHAN VOL 3","product_full_description":"GULSHAN TOP HEAVY PASMINA DOBBY PRINT BOTTOM PASMINA TWILL DYED DUPPTA PASMINA SHAWL DES 8 Rate 525+ gst Shahnaz arts surat","product_status":"Publish","product_length":"","product_meta_title":" WHOLESELLER SUPPLIER FOR SALWAR SUIT","product_meta_keyword":"LADIES SALWAR SUIT , DESIGNER SALWAR SUIT, FANCY SALWAR SUIT","product_meta_description":"WHOLESELLER SUPPLIER FOR LADIES SALWAR SUIT , DESIGNER SALWAR SUIT, FANCY SALWAR SUIT","disable_date":"2019-10-19","upcoming":"0","product_type":"","other_detail":"","single_catalog":"0","product_date":"2019-10-09","pre_book":"0","ribbon":""}},{"product":{"product_id":"768","dealer_id":"0","product_sku":"SAHAHNAZGULBAHAR","product_hsn":"5407","product_name":"SHAHNAZ ARTS GUL BAHAR","product_seo_url":"shahnaz-arts-gul-bahar","product_image":"images\/product\/2019\/10\/shahnaz-arts-gul-bahar-2019-10-03_14_07_39.jpg","product_qty":"100","catalog_pcs":"8","product_price":"699","product_sale_price":"5592","product_gst":"5","product_weight":"10","product_stitch":"Unstitched","catalog_type":"FULL SET ","moq":"1","top_fabric":"HEAVY PASMINA PRINT WITH HANDWORK ( KHATLI WORK )","bottom_fabric":"PASMINA","dupatta_fabric":"PURE BEMBER SIFFON PRINT","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","blouse_pcs":"","ideal_for":"","color":"MULTI","bottom":"","product_short_description":"BRAND NAME - SHAHNAZ ARTS CATLOUGE NAME - GUL BAHAR","product_full_description":"GUL BAHAR TOP HEAVY PASMINA PRINT WITH HANDWORK ( KHATLI WORK ) BOTTOM PASMINA DUPPTA PURE BEMBER SIFFON PRINT DES 8 RATE. 699+ GST SHAHNAZ ARTS SURAT","product_status":"Publish","product_length":"","product_meta_title":" WHOLESELLER SUPPLIER FOR SALWAR SUIT","product_meta_keyword":"LADIES SALWAR SUIT , DESIGNER SALWAR SUIT, FANCY SALWAR SUIT","product_meta_description":"WHOLESELLER SUPPLIER FOR LADIES SALWAR SUIT , DESIGNER SALWAR SUIT, FANCY SALWAR SUIT","disable_date":"2019-10-13","upcoming":"0","product_type":"","other_detail":"","single_catalog":"0","product_date":"2019-10-03","pre_book":"0","ribbon":""}},{"product":{"product_id":"707","dealer_id":"0","product_sku":"SHAHNAZGULMOHAR","product_hsn":"5407","product_name":"SHAHNAZ ARTS GULMOHAR","product_seo_url":"shahnaz-arts-gulmohar","product_image":"images\/product\/2019\/10\/shahnaz-arts-gulmohar-2019-10-01_10_54_26.jpg","product_qty":"100","catalog_pcs":"8","product_price":"499","product_sale_price":"3992","product_gst":"5","product_weight":"10","product_stitch":"Unstitched","catalog_type":"FULL SET ","moq":"1","top_fabric":"HEAVY PASMINA DIGITAL STYLE PRINT WITH SWAROVSKI WORK","bottom_fabric":"PASMINA TWILL","dupatta_fabric":"HEAVY SIFFON PRINT","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","blouse_pcs":"","ideal_for":"","color":"MULTI","bottom":"","product_short_description":"BRAND NAME -SHAHNAZ ARTS CATLOUGE NAME - GULMOHAR","product_full_description":"GULMOHAR TOP HEAVY PASMINA DIGITAL STYLE PRINT WITH SWAROVSKI WORK BOTTOM PASMINA TWILL DUPPTA HEAVY SIFFON PRINT DES 8 RATE 499+ GST SHAHNAZ ARTS SURAT","product_status":"Publish","product_length":"","product_meta_title":" WHOLESELLER SUPPLIER FOR SALWAR SUIT","product_meta_keyword":"LADIES SALWAR SUIT , DESIGNER SALWAR SUIT, FANCY SALWAR SUIT","product_meta_description":"WHOLESELLER SUPPLIER FOR LADIES SALWAR SUIT , DESIGNER SALWAR SUIT, FANCY SALWAR SUIT","disable_date":"2019-10-10","upcoming":"0","product_type":"","other_detail":"","single_catalog":"0","product_date":"2019-10-01","pre_book":"0","ribbon":""}},{"product":{"product_id":"712","dealer_id":"0","product_sku":"TANISHKGULBAHAR","product_hsn":"5407","product_name":"TANISHK GULBAHAR","product_seo_url":"tanishk--gulbahar","product_image":"images\/product\/2019\/10\/tanishk--gulbahar-2019-10-01_11_54_09.jpg","product_qty":"100","catalog_pcs":"10","product_price":"675","product_sale_price":"6750","product_gst":"5","product_weight":"10","product_stitch":"Unstitched","catalog_type":"FULL SET ","moq":"1","top_fabric":"Pure hairing bond pashmina Designer digital with embrodery work","bottom_fabric":"Pashmina","dupatta_fabric":"Pure dupatta with Print","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","blouse_pcs":"","ideal_for":"","color":"MULTI","bottom":"","product_short_description":"BRAND NAME - TANISHK FASHION CATLOUGE NAME - GULBAHAR","product_full_description":"*GULBAHAR* Presenting this Winter collection for u,this having beautiful Digital concept of print in Top & Dupatta.... 10 Design of Suit having embro work..... *:-Description:-* * Name:- GULBAHAR* *1-Top:- Pure hairing bond pashmina Designer digital wit","product_status":"Publish","product_length":"","product_meta_title":" WHOLESELLER SUPPLIER FOR SALWAR SUIT","product_meta_keyword":"LADIES SALWAR SUIT , DESIGNER SALWAR SUIT, FANCY SALWAR SUIT","product_meta_description":"WHOLESELLER SUPPLIER FOR LADIES SALWAR SUIT , DESIGNER SALWAR SUIT, FANCY SALWAR SUIT","disable_date":"2019-10-10","upcoming":"0","product_type":"","other_detail":"","single_catalog":"0","product_date":"2019-10-01","pre_book":"0","ribbon":""}},{"product":{"product_id":"713","dealer_id":"0","product_sku":"LTNITYA143","product_hsn":"5407","product_name":"L T FABRICS NITYA 143","product_seo_url":"l-t-fabrics-nitya-143","product_image":"images\/product\/2019\/10\/l-t-fabrics-nitya-143-2019-10-01_12_00_16.jpg","product_qty":"100","catalog_pcs":"8","product_price":"2150","product_sale_price":"17200","product_gst":"5","product_weight":"10","product_stitch":"Unstitched","catalog_type":"FULL SET ","moq":"1","top_fabric":"JAQCARD","bottom_fabric":"COTTON","dupatta_fabric":"JACQUARD SILK","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","blouse_pcs":"","ideal_for":"","color":"MULTI","bottom":"","product_short_description":"BRAND NAME - L T FABRICS CATLOUGE NAME - NITYA 143","product_full_description":"Lt nitya 143 @ 2150\/- GST EXTRA","product_status":"Publish","product_length":"","product_meta_title":" WHOLESELLER SUPPLIER FOR SALWAR SUIT","product_meta_keyword":"LADIES SALWAR SUIT , DESIGNER SALWAR SUIT, FANCY SALWAR SUIT","product_meta_description":"WHOLESELLER SUPPLIER FOR LADIES SALWAR SUIT , DESIGNER SALWAR SUIT, FANCY SALWAR SUIT","disable_date":"2019-10-10","upcoming":"0","product_type":"","other_detail":"","single_catalog":"0","product_date":"2019-10-01","pre_book":"0","ribbon":""}},{"product":{"product_id":"714","dealer_id":"0","product_sku":"KIMORAHEER54","product_hsn":"5407","product_name":"KIMORA HEER 54","product_seo_url":"kimora-heer-54","product_image":"images\/product\/2019\/10\/kimora-heer-54-2019-10-01_12_03_21.jpg","product_qty":"100","catalog_pcs":"8","product_price":"1950","product_sale_price":"15600","product_gst":"5","product_weight":"10","product_stitch":"Unstitched","catalog_type":"FULL SET ","moq":"1","top_fabric":"GEORGETTE ","bottom_fabric":"COTTON","dupatta_fabric":"CHIFFON","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","blouse_pcs":"","ideal_for":"","color":"MULTI","bottom":"","product_short_description":"Kimora brings... *Heer -54*","product_full_description":"Kimora brings... *Heer -54* @1950\/- Gst extra 5% Fabric details in photo","product_status":"Publish","product_length":"","product_meta_title":" WHOLESELLER SUPPLIER FOR SALWAR SUIT","product_meta_keyword":"LADIES SALWAR SUIT , DESIGNER SALWAR SUIT, FANCY SALWAR SUIT","product_meta_description":"WHOLESELLER SUPPLIER FOR LADIES SALWAR SUIT , DESIGNER SALWAR SUIT, FANCY SALWAR SUIT","disable_date":"2019-10-10","upcoming":"0","product_type":"","other_detail":"","single_catalog":"0","product_date":"2019-10-01","pre_book":"0","ribbon":""}},{"product":{"product_id":"715","dealer_id":"0","product_sku":"KESARIIBALLVOL1","product_hsn":"5407","product_name":"KESARI I BALL VOL 1","product_seo_url":"kesari-i-ball-vol-1","product_image":"images\/product\/2019\/10\/kesari-i-ball-vol-1-2019-10-01_12_07_18.jpg","product_qty":"100","catalog_pcs":"8","product_price":"750","product_sale_price":"6000","product_gst":"5","product_weight":"10","product_stitch":"Unstitched","catalog_type":"FULL SET ","moq":"1","top_fabric":"pasmina Dubby self Embroidery work","bottom_fabric":"pasmina twil","dupatta_fabric":"pure bember print","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","blouse_pcs":"","ideal_for":"","color":"MULTI","bottom":"","product_short_description":"BRAND NAME - KESARI CATLOUGE NAME - I BALL VOL 1","product_full_description":"*fabrics details are given below:* *Top:pasmina Dubby self Embroidery work* *Bottom:pasmina twil* *Dup: pure bember print* *Price: \u00e2\u201a\u00b9 750\/-* *Designes:8* *Pettern: straight*","product_status":"Publish","product_length":"","product_meta_title":" WHOLESELLER SUPPLIER FOR SALWAR SUIT","product_meta_keyword":"LADIES SALWAR SUIT , DESIGNER SALWAR SUIT, FANCY SALWAR SUIT","product_meta_description":"WHOLESELLER SUPPLIER FOR LADIES SALWAR SUIT , DESIGNER SALWAR SUIT, FANCY SALWAR SUIT","disable_date":"2019-10-10","upcoming":"0","product_type":"","other_detail":"","single_catalog":"0","product_date":"2019-10-01","pre_book":"0","ribbon":""}},{"product":{"product_id":null,"dealer_id":null,"product_sku":null,"product_hsn":null,"product_name":null,"product_seo_url":null,"product_image":null,"product_qty":null,"catalog_pcs":null,"product_price":null,"product_sale_price":null,"product_gst":null,"product_weight":null,"product_stitch":null,"catalog_type":null,"moq":null,"top_fabric":null,"bottom_fabric":null,"dupatta_fabric":null,"saree_fabric":null,"blouse_fabric":null,"lehenga_fabric":null,"blouse_pcs":null,"ideal_for":null,"color":null,"bottom":null,"product_short_description":null,"product_full_description":null,"product_status":null,"product_length":null,"product_meta_title":null,"product_meta_keyword":null,"product_meta_description":null,"disable_date":null,"upcoming":null,"product_type":null,"other_detail":null,"single_catalog":null,"product_date":null,"pre_book":null,"ribbon":null}}],"dsd":"select pm.* from brand_relation_master as brm left join product_master as pm on pm.product_id=brm.product_id where 1=1 and brm.brand_id='62' group by brm.product_id order by pm.product_date desc LIMIT 20, 20"}