sql Если товар пропал с продажи, то удаляет его из избранного
if (!function_exists('get_sql')) {
function get_sql() {
require($_SERVER['DOCUMENT_ROOT'].'/bitrix/php_interface/dbconn.php');
$sql = new mysqli(
$DBHost,
$DBLogin,
$DBPassword,
$DBName
);
if ($sql->connect_errno) {
add_log([$sql->connect_errno, $sql->connect_error]);
return false;
}
$sql->set_charset('utf8');
return $sql;
}
}
$sql = get_sql();
$sql->query("
DELETE b_redsign_favorite
FROM b_redsign_favorite
LEFT JOIN b_iblock_element AS element
ON b_redsign_favorite.ELEMENT_ID = element.ID AND
element.IBLOCK_ID = '20'
AND element.ACTIVE = 'Y'
WHERE
element.ID IS NULL
");