select * from ignoreword where word='Barron's' 

select id from stat_globaluid where statuid='20260517180001_1618' 

DELETE FROM stat_globaluid
			WHERE id NOT IN (
			  SELECT id
			  FROM (
				SELECT id
				FROM stat_globaluid
				ORDER BY id DESC
				LIMIT 100
			  ) foo
			); 

insert into stat_globaluid set
		statuid='20260517180001_1618',
		dt='1779015601',
		phpself='/ULIB62015/advsearching.php',
		agent='Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)',
		yea='2026',
		mon='5',
		dat='17',
		ip='216.73.216.45'
		
		

select id from statordr_search_text where head='Barron\'s Educational Series,' and yea='2026' and mon='05'  

insert into statordr_search_text set 
			 head='Barron\'s Educational Series,' ,
			  cc=1 ,
			 statuid='20260517180001_1618' ,
			  yea=2026 ,
			  mon=05 ,
				lastdt='1779015601' 
		

select count(id) as tmpqcount FROM index_db where  ispublish='yes' and 1     AnD   (  (auth like '%Barron's%' )   
 ) 
 AnD  (  (auth like '%Educational%' )   
 ) 
 AnD  (  (auth like '%Series,%' )   
 ) 
 

SELECT id,titl,auth,bibrating,mid,remoteindex FROM index_db where  ispublish='yes' and 1     AnD   (  (auth like '%Barron's%' )   
 ) 
 AnD  (  (auth like '%Educational%' )   
 ) 
 AnD  (  (auth like '%Series,%' )   
 ) 
  order by auth asc,titl asc LIMIT 0,12

SELECT id,titl,auth,bibrating,mid,remoteindex FROM index_db where  ispublish='yes' and 1     AnD   (  (auth like '%Barron's%' )   
 ) 
 AnD  (  (auth like '%Educational%' )   
 ) 
 AnD  (  (auth like '%Series,%' )   
 ) 
  order by auth asc,titl asc

เธžเธšเธˆเธณเธ™เธงเธ™ 0 เธฃเธฒเธขเธเธฒเธฃ
 เธ„เน‰เธ™เธซเธฒ เธŠเธทเนˆเธญเธœเธนเน‰เนเธ•เนˆเธ‡ Barron's Educational Series

select id from stat_globaluid where statuid='20260517180001_1618' 

DELETE FROM stat_globaluid
			WHERE id NOT IN (
			  SELECT id
			  FROM (
				SELECT id
				FROM stat_globaluid
				ORDER BY id DESC
				LIMIT 100
			  ) foo
			); 

insert into stat_globaluid set
		statuid='20260517180001_1618',
		dt='1779015602',
		phpself='/ULIB62015/advsearching.php',
		agent='Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)',
		yea='2026',
		mon='5',
		dat='17',
		ip='216.73.216.45'
		
		

select id from statordr_searchnotfound_text where head=' ชื่อผู้แต่ง::l::Author' and yea='2026' and mon='05'  

insert into statordr_searchnotfound_text set 
			 head=' ชื่อผู้แต่ง::l::Author' ,
			  cc=1 ,
			 statuid='20260517180001_1618' ,
			  yea=2026 ,
			  mon=05 ,
				lastdt='1779015602'