ERRORE: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) query SQL: [
SELECT *
FROM tbl_users
WHERE data_registrazione BETWEEN DATE_SUB(NOW(),INTERVAL 96 HOUR) AND DATE_SUB(NOW(),INTERVAL 48 HOUR) AND active = '0'
]
ERRORE: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) query SQL: [
update tbl_users
set active = '2'
WHERE data_registrazione BETWEEN DATE_SUB(NOW(),INTERVAL 96 HOUR) AND DATE_SUB(NOW(),INTERVAL 48 HOUR) AND active = '0'
]
ERRORE: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) query SQL: [
SELECT *
FROM tbl_users
WHERE data_registrazione < DATE_SUB(NOW(),INTERVAL 96 HOUR) AND (active = '2' OR active = '0')
]
ERRORE: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) query SQL: [
SELECT p.*, p.id AS id_photo, t.*, DATE_FORMAT(p.data_inserimento,'%Y-%m-%dT%H:%i:%SZ') AS data_inserimento_formato, c.*, l.*, u.*
FROM tbl_tags t, tbl_photo_tags pt
LEFT JOIN tbl_photo p ON (pt.id_photo = p.id)
LEFT JOIN tbl_categories c ON (p.id_category=c.id)
LEFT JOIN tbl_albums l ON (p.id_album=l.id)
LEFT JOIN tbl_users u ON (p.id_users=u.id)
WHERE p.active='1' AND u.active='1' AND t.tag_url='mariaceleste03' AND t.id = pt.id_tags
GROUP by p.id
ORDER BY p.data_inserimento
LIMIT 15
]