crear nuevo módulo

[inspectorflint]

Joe:
la consulta es:

SELECT SQL_CALC_FOUND_ROWS vtiger_crmentity.*, vtiger_rutas.*, vtiger_rutascf.* FROM vtiger_rutas INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid = vtiger_rutas.rutasid INNER JOIN vtiger_rutascf ON vtiger_rutascf.rutasid = vtiger_rutas.rutasid LEFT JOIN vtiger_users ON vtiger_users.id = vtiger_crmentity.smownerid LEFT JOIN vtiger_groups ON vtiger_groups.groupid = vtiger_crmentity.smownerid LEFT JOIN vtiger_account ON vtiger_account.accountid = vtiger_rutascf.cf_1178 WHERE vtiger_rutas.rutasid>0 AND vtiger_crmentity.deleted=0 and vtiger_rutas.rutasid not in (8427) LIMIT 0,20

Devuelve datos