Exception

Database Exceptionyii\db\Exception

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND programs.start_date >= DATE_ADD(NOW(), INTERVAL -1 DAY)' at line 1
The SQL being executed was: SELECT COUNT(*) FROM `programs` LEFT JOIN `topics` `t` ON t.id=programs.topic_id LEFT JOIN `topic_categories` `tc` ON tc.id=t.subcategory LEFT JOIN `industry` `indsty` ON indsty.id=tc.industry_id WHERE programs.delivery_type='live' AND programs.event_category_id IN (7,4) and indsty.id IN ( '12' ) and tc.id IN () AND programs.start_date >= DATE_ADD(NOW(), INTERVAL -1 DAY)

Error Info: Array
(
    [0] => 42000
    [1] => 1064
    [2] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND programs.start_date >= DATE_ADD(NOW(), INTERVAL -1 DAY)' at line 1
)
$_GET = [
    'findindustry' => '12',
    'fcourse' => 'all',
    'fsub' => 'Automobile-%7C-HiTech',
];

$_SESSION = [
    '__flash' => [],
    'countrycode' => 'US',
    'continentcode' => 'North America',
    'contryid' => 1,
    'continentid' => 1,
    'currency' => 'USD',
    'citycode' => 'NY',
    'cityid' => 0,
    'searchkeyword' => '',
];