ArielG143

Lost connection to MySQL server during query(Errno=2013)

Your query:

SELECT COUNT(DISTINCT post_ID) AS item_count,
                          EXTRACT(DAY 

FROM post_datestart) AS myday
                  

FROM (evo_items__item INNER JOIN evo_postcats ON post_ID = postcat_post_ID)
                    INNER JOIN evo_categories ON postcat_cat_ID = cat_ID
                  

WHERE EXTRACT(YEAR 

FROM post_datestart) = '2023'
                    

  AND EXTRACT(MONTH 

FROM post_datestart) = '01'
                     

  AND ( cat_blog_ID = 2147 ) 

  AND ( ( post_status IN ('published') ) ) 

  AND (( post_ptyp_ID IS NULL
                        

  OR post_ptyp_ID NOT IN (1000,1500,1520,1530,1570,1600) ))
                  

GROUP BY myday

MySQL server has gone away(Errno=2006)

Your query:

SELECT agnt_ID 

FROM evo_useragents
         

WHERE agnt_signature = 'CCBot/2.0 (https://commoncrawl.org/faq/)'
           

  AND agnt_type = 'unknown'