^ """
SELECT s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main\n
                    FROM cbdev1_shop_url su\n
                    LEFT JOIN cbdev1_shop s ON (s.id_shop = su.id_shop)\n
                    WHERE (su.domain = 'cb-dev1-1.gobuild.co.za' OR su.domain_ssl = 'cb-dev1-1.gobuild.co.za')\n
                        AND s.active = 1\n
                        AND s.deleted = 0\n
                    ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
"""