Loading grounds images [0]: SELECT a.id, a.name, b.company, c.name AS company_name, b.id AS branch, b.name AS branch_name, f.shareable_url, f.image_height, f.image_width, cu.url, i.id AS asset_image, fi.shareable_url AS ai_shareable_url, fi.image_height AS ai_image_height, fi.image_width AS ai_image_width FROM assets a INNER JOIN asset_categories ac ON ac.id = a.asset_category INNER JOIN branches b ON b.id = a.store INNER JOIN companies c ON c.id = b.company INNER JOIN files f ON f.id = c.image_id_compressed INNER JOIN company_urls cu ON c.id = cu.company INNER JOIN asset_images i ON a.id = i.asset AND i.status = 1 INNER JOIN files fi ON fi.id = i.image WHERE a.publish_sports = 1 ORDER BY b.name, a.name