$is_available = 1;
$sql_query = "SELECT * FROM table WHERE dates_list LIKE '%2015-11-20|{$is_available}%' OR dates_list LIKE '%2016-01-03|{$is_available}%' OR ..."SELECT table1.*, (SELECT count(id) FROM table2 WHERE table1_id=table1.id AND filter...)
FROM table1