Ulf Gebhardt
ea19cf8d71
replace all get_class() calls without argument which is depected from php 8.3 onward
16 lines
445 B
PHP
16 lines
445 B
PHP
<?php
|
|
namespace SQL;
|
|
|
|
class CONTACTS_COUNT_LIST extends \SYSTEM\DB\QP {
|
|
public static function get_class(){return static::class;}
|
|
public static function mysql(){return
|
|
'SELECT COUNT(*) as `count` FROM contact
|
|
LEFT JOIN contact_email_list ON contact.email = contact_email_list.email
|
|
WHERE list = ? AND
|
|
( contact.email LIKE ? OR
|
|
contact.name_first LIKE ? OR
|
|
contact.name_last LIKE ? OR
|
|
contact.organization LIKE ?
|
|
);';
|
|
}
|
|
} |