Find hereafter the 10 lasts ajaxSearch requests executed with the 1.8.4 demo site.
AjaxSearch logs
| Searchstring | Nb results | Results | Comment | As call | As select | Date | Ip |
|---|---|---|---|---|---|---|---|
| Search here... | 3 | 66 72 97 | [!AjaxSearch? &debug=`3` &language=`english-utf8` &ajaxSearch=`0` &minChars=`3` &AS_showForm=`0` &grabMax=`4` &parents=`61` &asLog=`2:1:10`!] | SELECT sc.id, sc.pagetitle, sc.longtitle, sc.description, sc.alias, sc.introtext, sc.menutitle, sc.content, sc.publishedon, GROUP_CONCAT( DISTINCT CAST(ntv.id AS CHAR) SEPARATOR "," ) AS tv_id, GROUP_CONCAT( DISTINCT ntv.value SEPARATOR ", " ) AS tv_value FROM `mod2_site_content` sc LEFT JOIN( SELECT DISTINCT tv.id, tv.value, tv.contentid FROM `mod2_site_tmplvar_contentvalues` tv WHERE (((tv.value LIKE '%Search%') OR (tv.value LIKE '%here...%'))) ) AS ntv ON sc.id = ntv.contentid WHERE ((sc.id IN (63,308,64,65,66,67,68,69,70,71,72,73,97)) AND (sc.published=1) AND (sc.searchable=1) AND (sc.deleted=0) AND (sc.type='document') AND (sc.privateweb=0)) GROUP BY sc.id HAVING (((sc.pagetitle LIKE '%Search%') OR (sc.longtitle LIKE '%Search%') OR (sc.description LIKE '%Search%') OR (sc.alias LIKE '%Search%') OR (sc.introtext LIKE '%Search%') OR (sc.menutitle LIKE '%Search%') OR (sc.content LIKE '%Search%') OR (tv_value LIKE '%Search%')) OR ((sc.pagetitle LIKE '%here...%') OR (sc.longtitle LIKE '%here...%') OR (sc.description LIKE '%here...%') OR (sc.alias LIKE '%here...%') OR (sc.introtext LIKE '%here...%') OR (sc.menutitle LIKE '%here...%') OR (sc.content LIKE '%here...%') OR (tv_value LIKE '%here...%'))) ORDER BY sc.publishedon,sc.pagetitle | 2010-09-10 10:04:33 | 210.17.234.153 | |
| test | 4 | 64 308 67 71 | [!AjaxSearch? &debug=`3` &language=`english-utf8` &minChars=`3` &parents=`61` &asLog=`2:1:10` &liveSearch=`1` &ajaxMax=`4` &showMoreResults=`1` &moreResultsPage=`274` &opacity=`0.6` &jscript=`mootools1.2`!] | SELECT sc.id, sc.pagetitle, sc.longtitle, sc.description, sc.alias, sc.introtext, sc.menutitle, sc.content, sc.publishedon, GROUP_CONCAT( DISTINCT CAST(ntv.id AS CHAR) SEPARATOR "," ) AS tv_id, GROUP_CONCAT( DISTINCT ntv.value SEPARATOR ", " ) AS tv_value FROM `mod2_site_content` sc LEFT JOIN( SELECT DISTINCT tv.id, tv.value, tv.contentid FROM `mod2_site_tmplvar_contentvalues` tv WHERE (((tv.value LIKE '%test%'))) ) AS ntv ON sc.id = ntv.contentid WHERE ((sc.id IN (63,308,64,65,66,67,68,69,70,71,72,73,97)) AND (sc.published=1) AND (sc.searchable=1) AND (sc.deleted=0) AND (sc.type='document') AND (sc.privateweb=0)) GROUP BY sc.id HAVING (((sc.pagetitle LIKE '%test%') OR (sc.longtitle LIKE '%test%') OR (sc.description LIKE '%test%') OR (sc.alias LIKE '%test%') OR (sc.introtext LIKE '%test%') OR (sc.menutitle LIKE '%test%') OR (sc.content LIKE '%test%') OR (tv_value LIKE '%test%'))) ORDER BY sc.publishedon,sc.pagetitle | 2010-09-10 09:51:13 | 217.7.207.105 | |
| sdasads | 0 | [!AjaxSearch? &debug=`3` &language=`english-utf8` &ajaxSearch=`0` &minChars=`3` &AS_showForm=`0` &extract=`99:content` &parents=`61` &asLog=`2:1:10`!] | SELECT sc.id, sc.pagetitle, sc.longtitle, sc.description, sc.alias, sc.introtext, sc.menutitle, sc.content, sc.publishedon, GROUP_CONCAT( DISTINCT CAST(ntv.id AS CHAR) SEPARATOR "," ) AS tv_id, GROUP_CONCAT( DISTINCT ntv.value SEPARATOR ", " ) AS tv_value FROM `mod2_site_content` sc LEFT JOIN( SELECT DISTINCT tv.id, tv.value, tv.contentid FROM `mod2_site_tmplvar_contentvalues` tv WHERE (((tv.value LIKE '%sdasads%'))) ) AS ntv ON sc.id = ntv.contentid WHERE ((sc.id IN (63,308,64,65,66,67,68,69,70,71,72,73,97)) AND (sc.published=1) AND (sc.searchable=1) AND (sc.deleted=0) AND (sc.type='document') AND (sc.privateweb=0)) GROUP BY sc.id HAVING (((sc.pagetitle LIKE '%sdasads%') OR (sc.longtitle LIKE '%sdasads%') OR (sc.description LIKE '%sdasads%') OR (sc.alias LIKE '%sdasads%') OR (sc.introtext LIKE '%sdasads%') OR (sc.menutitle LIKE '%sdasads%') OR (sc.content LIKE '%sdasads%') OR (tv_value LIKE '%sdasads%'))) ORDER BY sc.publishedon,sc.pagetitle | 2010-09-10 09:41:08 | 210.17.234.153 | ||
| demo | 2 | 70 97 | [!AjaxSearch? &debug=`1` &language=`english-utf8` &minChars=`3` &parents=`61` &tvPhx=`` &asLog=`2:1:10` &liveSearch=`1` &ajaxMax=`4` &showMoreResults=`1` &moreResultsPage=`368` &jscript=`jquery`!] | SELECT sc.id, sc.pagetitle, sc.longtitle, sc.description, sc.alias, sc.introtext, sc.template, sc.menutitle, sc.content, sc.publishedon, GROUP_CONCAT( DISTINCT CAST(ntv.id AS CHAR) SEPARATOR "," ) AS tv_id, GROUP_CONCAT( DISTINCT ntv.value SEPARATOR ", " ) AS tv_value FROM `mod2_site_content` sc LEFT JOIN( SELECT DISTINCT tv.id, tv.value, tv.contentid FROM `mod2_site_tmplvar_contentvalues` tv WHERE (((tv.value LIKE '%demo%'))) ) AS ntv ON sc.id = ntv.contentid WHERE ((sc.id IN (63,308,64,65,66,67,68,69,70,71,72,73,97)) AND (sc.published=1) AND (sc.searchable=1) AND (sc.deleted=0) AND (sc.type='document') AND (sc.privateweb=0)) GROUP BY sc.id HAVING (((sc.pagetitle LIKE '%demo%') OR (sc.longtitle LIKE '%demo%') OR (sc.description LIKE '%demo%') OR (sc.alias LIKE '%demo%') OR (sc.introtext LIKE '%demo%') OR (sc.menutitle LIKE '%demo%') OR (sc.content LIKE '%demo%') OR (tv_value LIKE '%demo%'))) ORDER BY sc.publishedon,sc.pagetitle | 2010-09-08 21:53:29 | 93.223.93.67 | |
| demo | 2 | 70 97 | [!AjaxSearch? &debug=`1` &language=`english-utf8` &minChars=`3` &parents=`61` &tvPhx=`` &asLog=`2:1:10` &liveSearch=`1` &ajaxMax=`4` &showMoreResults=`1` &moreResultsPage=`368` &jscript=`jquery`!] | SELECT sc.id, sc.pagetitle, sc.longtitle, sc.description, sc.alias, sc.introtext, sc.template, sc.menutitle, sc.content, sc.publishedon, GROUP_CONCAT( DISTINCT CAST(ntv.id AS CHAR) SEPARATOR "," ) AS tv_id, GROUP_CONCAT( DISTINCT ntv.value SEPARATOR ", " ) AS tv_value FROM `mod2_site_content` sc LEFT JOIN( SELECT DISTINCT tv.id, tv.value, tv.contentid FROM `mod2_site_tmplvar_contentvalues` tv WHERE (((tv.value LIKE '%demo%'))) ) AS ntv ON sc.id = ntv.contentid WHERE ((sc.id IN (63,308,64,65,66,67,68,69,70,71,72,73,97)) AND (sc.published=1) AND (sc.searchable=1) AND (sc.deleted=0) AND (sc.type='document') AND (sc.privateweb=0)) GROUP BY sc.id HAVING (((sc.pagetitle LIKE '%demo%') OR (sc.longtitle LIKE '%demo%') OR (sc.description LIKE '%demo%') OR (sc.alias LIKE '%demo%') OR (sc.introtext LIKE '%demo%') OR (sc.menutitle LIKE '%demo%') OR (sc.content LIKE '%demo%') OR (tv_value LIKE '%demo%'))) ORDER BY sc.publishedon,sc.pagetitle | 2010-09-08 21:53:19 | 93.223.93.67 | |
| site | 0 | [!AjaxSearch? &debug=`1` &language=`english-utf8` &minChars=`3` &parents=`61` &tvPhx=`` &asLog=`2:1:10` &liveSearch=`1` &ajaxMax=`4` &showMoreResults=`1` &moreResultsPage=`368` &jscript=`jquery`!] | SELECT sc.id, sc.pagetitle, sc.longtitle, sc.description, sc.alias, sc.introtext, sc.template, sc.menutitle, sc.content, sc.publishedon, GROUP_CONCAT( DISTINCT CAST(ntv.id AS CHAR) SEPARATOR "," ) AS tv_id, GROUP_CONCAT( DISTINCT ntv.value SEPARATOR ", " ) AS tv_value FROM `mod2_site_content` sc LEFT JOIN( SELECT DISTINCT tv.id, tv.value, tv.contentid FROM `mod2_site_tmplvar_contentvalues` tv WHERE (((tv.value LIKE '%site%'))) ) AS ntv ON sc.id = ntv.contentid WHERE ((sc.id IN (63,308,64,65,66,67,68,69,70,71,72,73,97)) AND (sc.published=1) AND (sc.searchable=1) AND (sc.deleted=0) AND (sc.type='document') AND (sc.privateweb=0)) GROUP BY sc.id HAVING (((sc.pagetitle LIKE '%site%') OR (sc.longtitle LIKE '%site%') OR (sc.description LIKE '%site%') OR (sc.alias LIKE '%site%') OR (sc.introtext LIKE '%site%') OR (sc.menutitle LIKE '%site%') OR (sc.content LIKE '%site%') OR (tv_value LIKE '%site%'))) ORDER BY sc.publishedon,sc.pagetitle | 2010-09-08 21:53:16 | 93.223.93.67 | ||
| site | 0 | [!AjaxSearch? &debug=`1` &language=`english-utf8` &minChars=`3` &parents=`61` &tvPhx=`` &asLog=`2:1:10` &liveSearch=`1` &ajaxMax=`4` &showMoreResults=`1` &moreResultsPage=`368` &jscript=`jquery`!] | SELECT sc.id, sc.pagetitle, sc.longtitle, sc.description, sc.alias, sc.introtext, sc.template, sc.menutitle, sc.content, sc.publishedon, GROUP_CONCAT( DISTINCT CAST(ntv.id AS CHAR) SEPARATOR "," ) AS tv_id, GROUP_CONCAT( DISTINCT ntv.value SEPARATOR ", " ) AS tv_value FROM `mod2_site_content` sc LEFT JOIN( SELECT DISTINCT tv.id, tv.value, tv.contentid FROM `mod2_site_tmplvar_contentvalues` tv WHERE (((tv.value LIKE '%site%'))) ) AS ntv ON sc.id = ntv.contentid WHERE ((sc.id IN (63,308,64,65,66,67,68,69,70,71,72,73,97)) AND (sc.published=1) AND (sc.searchable=1) AND (sc.deleted=0) AND (sc.type='document') AND (sc.privateweb=0)) GROUP BY sc.id HAVING (((sc.pagetitle LIKE '%site%') OR (sc.longtitle LIKE '%site%') OR (sc.description LIKE '%site%') OR (sc.alias LIKE '%site%') OR (sc.introtext LIKE '%site%') OR (sc.menutitle LIKE '%site%') OR (sc.content LIKE '%site%') OR (tv_value LIKE '%site%'))) ORDER BY sc.publishedon,sc.pagetitle | 2010-09-08 21:53:14 | 93.223.93.67 | ||
| parame | 0 | [!AjaxSearch? &debug=`1` &language=`english-utf8` &minChars=`3` &parents=`61` &tvPhx=`` &asLog=`2:1:10` &liveSearch=`1` &ajaxMax=`4` &showMoreResults=`1` &moreResultsPage=`368` &jscript=`jquery`!] | SELECT sc.id, sc.pagetitle, sc.longtitle, sc.description, sc.alias, sc.introtext, sc.template, sc.menutitle, sc.content, sc.publishedon, GROUP_CONCAT( DISTINCT CAST(ntv.id AS CHAR) SEPARATOR "," ) AS tv_id, GROUP_CONCAT( DISTINCT ntv.value SEPARATOR ", " ) AS tv_value FROM `mod2_site_content` sc LEFT JOIN( SELECT DISTINCT tv.id, tv.value, tv.contentid FROM `mod2_site_tmplvar_contentvalues` tv WHERE (((tv.value LIKE '%parame%'))) ) AS ntv ON sc.id = ntv.contentid WHERE ((sc.id IN (63,308,64,65,66,67,68,69,70,71,72,73,97)) AND (sc.published=1) AND (sc.searchable=1) AND (sc.deleted=0) AND (sc.type='document') AND (sc.privateweb=0)) GROUP BY sc.id HAVING (((sc.pagetitle LIKE '%parame%') OR (sc.longtitle LIKE '%parame%') OR (sc.description LIKE '%parame%') OR (sc.alias LIKE '%parame%') OR (sc.introtext LIKE '%parame%') OR (sc.menutitle LIKE '%parame%') OR (sc.content LIKE '%parame%') OR (tv_value LIKE '%parame%'))) ORDER BY sc.publishedon,sc.pagetitle | 2010-09-08 21:53:10 | 93.223.93.67 | ||
| site | 0 | [!AjaxSearch? &debug=`1` &language=`english-utf8` &minChars=`3` &parents=`61` &tvPhx=`` &asLog=`2:1:10` &liveSearch=`1` &ajaxMax=`4` &showMoreResults=`1` &moreResultsPage=`368` &jscript=`jquery`!] | SELECT sc.id, sc.pagetitle, sc.longtitle, sc.description, sc.alias, sc.introtext, sc.template, sc.menutitle, sc.content, sc.publishedon, GROUP_CONCAT( DISTINCT CAST(ntv.id AS CHAR) SEPARATOR "," ) AS tv_id, GROUP_CONCAT( DISTINCT ntv.value SEPARATOR ", " ) AS tv_value FROM `mod2_site_content` sc LEFT JOIN( SELECT DISTINCT tv.id, tv.value, tv.contentid FROM `mod2_site_tmplvar_contentvalues` tv WHERE (((tv.value LIKE '%site%'))) ) AS ntv ON sc.id = ntv.contentid WHERE ((sc.id IN (63,308,64,65,66,67,68,69,70,71,72,73,97)) AND (sc.published=1) AND (sc.searchable=1) AND (sc.deleted=0) AND (sc.type='document') AND (sc.privateweb=0)) GROUP BY sc.id HAVING (((sc.pagetitle LIKE '%site%') OR (sc.longtitle LIKE '%site%') OR (sc.description LIKE '%site%') OR (sc.alias LIKE '%site%') OR (sc.introtext LIKE '%site%') OR (sc.menutitle LIKE '%site%') OR (sc.content LIKE '%site%') OR (tv_value LIKE '%site%'))) ORDER BY sc.publishedon,sc.pagetitle | 2010-09-08 21:53:06 | 93.223.93.67 |