lie/company_follows.sql

              SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
              -- not including breadcrumbs from sqlpage_aide_navigation
              -- not including page title from sqlpage_aide_navigation
              

              
 --- Display breadcrumb
  SELECT
     'breadcrumb' AS component;
   SELECT
     'Home' AS title,
     sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
   SELECT
     'Linkedin Explorer' AS title,
     sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/lie/index.sql' AS link;
   SELECT
     'Profile' AS title,
     sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/lie/profile.sql' AS link;
   SELECT
     'Company Follows' AS title,
     sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/lie/company_follows.sql' AS link;
   
 --- Dsply Page Title
   SELECT
       'title'   as component,
       'Company Follows'  as contents;

  -- sets up $limit, $offset, and other variables (use pagination.debugVars() to see values in web-ui)
     SET total_rows = (SELECT COUNT(*) FROM linkedin_company_follows );
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT
 'text' AS component,
 'This feature allows users to view a curated list of companies they follow on LinkedIn. 
 It provides insights into the user''s professional interests and industry preferences, 
 showcasing the organizations they engage with and stay updated on. 
 With a clear and interactive interface, this feature enhances the user''s profile by 
 highlighting their network and areas of interest.' AS contents;


  -- Display uniform_resource table with pagination
     SELECT 'table' AS component,
           'subject' AS markdown,
           'Column Count' as align_right,
           TRUE as sort,
           TRUE as search,
           'from' AS markdown;

      SELECT
         * 
         FROM linkedin_company_follows
         LIMIT $limit
       OFFSET $offset;
       SELECT 'text' AS component,
    (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) ||     ')' ELSE '' END) || ' ' ||
    '(Page ' || $current_page || ' of ' || $total_pages || ") " ||
    (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) ||     ')' ELSE '' END)
    AS contents_md 
;