Hi! Could we please enable some services and cookies to improve your experience and our website?
Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code
<?php
$result = $mysqli->query(
"SELECT field_image_fid, filename, title
FROM field_revision_field_image, file_managed, node
WHERE
file_managed.fid = field_revision_field_image.field_image_fid AND
field_revision_field_image.bundle = 'article' AND
node.type = 'article';"
);
while ($row = $result->fetch_assoc()) {
print "URI : " . $row["filename"] . "; title: . " . $row["title"] . "<br>";
}