Link to an image or video in another file that has an \x on title from another file
ID: sponsor/updates/5/link-to-an-image-or-video-in-another-file-that-has-an-x-on-title-from-another-file
Link to an image or video in another file that has an 
Ciro Santilli 35 Updated 2025-03-25 +Created 1970-01-01
\x on title from another file by Ciro Santilli 35 Updated 2025-03-25 +Created 1970-01-01Issue report at: github.com/ourbigbook/ourbigbook/issues/198 Suppose you had:
programming-language.ciro
= Programming language
\Image[https://raw.githubusercontent.com/cirosantilli/media/master/python-logo.jpg]
{title=The \x[python-programming-language] logo}
== Python
{c}
{disambiguate=programming-language}logos-i-like.ciro
= Logos I like
\x[image-the-python-logo]Now, when rendering
\x[image-the-python-logo], we would need to fetch two IDs:image-the-python-logofor theTheandlogopartpython-programming-languageitself, to know that\x[python-programming-language]should render asPython
But after group all SQL queries together was done, there was no way to know that rendering
image-the-python-logo would imply also fetching python-programming-language.This was solved by adding a new database entry type,
REFS_TABLE_X_TITLE_TITLE to the existing References table, which tracks dependencies between IDs.After this was setup, we can now know that
image-the-python-logo depends on image-the-python-logo, and then fetch both of them together in a single JOIN. New to topics? Read the docs here!