Спасибо за ответы. Включила отображение ошибок, вот что там:
Table 'хххх_ххххх.ps_shop_url' doesn't exist
SELECT s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM ps_shop_url su
LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'ххххх.ru' OR su.domain_ssl = 'ххххх.ru')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC