SELECT s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
                    FROM newps_shop_url su
                    LEFT JOIN newps_shop s ON (s.id_shop = su.id_shop)
                    WHERE (su.domain = 'nicovip-dev.progs.ovh' OR su.domain_ssl = 'nicovip-dev.progs.ovh')
                        AND s.active = 1
                        AND s.deleted = 0
                    ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC