<div class="gmail_quote">HI,<div><font color="#001730" face="Arial, Helvetica, sans-serif"><span style="font-size:12px">I an not the one who instal it, but it is local slapos, with </span></font><a href="http://bsys2.dyndns.org:12001/erp5/portal_templates/6?ignore_layout:int=1&amp;editable_mode:int=1&amp;selection_name=business_template_selection&amp;selection_index=0&amp;reset:int=1" style="text-align:left;color:rgb(0,46,63);font-size:12px;font-family:Arial,Helvetica,sans-serif;text-decoration:none" target="_blank">erp5_full_text_myisam_catalog</a>, verzion 5.4.7. revision 4.</div>

<div>I run the script and i get results:</div><div><br></div><div>first good page:</div><div><div>SELECT DISTINCT</div><div>   catalog.path,   catalog.uid    </div><div>FROM</div><div>             full_text AS related_child_address_SearchableText_1_full_text, catalog AS catalog, catalog AS related_child_address_SearchableText_catalog          </div>

<div>WHERE </div><div>  1 = 1 </div><div>  AND (((`catalog`.`security_uid` IN (73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93)</div><div>  OR `catalog`.`viewable_owner` = &#39;zope&#39;)</div>

<div>  AND `catalog`.`portal_type` = &#39;Person&#39;</div><div>  AND `related_child_address_SearchableText_1_full_text`.`SearchableText` LIKE &#39;%praha 7%&#39;)</div><div>  AND (catalog.uid = related_child_address_SearchableText_catalog.parent_uid</div>

<div>AND related_child_address_SearchableText_catalog.portal_type = &#39;Address&#39;</div><div>AND related_child_address_SearchableText_catalog.uid =  related_child_address_SearchableText_1_full_text.uid))</div><div>LIMIT 1000</div>

</div><div><br></div><div>second bad page:</div><div><pre style="word-wrap:break-word;white-space:pre-wrap"><font face="trebuchet ms, sans-serif">SELECT DISTINCT
   catalog.path,   catalog.uid    ,MATCH (`related_child_address_SearchableText_1_full_text`.`SearchableText`) AGAINST (&#39;%praha 7%&#39;) AS `SearchableText`
FROM
             full_text AS related_child_address_SearchableText_1_full_text, catalog AS catalog, catalog AS related_child_address_SearchableText_catalog          
WHERE 
  1 = 1 
  AND (((`catalog`.`security_uid` IN (73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93)
  OR `catalog`.`viewable_owner` = &#39;zope&#39;)
  AND `catalog`.`portal_type` = &#39;Person&#39;
  AND MATCH (`related_child_address_SearchableText_1_full_text`.`SearchableText`) AGAINST (&#39;%praha 7%&#39;))
  AND (catalog.uid = related_child_address_SearchableText_catalog.parent_uid
AND related_child_address_SearchableText_catalog.portal_type = &#39;Address&#39;
AND related_child_address_SearchableText_catalog.uid =  related_child_address_SearchableText_1_full_text.uid))
LIMIT 1000</font></pre></div><div><br></div><div>Is it possible to change some script to get the same result? or instal some other <span style="color:rgb(34,34,34);font-size:13px;font-family:arial,sans-serif">fulltext business template to get better results?</span></div>

<div><br></div><div>Pavel Lstiburek</div></div>