Retrievd: I: 0, N: Loading Branch [{"ccode":"enmb","cname":"","id":0,"name":"","from_url":true,"load_company":true}]: SELECT b.id, b.name, b.receive_supplier_stock, c.id AS company_id, c.name AS company_name, c.code AS company_code, c.services, c.last_data_update, b.pricelist, b.project, p.name AS pricelist_name, b.ws_pricelist, p2.name AS ws_pricelist_name, online_orders, b.default_online_order_billing, b.offers_delivery, b.has_logistics, b.logistics_provider, b.for_dispatch, b.retained_earnings, b.place, b.autoclose_tabs, b.numSTKPushPaybills, b.can_have_assets, b.running_stocks, b.has_social_events FROM branches b INNER JOIN companies c ON c.id = b.company LEFT JOIN pricelists p ON p.id = b.pricelist LEFT JOIN pricelists p2 ON p2.id = b.ws_pricelist WHERE b.status = 1 AND (c.code = 'enmb' OR c.name = '') AND (b.online_orders = 1 OR b.id IN (SELECT branch FROM portfolio_branches WHERE status = 1) OR b.id IN (SELECT store FROM assets WHERE publish_sports = 1)) ORDER BY b.name Retrievd: I: 0, N:
QueueNot