orm Joomla

 

$query->select([id, filename]);

$query->from(#__k2_attachments);

$query->where(‘id=’.$idattach);

#

$db->setQuery((string)$query);

#

$resultado = $db->loadAssocList();