user warning: Table 'mpoopt_db.pers_comm' doesn't exist
query:
SELECT DISTINCT node.nid as id_doc,
node.title as doc_short,
content_field_doc_name.field_doc_name_value as doc_full,
content_type_doc_bio.field_doc_region_value as id_rb,
content_field_doc_number.field_doc_number_value as doc_num,
content_field_doc_authority.field_doc_authority_value as doc_author,
substring_index(content_field_doc_date.field_doc_date_value, 'T', 1) as doc_date,
node.type
FROM maroopt2.rb_categories
LEFT JOIN node on rb_categories.id_doc = node.nid
LEFT JOIN content_field_doc_name ON node.vid = content_field_doc_name.vid
LEFT JOIN content_field_doc_number ON node.vid = content_field_doc_number.vid
LEFT JOIN content_field_doc_authority ON node.vid = content_field_doc_authority.vid
LEFT JOIN content_field_doc_date ON node.vid = content_field_doc_date.vid
LEFT JOIN content_type_doc_bio ON node.vid = content_type_doc_bio.vid
WHERE node.status <> 0 AND node.type = 'doc_bio' AND content_type_doc_bio.field_doc_region_value = 2405 and cat_group = 'an'
UNION (SELECT ref_tbl.id_ref, ref_tbl.title, ref_tbl.title, rb_refs.id_rb, 0, '', ref_tbl.ref_year, 'ref'
FROM maroopt2.ref_tbl
LEFT OUTER JOIN maroopt2.rb_categories ON ref_tbl.id_ref = rb_categories.id_ref
LEFT OUTER JOIN maroopt2.rb_refs ON ref_tbl.id_ref = rb_refs.id_ref
WHERE rb_refs.id_ref IS NOT NULL AND rb_categories.id_ref IS NOT NULL AND rb_refs.id_rb = 2405 AND rb_categories.cat_group = 'an')
UNION (SELECT pers_comm.id_comm, pers_comm.title, pers_comm.title, pers_comm.id_rb, 0, '', pers_comm.comm_year, 'comm'
FROM pers_comm
LEFT OUTER JOIN maroopt2.rb_categories ON pers_comm.id_comm = rb_categories.id_comm
WHERE pers_comm.id_rb = 2405 AND rb_categories.cat_group = 'an')
ORDER BY doc_date desc in D:\inetpub\mpoopt\sites\all\modules\bio\bio_rbdata.inc on line 81.
user warning: Table 'mpoopt_db.pers_comm' doesn't exist
query:
SELECT DISTINCT node.nid as id_doc,
node.title as doc_short,
content_field_doc_name.field_doc_name_value as doc_full,
content_type_doc_bio.field_doc_region_value as id_rb,
content_field_doc_number.field_doc_number_value as doc_num,
content_field_doc_authority.field_doc_authority_value as doc_author,
substring_index(content_field_doc_date.field_doc_date_value, 'T', 1) as doc_date,
node.type
FROM maroopt2.rb_categories
LEFT JOIN node on rb_categories.id_doc = node.nid
LEFT JOIN content_field_doc_name ON node.vid = content_field_doc_name.vid
LEFT JOIN content_field_doc_number ON node.vid = content_field_doc_number.vid
LEFT JOIN content_field_doc_authority ON node.vid = content_field_doc_authority.vid
LEFT JOIN content_field_doc_date ON node.vid = content_field_doc_date.vid
LEFT JOIN content_type_doc_bio ON node.vid = content_type_doc_bio.vid
WHERE node.status <> 0 AND node.type = 'doc_bio' AND content_type_doc_bio.field_doc_region_value = 2405 and cat_group = 'pl'
UNION (SELECT ref_tbl.id_ref, ref_tbl.title, ref_tbl.title, rb_refs.id_rb, 0, '', ref_tbl.ref_year, 'ref'
FROM maroopt2.ref_tbl
LEFT OUTER JOIN maroopt2.rb_categories ON ref_tbl.id_ref = rb_categories.id_ref
LEFT OUTER JOIN maroopt2.rb_refs ON ref_tbl.id_ref = rb_refs.id_ref
WHERE rb_refs.id_ref IS NOT NULL AND rb_categories.id_ref IS NOT NULL AND rb_refs.id_rb = 2405 AND rb_categories.cat_group = 'pl')
UNION (SELECT pers_comm.id_comm, pers_comm.title, pers_comm.title, pers_comm.id_rb, 0, '', pers_comm.comm_year, 'comm'
FROM pers_comm
LEFT OUTER JOIN maroopt2.rb_categories ON pers_comm.id_comm = rb_categories.id_comm
WHERE pers_comm.id_rb = 2405 AND rb_categories.cat_group = 'pl')
ORDER BY doc_date desc in D:\inetpub\mpoopt\sites\all\modules\bio\bio_rbdata.inc on line 81.
user warning: Table 'mpoopt_db.bio_rb_actual_lists' doesn't exist
query: SELECT EXISTS (SELECT 1 FROM bio_rb_actual_lists WHERE id_rb = 2405 AND list_cat <> 'rl' AND is_actual) in D:\inetpub\mpoopt\sites\all\modules\bio\bio.module on line 566.