SELECT doc.document_title, doc.document_alias, doc.rubric_id, doc.Id, doc.document_parent, ( SELECT COUNT(field.Id) FROM document_fields as field WHERE ( (field.field_value LIKE '%doc.Id%') ) AND rubric_field_id = '16' ) as nums FROM documents as doc WHERE rubric_id = '6' AND document_status = '1' ORDER BY document_title ASC