Can any one make a documentation of the query for me the query code is
"SELECT t.*, SUM(t.item_qty) as count, t.created, t.status, t.ip, t.active as tactive,
SUM(t.downloads) as file_downloads, FROM_UNIXTIME(t.file_date,'%M %e %Y, %H:%i') as registered, t.id as tid, MAX(t.file_date) as file_date,"
. " \n p.id as pid, p.title, p.description, p.expiry, p.active as pactive, p.price, p.slug, p.metakeys, p.metadesc,"
. " \n f.id AS fid, f.alias, f.filesize,"
. " \n u.id AS uid"
. " \n FROM transactions as t"
. " \n LEFT JOIN " . $this->pTable . " as p ON t.pid = p.id"
. " \n LEFT JOIN files as f ON p.file_id = f.id"
. " \n LEFT JOIN users AS u ON t.uid = u.id"
. " \n WHERE t.pid = '" . $this->pid . "' AND t.uid = '" . $user->uid . "' AND t.status = '1'"
. " \n GROUP BY p.id";