Public feed
#721537
$query = "
SELECT webpage_id AS id, webspace_id, webpage_name AS name, concat_ws('index.php?wp=', webpage_name) AS link
FROM " . $db->prefix . "_webpage
WHERE webpage_body LIKE " . $db->qstr($pattern) . "
UNION
SELECT stylesheet_id AS id, webspace_id, stylesheet_name AS name, 'stylesheet_editor.php?stylesheet_id=' AS link
FROM " . $db->prefix . "_stylesheet
WHERE stylesheet_body LIKE " . $db->qstr($pattern) . "
UNION
SELECT block_id AS id, webspace_id, block_name AS name, 'index.php?t=block_editor&block_id=' AS link
FROM " . $db->prefix . "_block
WHERE block_body LIKE " . $db->qstr($pattern) . "
UNION
SELECT subject_id AS id, webspace_id, subject_title AS name, concat('index.php?wp=', subject_title, '&subject_id=', subject_id) AS link
FROM " . $db->prefix . "_plugin_forum_subject
WHERE subject_body LIKE " . $db->qstr($pattern) . "";