media: count_videos

Custom SQL query returning 1 row (hide)

SELECT count(*) AS total
FROM videos v
WHERE
  (
    :q = ''
    OR lower(v.code)    LIKE '%' || lower(:q) || '%'
    OR lower(v.titleEn) LIKE '%' || lower(:q) || '%'
    OR lower(v.titleJa) LIKE '%' || lower(:q) || '%'
  )
  AND (:series = '' OR v.s_uid = :series)
  AND (
    :has_stream = ''
    OR EXISTS (SELECT 1 FROM streams s WHERE s.v_uid = v.uid)
  )
  AND (
    :actress = ''
    OR EXISTS (
      SELECT 1 FROM video_star vs
      WHERE vs.v_uid = v.uid
        AND ',' || :actress || ',' LIKE '%,' || vs.a_uid || ',%'
    )
  )
  AND (
    :maker = ''
    OR EXISTS (
      SELECT 1 FROM video_maker vm
      WHERE vm.v_uid = v.uid
        AND ',' || :maker || ',' LIKE '%,' || vm.m_uid || ',%'
    )
  )
  AND (
    :label = ''
    OR EXISTS (
      SELECT 1 FROM video_label vl
      WHERE vl.v_uid = v.uid
        AND ',' || :label || ',' LIKE '%,' || vl.l_uid || ',%'
    )
  )
  AND (
    :director = ''
    OR EXISTS (
      SELECT 1 FROM video_director vd
      WHERE vd.v_uid = v.uid
        AND ',' || :director || ',' LIKE '%,' || vd.d_uid || ',%'
    )
  )
  AND (
    :category = ''
    OR EXISTS (
      SELECT 1 FROM video_category vc
      WHERE vc.v_uid = v.uid
        AND ',' || :category || ',' LIKE '%,' || vc.c_uid || ',%'
    )
  )

Query parameters

q

series

has_stream

actress

maker

label

director

category