
8 Kwi
2013
8 Kwi
'13
12:45
W dniu 08.04.2013 11:53, JOYNET pisze:
UPDATE nodes SET access=0 WHERE NOT ownerid = 0 AND access = 1 AND NOT EXISTS (SELECT id FROM assignments a WHERE a.customerid = nodes.ownerid AND (a.dateto >= UNIX_TIMESTAMP(NOW()) OR a.dateto = 0));
Wielkie dzięki - działa :)