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

select id from stat_globaluid where statuid='20260331211916_4689' 

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='20260331211916_4689',
		dt='1774966756',
		phpself='/ULIB62015/searching.php',
		agent='Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)',
		yea='2026',
		mon='3',
		dat='31',
		ip='216.73.216.148'
		
		

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

insert into statordr_search_text set 
			 head='Barron\'s Educational Series,' ,
			  cc=1 ,
			 statuid='20260331211916_4689' ,
			  yea=2026 ,
			  mon=03 ,
				lastdt='1774966756' 
		

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 bibrating desc,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 bibrating desc,titl asc

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

select id from stat_globaluid where statuid='20260331211916_4689' 

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='20260331211916_4689',
		dt='1774966757',
		phpself='/ULIB62015/searching.php',
		agent='Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)',
		yea='2026',
		mon='3',
		dat='31',
		ip='216.73.216.148'
		
		

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

insert into statordr_searchnotfound_text set 
			 head=' ชื่อผู้แต่ง::l::Author' ,
			  cc=1 ,
			 statuid='20260331211916_4689' ,
			  yea=2026 ,
			  mon=03 ,
				lastdt='1774966757'