The SQL query generated by the following API call lacks of proper FROM-clause for "omu" alias:
— BEGIN PHP —
$options['usrgrpids'] = 3;
$options['scriptids'] = 19;
API::Action()->get($options);
— END PHP —
— BEGIN generated SQL —
SELECT a.actionid,
omu.userid,
oc.scriptid
FROM actions a,
opcommand oc,
operations o
WHERE a.actionid BETWEEN 000000000000000 AND 099999999999999
AND omu.userid='3'
AND a.actionid=o.actionid
AND o.operationid=omu.operationid
AND (oc.scriptid='19'
AND oc.type=4)
AND o.operationid=oc.operationid
— END generated SQL —