Y'all got any more of them joins?
# Time: 2022-11-25T08:49:06.270019Z
# User@Host: username[username] @ localhost [] Id: 29085
# Query_time: 0.002306 Lock_time: 0.000198 Rows_sent: 20 Rows_examined: 360
SET timestamp=1669366146;
SELECT `liked`.*,`di`.*,`l`.*,`ch`.*,`c`.*,`i`.*,`r`.*,`page`.*, `area`.*,`liked`.`reaction_content_id` AS `like_id`,`iplog2`.`ip` AS `ipaddress`,`iplog`.`ip` AS `creatorip`,`likes`.`reactions`,`likes`.`reaction_users`, `rv`.`vote` AS `myrating`,`rv`.`reason` AS `myratingreason`,`nk`.`readtime` AS `cascadetime`,`sub`.`subscribeid` AS `issubscribed`,`sub`.`notifytype` AS `subscribetype`,`sub`.`options` AS `subscribeoptions`,`mk`.`readtime`,`di`.`userid` AS `disambig_userid`,`l`.`userid` AS `translate_userid`,`ch`.`userid` AS `chapter_userid`,`t`.`discussionid` AS `discussionid`,`t`.`comments` AS `commentcount`,`r`.`dateline` AS `edit_dateline`,`r`.`flags` + 0 AS `flags`,`r`.`parentid` AS `edit_parentid`,`area`.`parentid` AS `parentid`,`area`.`areaid` AS `primaryid`,`area`.`pageid` FROM `xf_vw_area` `area` LEFT JOIN `xf_vw_page` `page` ON (`page`.`pageid` = `area`.`pageid`)
LEFT JOIN `xf_vw_route` `i` ON (`page`.`pageid` = `i`.`itemid` AND `i`.`itemtypeid` = 1)
LEFT JOIN `xf_vw_counter` `c` ON (`c`.`routeid` = `i`.`routeid`)
LEFT JOIN `xf_vw_revision` `r` ON (`r`.`revisionid` = `page`.`revisionid`)
LEFT JOIN `xf_vw_chapter` `ch` ON (`page`.`pageid` = `ch`.`pageid`)
LEFT JOIN `xf_vw_langitem` `l` ON (`page`.`pageid` = `l`.`pageid`)
LEFT JOIN `xf_vw_disambigitem` `di` ON (`page`.`pageid` = `di`.`contentid` AND `di`.`contenttypeid` = 1)
LEFT JOIN `xf_vw_discussion` `t` ON (`t`.`contentid` = `page`.`pageid` AND `t`.`displayorder` = 0 AND `t`.`contenttypeid` = 1)
LEFT JOIN `xf_vw_markread` `mk` ON (`mk`.`itemtypeid` = 1 AND `mk`.`itemid` = `page`.`pageid` AND `mk`.`userid` = 8)
LEFT JOIN `xf_vw_subscribe` `sub` ON (`sub`.`nodetypeid` = 1 AND `sub`.`nodeid` = `page`.`pageid` AND `sub`.`userid` = 8)
LEFT JOIN `xf_vw_noderead` `nk` ON (`nk`.`nodeid` = `page`.`pageid` AND `nk`.`nodetypeid` = 1 AND `nk`.`userid` = 8)
LEFT JOIN `xf_vw_rate` `rv` ON (`rv`.`contenttypeid` = 7 AND `rv`.`contentid` = `page`.`revisionid` AND `rv`.`userid` = 8)
LEFT JOIN `xf_vw_reactions` `likes` ON (`likes`.`itemtypeid` = 1 AND `likes`.`itemid` = `page`.`pageid`)
LEFT JOIN `xf_ip` `iplog` ON (`iplog`.`ip_id` = `page`.`creator_ip_id`)
LEFT JOIN `xf_ip` `iplog2` ON (`iplog2`.`ip_id` = `r`.`ip_id`)
LEFT JOIN `xf_reaction_content` `liked` ON (`liked`.`content_type` = 'vwpage' AND `liked`.`content_id` = `page`.`pageid` AND `liked`.`reaction_user_id` = 8) WHERE 0 < `page`.`areaid` ORDER BY `area`.`displayorder` ASC;