RAND State Statistics uses cookies only to authenticate users, to prevent unauthorized access, to improve the site, and to enhance the user experience.
We do not collect nor do we share any personally identifiable information. For additional information, see our Privacy Policy.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') and is_active = '1' UNION ALL select distinct sf.id, sft.time_format, sft.`co' at line 1: Select * from ( select distinct sf.id, sft.time_format, sft.`columns`, sf.db_name,sf.db_geo_us,sf.db_geo_state,sf.db_geo_metro,sf.db_geo_county,sf.db_geo_city,sf.db_geo_zip,sf.db_periodicity,sf.db_dataseries,sf.date_added,sf.db_nextupdate,sf.db_source,sf.map_active,sf.is_static_form,'rand_usa' as db_select, '' as share,sf.url,sf.is_active, MATCH (sf.db_name,sf.db_title,sf.db_description,sf.db_datasource) AGAINST ('' IN BOOLEAN MODE) a, MATCH (st.tags) AGAINST ('' IN BOOLEAN MODE) b, MATCH (scf.tags) AGAINST ('' IN BOOLEAN MODE) c from rand_usa.`searchforms` sf left join rand_usa.`searchform_tags` st on sf.id = st.database_id left join rand_usa.`searchforms_criteria_tags` scf ON sf.id = scf.db_id Left JOIN rand_usa.time_interval_settings sft ON sf.id = sft.database_id where (MATCH (sf.db_name,sf.db_title,sf.db_description,sf.db_datasource) AGAINST ('' IN BOOLEAN MODE) OR MATCH (st.tags) AGAINST ('' IN BOOLEAN MODE) OR MATCH (scf.tags) AGAINST ('' IN BOOLEAN MODE) OR ) and is_active = '1' UNION ALL select distinct sf.id, sft.time_format, sft.`columns`, sf.db_name,sf.db_geo_us,sf.db_geo_state,sf.db_geo_metro,sf.db_geo_county,sf.db_geo_city,sf.db_geo_zip,sf.db_periodicity,sf.db_dataseries,sf.date_added,sf.db_nextupdate,sf.db_source,sf.map_active,sf.is_static_form,'rand_california' as db_select, '' as share,sf.url,sf.is_active, MATCH (sf.db_name,sf.db_title,sf.db_description,sf.db_datasource) AGAINST ('' IN BOOLEAN MODE) a, MATCH (st.tags) AGAINST ('' IN BOOLEAN MODE) b, MATCH (scf.tags) AGAINST ('' IN BOOLEAN MODE) c from rand_california.`searchforms` sf left join rand_california.`searchform_tags` st on sf.id = st.database_id left join rand_california.`searchforms_criteria_tags` scf ON sf.id = scf.db_id Left JOIN rand_california.time_interval_settings sft ON sf.id = sft.database_id where (MATCH (sf.db_name,sf.db_title,sf.db_description,sf.db_datasource) AGAINST ('' IN BOOLEAN MODE) OR MATCH (st.tags) AGAINST ('' IN BOOLEAN MODE) OR MATCH (scf.tags) AGAINST ('' IN BOOLEAN MODE) OR ) and is_active = '1' UNION ALL select distinct sf.id, sft.time_format, sft.`columns`, sf.db_name,sf.db_geo_us,sf.db_geo_state,sf.db_geo_metro,sf.db_geo_county,sf.db_geo_city,sf.db_geo_zip,sf.db_periodicity,sf.db_dataseries,sf.date_added,sf.db_nextupdate,sf.db_source,sf.map_active,sf.is_static_form,'rand_texas' as db_select, '' as share,sf.url,sf.is_active, MATCH (sf.db_name,sf.db_title,sf.db_description,sf.db_datasource) AGAINST ('' IN BOOLEAN MODE) a, MATCH (st.tags) AGAINST ('' IN BOOLEAN MODE) b, MATCH (scf.tags) AGAINST ('' IN BOOLEAN MODE) c from rand_texas.`searchforms` sf left join rand_texas.`searchform_tags` st on sf.id = st.database_id left join rand_texas.`searchforms_criteria_tags` scf ON sf.id = scf.db_id Left JOIN rand_texas.time_interval_settings sft ON sf.id = sft.database_id where (MATCH (sf.db_name,sf.db_title,sf.db_description,sf.db_datasource) AGAINST ('' IN BOOLEAN MODE) OR MATCH (st.tags) AGAINST ('' IN BOOLEAN MODE) OR MATCH (scf.tags) AGAINST ('' IN BOOLEAN MODE) OR ) and is_active = '1' UNION ALL select distinct sf.id, sft.time_format, sft.`columns`, sf.db_name,sf.db_geo_us,sf.db_geo_state,sf.db_geo_metro,sf.db_geo_county,sf.db_geo_city,sf.db_geo_zip,sf.db_periodicity,sf.db_dataseries,sf.date_added,sf.db_nextupdate,sf.db_source,sf.map_active,sf.is_static_form,'rand_newyork' as db_select, '' as share,sf.url,sf.is_active, MATCH (sf.db_name,sf.db_title,sf.db_description,sf.db_datasource) AGAINST ('' IN BOOLEAN MODE) a, MATCH (st.tags) AGAINST ('' IN BOOLEAN MODE) b, MATCH (scf.tags) AGAINST ('' IN BOOLEAN MODE) c from rand_newyork.`searchforms` sf left join rand_newyork.`searchform_tags` st on sf.id = st.database_id left join rand_newyork.`searchforms_criteria_tags` scf ON sf.id = scf.db_id Left JOIN rand_newyork.time_interval_settings sft ON sf.id = sft.database_id where (MATCH (sf.db_name,sf.db_title,sf.db_description,sf.db_datasource) AGAINST ('' IN BOOLEAN MODE) OR MATCH (st.tags) AGAINST ('' IN BOOLEAN MODE) OR MATCH (scf.tags) AGAINST ('' IN BOOLEAN MODE) OR ) and is_active = '1' ) as tbl order by b desc, a desc, c desc