{"status":"ok","count":20,"catalog":[{"product_id":"406220","product_name":"belliza designer studio guzarish vol-8 pure cotton designer salwar suits catalogue manufacturer surat gujarat ","brand_name_name":"Belliza Designer studio","cname":"guzarish vol-8","product_seo_url":"belliza-designer-studio-guzarish-vol-8-pure-cotton-designer-salwar-suits-catalogue-manufacturer-surat-gujarat","product_image":"https:\/\/prathamexports.com\/images\/product\/2024\/05\/belliza-designer-studio-guzarish-vol-8-pure-cotton-designer-salwar-suits-catalogue-manufacturer-surat-gujarat-2024-05-11_15_31_34.jpg","product_qty":"2","sale_price":"5840","product_price":"730","product_mrp_price":"780","catalog_pcs":"8","regular_price":null,"disable_date":"2024-05-13 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"On Booking","per_product_weight":"8Kg","fabric_name123":"Pure Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":6,"productview":"156","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"11th May 2024","salelable":""},{"product_id":"406188","product_name":"belliza by naira vol 49 exclusive summer pure cotton digital salwar kameez catalogue price at india ","brand_name_name":"Belliza Designer studio","cname":" naira vol 49 ","product_seo_url":"belliza-by-naira-vol-49-exclusive-summer-pure-cotton-digital-salwar-kameez-catalogue-price-at-india","product_image":"https:\/\/prathamexports.com\/images\/product\/2024\/05\/belliza-by-naira-vol-49-exclusive-summer-pure-cotton-digital-salwar-kameez-catalogue-price-at-india-2024-05-10_08_15_02.jpg","product_qty":"2","sale_price":"4600","product_price":"575","product_mrp_price":"625","catalog_pcs":"8","regular_price":null,"disable_date":"2024-05-13 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"Ready to Ship","per_product_weight":"8Kg","fabric_name123":"Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":8,"productview":"354","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"10th May 2024","salelable":""},{"product_id":"406181","product_name":"belliza bin saeed vol 4 exclusive party wear summer cotton digital salwar kameez collection buy online dealer ","brand_name_name":"Belliza Designer studio","cname":" bin saeed vol 4","product_seo_url":"belliza-bin-saeed-vol-4-exclusive-party-wear-summer-cotton-digital-salwar-kameez-collection-buy-online-dealer","product_image":"https:\/\/prathamexports.com\/images\/product\/2024\/05\/belliza-bin-saeed-vol-4-exclusive-party-wear-summer-cotton-digital-salwar-kameez-collection-buy-online-dealer-2024-05-09_16_30_43.jpg","product_qty":"2","sale_price":"5200","product_price":"650","product_mrp_price":"700","catalog_pcs":"8","regular_price":null,"disable_date":"2024-05-12 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"On Booking","per_product_weight":"6Kg","fabric_name123":"Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":7,"productview":"105","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"9th May 2024","salelable":""},{"product_id":"406050","product_name":"belliza jashn e ishq vol 7 exclusive party wear indian salwar kameez catalogue buy online dealer ","brand_name_name":"Belliza Designer studio","cname":" jashn e ishq vol 7 ","product_seo_url":"belliza-jashn-e-ishq-vol-7-exclusive-party-wear-indian-salwar-kameez-catalogue-buy-online-dealer","product_image":"https:\/\/prathamexports.com\/images\/product\/2024\/05\/belliza-jashn-e-ishq-vol-7-exclusive-party-wear-indian-salwar-kameez-catalogue-buy-online-dealer-2024-05-02_15_14_01.jpg","product_qty":"2","sale_price":"6360","product_price":"795","product_mrp_price":"849","catalog_pcs":"8","regular_price":null,"disable_date":"2024-05-04 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"On Booking","per_product_weight":"8Kg","fabric_name123":"Jam Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":6,"productview":"80","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"2nd May 2024","salelable":""},{"product_id":"402730","product_name":"belliza qurbat designer latest pakistani festive wear salwar kameez wholesaler india","brand_name_name":"Belliza Designer studio","cname":"qurbat ","product_seo_url":"belliza-qurbat-designer-latest-pakistani-festive-wear-salwar-kameez-wholesaler-india","product_image":"https:\/\/prathamexports.com\/images\/product\/2023\/11\/belliza-qurbat-designer-latest-pakistani-festive-wear-salwar-kameez-wholesaler-india-2023-11-06_14_22_03.jpg","product_qty":"1","sale_price":"5000","product_price":"625","product_mrp_price":"675","catalog_pcs":"8","regular_price":null,"disable_date":"2024-04-29 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"On Booking","per_product_weight":"8Kg","fabric_name123":"Wool","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":7,"productview":"386","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"6th Nov 2023","salelable":""},{"product_id":"405833","product_name":"belliza designer studio naira vol-47 exclusive designer unstich designer salwar kameez catalogue manufacturer surat gujarat","brand_name_name":"Belliza Designer studio","cname":"naira vol-47","product_seo_url":"belliza-designer-studio-naira-vol-47-exclusive-designer-unstich-designer-salwar-kameez-catalogue-manufacturer-surat-gujarat","product_image":"https:\/\/prathamexports.com\/images\/product\/2024\/04\/belliza-designer-studio-naira-vol-47-exclusive-designer-unstich-designer-salwar-kameez-catalogue-manufacturer-surat-gujarat-2024-04-22_18_51_31.jpg","product_qty":"2","sale_price":"4600","product_price":"575","product_mrp_price":"625","catalog_pcs":"8","regular_price":null,"disable_date":"2024-04-29 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"On Booking","per_product_weight":"8Kg","fabric_name123":"Pure Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":8,"productview":"84","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"22nd Apr 2024","salelable":""},{"product_id":"405956","product_name":"belliza designer studio naira vol-48 exclusive designer salwar kameez catalogue wholesale price surat gujarat ","brand_name_name":"Belliza Designer studio","cname":"naira vol-48","product_seo_url":"belliza-designer-studio-naira-vol-48-exclusive-designer-salwar-kameez-catalogue-wholesale-price-surat-gujarat","product_image":"https:\/\/prathamexports.com\/images\/product\/2024\/04\/belliza-designer-studio-naira-vol-48-exclusive-designer-salwar-kameez-catalogue-wholesale-price-surat-gujarat-2024-04-27_18_52_02.jpg","product_qty":"2","sale_price":"4600","product_price":"575","product_mrp_price":"625","catalog_pcs":"8","regular_price":null,"disable_date":"2024-04-29 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"On Booking","per_product_weight":"8Kg","fabric_name123":"Pure Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":8,"productview":"137","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"27th Apr 2024","salelable":""},{"product_id":"405859","product_name":"belliza designer studio guzarish vol-7 pure cotton dress material catalogue online wholesale surat gujarat","brand_name_name":"Belliza Designer studio","cname":"guzarish vol-7","product_seo_url":"belliza-designer-studio-guzarish-vol-7-pure-cotton-dress-material-catalogue-online-wholesale-surat-gujarat","product_image":"https:\/\/prathamexports.com\/images\/product\/2024\/04\/belliza-designer-studio-guzarish-vol-7-pure-cotton-dress-material-catalogue-online-wholesale-surat-gujarat-2024-04-23_16_22_35.jpg","product_qty":"2","sale_price":"5840","product_price":"730","product_mrp_price":"770","catalog_pcs":"8","regular_price":null,"disable_date":"2024-04-25 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"On Booking","per_product_weight":"8Kg","fabric_name123":"Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":5,"productview":"234","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"23rd Apr 2024","salelable":""},{"product_id":"405567","product_name":"belliza naira vol 45 designer pure cotton digital printed summer special catlogue buy from india surat","brand_name_name":"Belliza Designer studio","cname":" naira vol 45","product_seo_url":"belliza-naira-vol-45-designer-pure-cotton-digital-printed-summer-special-catlogue-buy-from-india-surat","product_image":"https:\/\/prathamexports.com\/images\/product\/2024\/04\/belliza-naira-vol-45-designer-pure-cotton-digital-printed-summer-special-catlogue-buy-from-india-surat-2024-04-08_15_56_17.jpg","product_qty":"2","sale_price":"4600","product_price":"575","product_mrp_price":"625","catalog_pcs":"8","regular_price":null,"disable_date":"2024-04-12 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"On Booking","per_product_weight":"8Kg","fabric_name123":"Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":8,"productview":"192","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"8th Apr 2024","salelable":""},{"product_id":"405546","product_name":"belliza designer guzarish vol-6 pure cotton designer salwar suits latest catalogue surat gujarat ","brand_name_name":"Belliza Designer studio","cname":"guzarish vol-6","product_seo_url":"belliza-designer-guzarish-vol-6-pure-cotton-designer-salwar-suits-latest-catalogue-surat-gujarat","product_image":"https:\/\/prathamexports.com\/images\/product\/2024\/04\/belliza-designer-guzarish-vol-6-pure-cotton-designer-salwar-suits-latest-catalogue-surat-gujarat-2024-04-08_10_35_15.jpg","product_qty":"2","sale_price":"5840","product_price":"730","product_mrp_price":"780","catalog_pcs":"8","regular_price":null,"disable_date":"2024-04-10 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"On Booking","per_product_weight":"8Kg","fabric_name123":"Pure Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":6,"productview":"383","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"8th Apr 2024","salelable":""},{"product_id":"405526","product_name":"belliza designer studio naira vol-44 unstitched designer salwar kameez catalogue wholesale surat gujarat ","brand_name_name":"Belliza Designer studio","cname":"naira vol-44","product_seo_url":"belliza-designer-studio-naira-vol-44-unstitched-designer-salwar-kameez-catalogue-wholesale-surat-gujarat","product_image":"https:\/\/prathamexports.com\/images\/product\/2024\/04\/belliza-designer-studio-naira-vol-44-unstitched-designer-salwar-kameez-catalogue-wholesale-surat-gujarat-2024-04-06_11_01_50.jpg","product_qty":"2","sale_price":"4600","product_price":"575","product_mrp_price":"625","catalog_pcs":"8","regular_price":null,"disable_date":"2024-04-08 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"On Booking","per_product_weight":"8Kg","fabric_name123":"Pure Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":8,"productview":"193","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"6th Apr 2024","salelable":""},{"product_id":"405505","product_name":"belliza designer studio jashn e ishq vol-5 trendy designer salwar kameez catalogue design 2024 surat gujarat","brand_name_name":"Belliza Designer studio","cname":"jashn e ishq vol-5","product_seo_url":"belliza-designer-studio-jashn-e-ishq-vol-5-trendy-designer-salwar-kameez-catalogue-design-2024-surat-gujarat","product_image":"https:\/\/prathamexports.com\/images\/product\/2024\/04\/belliza-designer-studio-jashn-e-ishq-vol-5-trendy-designer-salwar-kameez-catalogue-design-2024-surat-gujarat-2024-04-05_10_27_56.jpg","product_qty":"2","sale_price":"4770","product_price":"795","product_mrp_price":"845","catalog_pcs":"6","regular_price":null,"disable_date":"2024-04-07 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"On Booking","per_product_weight":"8Kg","fabric_name123":"Jam","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":6,"productview":"107","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"5th Apr 2024","salelable":""},{"product_id":"405461","product_name":"belliza designer studio naira vol-43 print with embroidered work designer dress material at wholesale price surat gujrat ","brand_name_name":"Belliza Designer studio","cname":"naira vol-43","product_seo_url":"belliza-designer-studio-naira-vol-43-print-with-embroidered-work-designer-dress-material-at-wholesale-price-surat-gujrat","product_image":"https:\/\/prathamexports.com\/images\/product\/2024\/04\/belliza-designer-studio-naira-vol-4-print-with-embroidered-work-designer-dress-material-at-wholesale-price-surat-gujrat-2024-04-03_11_01_41.jpg","product_qty":"2","sale_price":"4600","product_price":"575","product_mrp_price":"625","catalog_pcs":"8","regular_price":null,"disable_date":"2024-04-05 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"On Booking","per_product_weight":"8Kg","fabric_name123":"Pure Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":8,"productview":"192","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"3rd Apr 2024","salelable":""},{"product_id":"405400","product_name":"belliza designer studio naazia pure jam cotton designer salwar kameez catalogue online wholesaler surat gujrat ","brand_name_name":"Belliza Designer studio","cname":"naazia ","product_seo_url":"belliza-designer-studio-naazia-pure-jam-cotton-designer-salwar-kameez-catalogue-online-wholesaler-surat-gujrat","product_image":"https:\/\/prathamexports.com\/images\/product\/2024\/03\/belliza-designer-studio-naazia-pure-jam-cotton-designer-salwar-kameez-catalogue-online-wholesaler-surat-gujrat-2024-03-30_20_04_13.jpg","product_qty":"2","sale_price":"4050","product_price":"675","product_mrp_price":"725","catalog_pcs":"6","regular_price":null,"disable_date":"2024-04-01 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"On Booking","per_product_weight":"6Kg","fabric_name123":"Jam Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":7,"productview":"126","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"30th Mar 2024","salelable":""},{"product_id":"405359","product_name":"belliza designer studio naira vol-42 exclusive designer pure cotton suits catalogue manufacturer surat gujrat ","brand_name_name":"Belliza Designer studio","cname":"naira vol-42","product_seo_url":"belliza-designer-studio-naira-vol-42-exclusive-designer-pure-cotton-suits-catalogue-manufacturer-surat-gujrat","product_image":"https:\/\/prathamexports.com\/images\/product\/2024\/03\/belliza-designer-studio-naira-vol-42-exclusive-designer-pure-cotton-suits-catalogue-manufacturer-surat-gujrat-2024-03-29_16_51_25.jpg","product_qty":"2","sale_price":"4600","product_price":"575","product_mrp_price":"625","catalog_pcs":"8","regular_price":null,"disable_date":"2024-03-31 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"On Booking","per_product_weight":"8Kg","fabric_name123":"Pure Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":8,"productview":"96","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"29th Mar 2024","salelable":""},{"product_id":"405341","product_name":"belliza designer studio guzarish vol-5 fancy pakistani salwar kameez latest catalogue surat gujrat ","brand_name_name":"Belliza Designer studio","cname":"guzarish vol-5","product_seo_url":"belliza-designer-studio-guzarish-vol-5-fancy-pakistani-salwar-kameez-latest-catalogue-surat-gujrat","product_image":"https:\/\/prathamexports.com\/images\/product\/2024\/03\/belliza-designer-studio-guzarish-vol-5-fancy-pakistani-salwar-kameez-latest-catalogue-surat-gujrat-2024-03-28_18_14_48.jpg","product_qty":"2","sale_price":"5840","product_price":"730","product_mrp_price":"780","catalog_pcs":"8","regular_price":null,"disable_date":"2024-03-30 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"On Booking","per_product_weight":"8Kg","fabric_name123":"Pure Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":6,"productview":"221","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"28th Mar 2024","salelable":""},{"product_id":"405296","product_name":"belliza designer studio jashn e ishq vol-4 trendy designer salwar kameez catalogue design 2024 surat gujrat ","brand_name_name":"Belliza Designer studio","cname":"jashn e ishq vol-4","product_seo_url":"belliza-designer-studio-jashn-e-ishq-vol-4-trendy-designer-salwar-kameez-catalogue-design-2024-surat-gujrat","product_image":"https:\/\/prathamexports.com\/images\/product\/2024\/03\/belliza-designer-studio-jashn-e-ishq-vol-4-trendy-designer-salwar-kameez-catalogue-design-2024-surat-gujrat-2024-03-26_15_33_48.jpg","product_qty":"2","sale_price":"6360","product_price":"795","product_mrp_price":"845","catalog_pcs":"8","regular_price":null,"disable_date":"2024-03-28 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"On Booking","per_product_weight":"8Kg","fabric_name123":"Jam","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":6,"productview":"113","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"26th Mar 2024","salelable":""},{"product_id":"405237","product_name":"belliza designer studio naira vol-41 premium designer salwar kameez catalogue wholesaler surat gujrat","brand_name_name":"Belliza Designer studio","cname":"naira vol-41","product_seo_url":"belliza-designer-studio-naira-vol-41-premium-designer-salwar-kameez-catalogue-wholesaler-surat-gujrat","product_image":"https:\/\/prathamexports.com\/images\/product\/2024\/03\/belliza-designer-studio-naira-vol-41-premium-designer-salwar-kameez-catalogue-wholesaler-surat-gujrat-2024-03-21_16_05_39.jpg","product_qty":"2","sale_price":"4600","product_price":"575","product_mrp_price":"625","catalog_pcs":"8","regular_price":null,"disable_date":"2024-03-23 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"On Booking","per_product_weight":"8Kg","fabric_name123":"Pure Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":8,"productview":"130","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"21st Mar 2024","salelable":""},{"product_id":"405182","product_name":"belliza designer studio naira vol-40 exclusive designer unstitched dress material catalogue surat gujrat ","brand_name_name":"Belliza Designer studio","cname":"naira vol-40","product_seo_url":"belliza-designer-studio-naira-vol-40-exclusive-designer-unstitched-dress-material-catalogue-surat-gujrat","product_image":"https:\/\/prathamexports.com\/images\/product\/2024\/03\/belliza-designer-studio-naira-vol-40-exclusive-designer-unstitched-dress-material-catalogue-surat-gujrat-2024-03-19_17_17_57.jpg","product_qty":"2","sale_price":"4600","product_price":"575","product_mrp_price":"625","catalog_pcs":"8","regular_price":null,"disable_date":"2024-03-21 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"On Booking","per_product_weight":"8Kg","fabric_name123":"Pure Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":8,"productview":"218","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"19th Mar 2024","salelable":""},{"product_id":"405160","product_name":"belliza designer studio sophia vol-2 fancy designer salwar kameez catalogue at reasonable price surat gujrat","brand_name_name":"Belliza Designer studio","cname":"sophia vol-2","product_seo_url":"belliza-designer-studio-sophia-vol-2-fancy-designer-salwar-kameez-catalogue-at-reasonable-price-surat-gujrat","product_image":"https:\/\/prathamexports.com\/images\/product\/2024\/03\/belliza-designer-studio-sophia-vol-2-fancy-designer-salwar-kameez-catalogue-at-reasonable-price-surat-gujrat-2024-03-18_18_28_11.jpg","product_qty":"2","sale_price":"5000","product_price":"625","product_mrp_price":"675","catalog_pcs":"8","regular_price":null,"disable_date":"2024-03-20 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"On Booking","per_product_weight":"8Kg","fabric_name123":"Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":7,"productview":"118","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"18th Mar 2024","salelable":""}],"oo":"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 pm.product_price!=0 and brm.brand_id='44' order by pm.push_to_top_date desc,pm.product_id desc LIMIT 20, 20"}