A PHP Error was encountered

Severity: Notice

Message: Only variable references should be returned by reference

Filename: core/Common.php

Line Number: 257

A PHP Error was encountered

Severity: Warning

Message: Cannot modify header information - headers already sent by (output started at /mnt/stor2-wc1-dfw1/393597/hms.studiomailer.com/web/content/_system_2.1.2/core/Exceptions.php:185)

Filename: libraries/Session.php

Line Number: 672

A PHP Error was encountered

Severity: Warning

Message: Cannot modify header information - headers already sent by (output started at /mnt/stor2-wc1-dfw1/393597/hms.studiomailer.com/web/content/_system_2.1.2/core/Exceptions.php:185)

Filename: core/Common.php

Line Number: 442

Database Error

A Database Error Occurred

Error Number: 1104

The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay

SELECT * FROM ( SELECT tbox_main_news.ID, posted, title, slug, '' as url, GROUP_CONCAT(tbox_main_assignments.team_id) as teams, tbox_main_news.category_id, type_id, is_exclusive, exclusive_expires, has_photo FROM tbox_main_news LEFT JOIN tbox_main_assignments ON tbox_main_assignments.news_id = tbox_main_news.ID WHERE ID IN (SELECT news_id FROM tbox_main_assignments WHERE team_id = '2' && news_id IS NOT NULL) && active = '1' && DATE(posted) <= '2017-08-16' && app_only = '0' GROUP BY ID UNION SELECT tbox_main_blog.ID, posted, title, slug, '' as url, GROUP_CONCAT(tbox_main_assignments.team_id) as teams, tbox_main_blog.category_id, type_id, is_exclusive, exclusive_expires, has_photo FROM tbox_main_blog LEFT JOIN tbox_main_assignments ON tbox_main_assignments.blog_id = tbox_main_blog.ID WHERE ID IN (SELECT blog_id FROM tbox_main_assignments WHERE team_id = '2' && blog_id IS NOT NULL) && active = '1' && DATE(posted) <= '2017-08-16' GROUP BY ID ) as combined ORDER BY posted DESC LIMIT 4

Filename: /mnt/stor2-wc1-dfw1/393597/hms.studiomailer.com/web/content/models/teams_model.php

Line Number: 200