Close

Search

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