Input Array does not match ?: SELECT COUNT(*) FROM (SELECT DISTINCT
ps.*,
s.*,
munis.*,
COALESCE(f.seq, 10000) AS order_by,
COALESCE(stl.setting_value, stpl.setting_value) AS series_title,
COALESCE(sal.setting_value, sapl.setting_value) AS series_abbrev
FROM published_submissions ps
JOIN submissions s ON ps.submission_id = s.submission_id
LEFT JOIN munipress_metadata munis ON (s.submission_id = munis.submission_id)
LEFT JOIN munipress_submission_languages msl ON (s.submission_id = msl.submission_id)
LEFT JOIN series se ON se.series_id = s.series_id
LEFT JOIN series_settings stpl ON (se.series_id = stpl.series_id AND stpl.setting_name = 'title' AND stpl.locale = 'cs_CZ')
LEFT JOIN series_settings stl ON (se.series_id = stl.series_id AND stl.setting_name = 'title' AND stl.locale = 'cs_CZ')
LEFT JOIN series_settings sapl ON (se.series_id = sapl.series_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'cs_CZ')
LEFT JOIN series_settings sal ON (se.series_id = sal.series_id AND sal.setting_name = 'abbrev' AND sal.locale = 'cs_CZ')
LEFT JOIN submission_settings st ON (st.submission_id = s.submission_id AND st.setting_name = 'title' AND st.locale = 'cs_CZ')
LEFT JOIN submission_settings st ON (st.submission_id = s.submission_id AND st.setting_name = 'title' AND st.locale = 525)
LEFT JOIN submission_categories sc ON (sc.submission_id = s.submission_id AND sc.category_id = 70)
LEFT JOIN series_categories sca ON (sca.series_id = se.series_id)
LEFT JOIN categories c ON (c.category_id = sca.category_id AND c.category_id = 70)
LEFT JOIN features f ON (f.submission_id = s.submission_id AND f.assoc_type = 70 AND f.assoc_id = 525)
LEFT JOIN new_releases nr ON (nr.submission_id = s.submission_id AND nr.assoc_type = 70 AND nr.assoc_id = 1)
WHERE ps.date_published IS NOT NULL AND s.context_id =
Input Array does not match ?: SELECT DISTINCT
ps.*,
s.*,
munis.*,
COALESCE(f.seq, 10000) AS order_by,
COALESCE(stl.setting_value, stpl.setting_value) AS series_title,
COALESCE(sal.setting_value, sapl.setting_value) AS series_abbrev
FROM published_submissions ps
JOIN submissions s ON ps.submission_id = s.submission_id
LEFT JOIN munipress_metadata munis ON (s.submission_id = munis.submission_id)
LEFT JOIN munipress_submission_languages msl ON (s.submission_id = msl.submission_id)
LEFT JOIN series se ON se.series_id = s.series_id
LEFT JOIN series_settings stpl ON (se.series_id = stpl.series_id AND stpl.setting_name = 'title' AND stpl.locale = 'cs_CZ')
LEFT JOIN series_settings stl ON (se.series_id = stl.series_id AND stl.setting_name = 'title' AND stl.locale = 'cs_CZ')
LEFT JOIN series_settings sapl ON (se.series_id = sapl.series_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'cs_CZ')
LEFT JOIN series_settings sal ON (se.series_id = sal.series_id AND sal.setting_name = 'abbrev' AND sal.locale = 'cs_CZ')
LEFT JOIN submission_settings st ON (st.submission_id = s.submission_id AND st.setting_name = 'title' AND st.locale = 'cs_CZ')
LEFT JOIN submission_settings st ON (st.submission_id = s.submission_id AND st.setting_name = 'title' AND st.locale = 525)
LEFT JOIN submission_categories sc ON (sc.submission_id = s.submission_id AND sc.category_id = 70)
LEFT JOIN series_categories sca ON (sca.series_id = se.series_id)
LEFT JOIN categories c ON (c.category_id = sca.category_id AND c.category_id = 70)
LEFT JOIN features f ON (f.submission_id = s.submission_id AND f.assoc_type = 70 AND f.assoc_id = 525)
LEFT JOIN new_releases nr ON (nr.submission_id = s.submission_id AND nr.assoc_type = 70 AND nr.assoc_id = 1)
WHERE ps.date_published IS NOT NULL AND s.context_id =
Input Array does not match ?: SELECT DISTINCT
ps.*,
s.*,
munis.*,
COALESCE(f.seq, 10000) AS order_by,
COALESCE(stl.setting_value, stpl.setting_value) AS series_title,
COALESCE(sal.setting_value, sapl.setting_value) AS series_abbrev
FROM published_submissions ps
JOIN submissions s ON ps.submission_id = s.submission_id
LEFT JOIN munipress_metadata munis ON (s.submission_id = munis.submission_id)
LEFT JOIN munipress_submission_languages msl ON (s.submission_id = msl.submission_id)
LEFT JOIN series se ON se.series_id = s.series_id
LEFT JOIN series_settings stpl ON (se.series_id = stpl.series_id AND stpl.setting_name = 'title' AND stpl.locale = 'cs_CZ')
LEFT JOIN series_settings stl ON (se.series_id = stl.series_id AND stl.setting_name = 'title' AND stl.locale = 'cs_CZ')
LEFT JOIN series_settings sapl ON (se.series_id = sapl.series_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'cs_CZ')
LEFT JOIN series_settings sal ON (se.series_id = sal.series_id AND sal.setting_name = 'abbrev' AND sal.locale = 'cs_CZ')
LEFT JOIN submission_settings st ON (st.submission_id = s.submission_id AND st.setting_name = 'title' AND st.locale = 'cs_CZ')
LEFT JOIN submission_settings st ON (st.submission_id = s.submission_id AND st.setting_name = 'title' AND st.locale = 525)
LEFT JOIN submission_categories sc ON (sc.submission_id = s.submission_id AND sc.category_id = 70)
LEFT JOIN series_categories sca ON (sca.series_id = se.series_id)
LEFT JOIN categories c ON (c.category_id = sca.category_id AND c.category_id = 70)
LEFT JOIN features f ON (f.submission_id = s.submission_id AND f.assoc_type = 70 AND f.assoc_id = 525)
LEFT JOIN new_releases nr ON (nr.submission_id = s.submission_id AND nr.assoc_type = 70 AND nr.assoc_id = 1)
WHERE ps.date_published IS NOT NULL AND s.context_id =
Input Array does not match ?: SELECT DISTINCT
ps.*,
s.*,
munis.*,
COALESCE(f.seq, 10000) AS order_by,
COALESCE(stl.setting_value, stpl.setting_value) AS series_title,
COALESCE(sal.setting_value, sapl.setting_value) AS series_abbrev
FROM published_submissions ps
JOIN submissions s ON ps.submission_id = s.submission_id
LEFT JOIN munipress_metadata munis ON (s.submission_id = munis.submission_id)
LEFT JOIN munipress_submission_languages msl ON (s.submission_id = msl.submission_id)
LEFT JOIN series se ON se.series_id = s.series_id
LEFT JOIN series_settings stpl ON (se.series_id = stpl.series_id AND stpl.setting_name = 'title' AND stpl.locale = 'cs_CZ')
LEFT JOIN series_settings stl ON (se.series_id = stl.series_id AND stl.setting_name = 'title' AND stl.locale = 'cs_CZ')
LEFT JOIN series_settings sapl ON (se.series_id = sapl.series_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'cs_CZ')
LEFT JOIN series_settings sal ON (se.series_id = sal.series_id AND sal.setting_name = 'abbrev' AND sal.locale = 'cs_CZ')
LEFT JOIN submission_settings st ON (st.submission_id = s.submission_id AND st.setting_name = 'title' AND st.locale = 'cs_CZ')
LEFT JOIN submission_settings st ON (st.submission_id = s.submission_id AND st.setting_name = 'title' AND st.locale = 525)
LEFT JOIN submission_categories sc ON (sc.submission_id = s.submission_id AND sc.category_id = 70)
LEFT JOIN series_categories sca ON (sca.series_id = se.series_id)
LEFT JOIN categories c ON (c.category_id = sca.category_id AND c.category_id = 70)
LEFT JOIN features f ON (f.submission_id = s.submission_id AND f.assoc_type = 70 AND f.assoc_id = 525)
LEFT JOIN new_releases nr ON (nr.submission_id = s.submission_id AND nr.assoc_type = 70 AND nr.assoc_id = 1)
WHERE ps.date_published IS NOT NULL AND s.context_id =
DB Error: Not unique table/alias: 'st'