Welcome back!
Please provide credientals to access your account.
SELECT sponsee_list.page, t1.type, COALESCE(c1.cat_l10,c1.cat_l9,c1.cat_l8,c1.cat_l7,c1.cat_l6,c1.cat_l5,c1.cat_l4,c1.cat_l3,c1.cat_l2,c1.cat_l1,'BSR') AS category, filename, extension, ratio_n, ratio_d, title, identifier, '' AS validation_code, '' AS impression_id, credits, modified
FROM sponsee AS sponsee_list
LEFT JOIN (SELECT zic, type FROM zic) AS t1 ON (sponsee_list.page = t1.zic)
LEFT JOIN (SELECT zic, cat_l1, cat_l2, cat_l3, cat_l4, cat_l5, cat_l6, cat_l7, cat_l8, cat_l9, cat_l10 FROM zic_category WHERE status = 'visible') AS c1 ON (sponsee_list.page = c1.zic)
LEFT JOIN (SELECT page, filename, extension, ratio_n, ratio_d FROM image WHERE type = 'logo' AND status = 'visible') AS i1 ON (sponsee_list.page = i1.page)
LEFT JOIN (SELECT parent_zic, content AS title FROM text WHERE type = 'title' AND status = 'visible') AS t2 ON (sponsee_list.page = t2.parent_zic)
LEFT JOIN (SELECT parent_zic, content AS identifier FROM text WHERE (type = 'handle' OR type = 'upc' OR type = 'ean' OR type = 'isbn' OR type = 'gtin') AND status = 'visible') AS i2 ON (sponsee_list.page = i2.parent_zic)
WHERE 1 AND t1.type = ? AND credits >= 1 AND COALESCE(c1.cat_l10,c1.cat_l9,c1.cat_l8,c1.cat_l7,c1.cat_l6,c1.cat_l5,c1.cat_l4,c1.cat_l3,c1.cat_l2,c1.cat_l1,'BSR') = ? ORDER BY modified ASC LIMIT 1Array
