saimod_mail/sql/CONTACT_EMAIL_LIST_SELECT_LIST.php
Ulf Gebhardt ea19cf8d71
php8.3 fix
replace all get_class() calls without argument which is depected from
php 8.3 onward
2024-11-19 22:40:17 +01:00

12 lines
417 B
PHP

<?php
namespace SQL;
class CONTACT_EMAIL_LIST_SELECT_LIST extends \SYSTEM\DB\QP {
public static function get_class(){return static::class;}
public static function mysql(){return
'SELECT contact_email_list.email, email_sent.email as done FROM contact_email_list'.
' LEFT JOIN email_sent ON contact_email_list.email = email_sent.email AND email_sent.id = ?'.
' WHERE list = ?'.
' HAVING done IS NULL;';
}
}