{"breadcumb":"","main_ca_enable_res":0,"query":"Select pws.show_product_always, pws.show_product_enable, pws.show_product_sdate, pws.show_product_edate, p.id, p.item_no, p.item_name, p.item_description, p.front_pic, p.mk_price , p.wh_price , p.af_price,p.op_price, p.unit,p.is_catalog, p.catalog_qty, p.brand_name from products p \r\n\t\tINNER JOIN pcategory_product cp ON cp.product_id = p.id \r\n\t\tINNER JOIN productdisplaywebsite pd ON pd.prdid = p.id \r\n\t\tINNER JOIN product_web_settings pws on pws.prdid=p.id \r\n\twhere p.id <> 0 AND p.prd_status = 'active' AND pd.websiteid = '' AND pws.show_product_always='true' AND \r\n\t\t( CASE WHEN pws.show_product_enable = 'true' THEN show_product_sdate<= DATE(now()) AND show_product_edate>= DATE(now()) \r\n\t\tELSE -1 \r\n\t\tEND) group by p.id ","result":[],"pricerangequery":"Not applied.","postarray":[],"row_count":0}