query
RESULTSET
query
  CONTENT DATE_ACTION DATE_CREATED ID NAME NEWS PAGE_ID TITLE
CACHED false
EXECUTIONTIME 0
SQL SELECT t1.id,t1.content, t1.small_content as news, t1.date_created, t1.title, t2.name, t2.page_id, t1.date_action FROM raphael.tbl_news as t1 JOIN raphael.tbl_news_category as t2 on (t2.id = t1.category_id) WHERE t1.category_id = ? AND t1.actief = 1 AND t1.active = 1 AND t1.date_action BETWEEN ? and ? ORDER BY t1.date_action asc
SQLPARAMETERS
array
1 1
2 2016-09-29
3 2016-09-10
09/10/2016 nu= {ts '2016-09-29 20:50:11'}