SELECT * FROM 
    (
	    (SELECT COUNT(*) AS Searches_Today FROM customer_searches WHERE client_id = '' AND dated BETWEEN '2025-04-17 00:00:00' AND '2025-04-17 23:59:59') TODAY_SEARCHES, 
	    (SELECT COUNT(*) AS Searches_This_Week FROM customer_searches WHERE client_id = '' AND dated BETWEEN '2025-04-06 00:00:00' AND '2025-04-12 23:59:59') THIS_WEEK_SEARCHES, 
	    (SELECT COUNT(*) AS Searches_This_Month FROM customer_searches WHERE client_id = '' AND dated BETWEEN '2025-04-01 00:00:00' AND '2025-04-30 23:59:59') THIS_MONTH_SEARCHES, 
	    (SELECT COUNT(*) AS Searches_Last_Month FROM customer_searches WHERE client_id = '' AND dated BETWEEN '2025-03-01 00:00:00' AND '2025-03-31 23:59:59') LAST_MONTH_SEARCHES, 
	    (SELECT COUNT(*) AS Searches_This_Year FROM customer_searches WHERE client_id = '' AND dated BETWEEN '2025-01-01 00:00:00' AND '2025-12-31 23:59:59') THIS_YEAR_SEARCHES, 
	    (SELECT COUNT(*) AS Searches_Last_Year FROM customer_searches WHERE client_id = '' AND dated BETWEEN '2024-04-01 00:00:00' AND '2024-04-30 23:59:59') LAST_YEAR_SEARCHES,
	    (SELECT COUNT(*) AS Entries_Today FROM customer_credits WHERE client_id = '' AND dated BETWEEN '2025-04-17 00:00:00' AND '2025-04-17 23:59:59') TODAY_ENTRIES, 
	    (SELECT COUNT(*) AS Entries_This_Week FROM customer_credits WHERE client_id = '' AND dated BETWEEN '2025-04-06 00:00:00' AND '2025-04-12 23:59:59') THIS_WEEK_ENTRIES, 
	    (SELECT COUNT(*) AS Entries_This_Month FROM customer_credits WHERE client_id = '' AND dated BETWEEN '2025-04-01 00:00:00' AND '2025-04-30 23:59:59') THIS_MONTH_ENTRIES, 
	    (SELECT COUNT(*) AS Entries_Last_Month FROM customer_credits WHERE client_id = '' AND dated BETWEEN '2025-03-01 00:00:00' AND '2025-03-31 23:59:59') LAST_MONTH_ENTRIES, 
	    (SELECT COUNT(*) AS Entries_This_Year FROM customer_credits WHERE client_id = '' AND dated BETWEEN '2025-01-01 00:00:00' AND '2025-12-31 23:59:59') THIS_YEAR_ENTRIES, 
	    (SELECT COUNT(*) AS Entries_Last_Year FROM customer_credits WHERE client_id = '' AND dated BETWEEN '2024-04-01 00:00:00' AND '2024-04-30 23:59:59') LAST_YEAR_ENTRIES
    )