select ta.`action`, ta.`lastModif`, ta.`user`, ta.`ip`, ta.`pageName`,ta.`comment`, th.`version` as version, tp.`version` as versionlast from `tiki_actionlog` ta
left join `tiki_history` th on ta.`pageName`=th.`pageName` and ta.`lastModif`=th.`lastModif`
left join `tiki_pages` tp on ta.`pageName`=tp.`pageName` and ta.`lastModif`=tp.`lastModif` where (th.`version` != 0 or tp.`version` != 0) and ta.`lastModif`>=? and ta.`lastModif`<=? order by ta.`lastModif` desc