Untitled

mail@pastecode.io avatar
unknown
plain_text
a year ago
1.2 kB
1
Indexable
Never
{table-transformer}
{html}<table>
  <tr>
    <th>Friday</th>
  </tr>
  <tr>
    <td>{sql-query:SELECT DATE_ADD(DATE_SUB(CURRENT_DATE(), INTERVAL (DAYOFWEEK(CURRENT_DATE())+1) % 7 DAY), INTERVAL (IF(DAYOFWEEK(CURRENT_DATE()) >= 6, 1, 0)) WEEK) AS friday_1}</td>
  </tr>
  <tr>
    <td>{sql-query:SELECT DATE_ADD(DATE_ADD(DATE_SUB(CURRENT_DATE(), INTERVAL (DAYOFWEEK(CURRENT_DATE())+1) % 7 DAY), INTERVAL (IF(DAYOFWEEK(CURRENT_DATE()) >= 6, 1, 0)) WEEK), INTERVAL 7 DAY) AS friday_2}</td>
  </tr>
  <tr>
    <td>{sql-query:SELECT DATE_ADD(DATE_ADD(DATE_SUB(CURRENT_DATE(), INTERVAL (DAYOFWEEK(CURRENT_DATE())+1) % 7 DAY), INTERVAL (IF(DAYOFWEEK(CURRENT_DATE()) >= 6, 1, 0)) WEEK), INTERVAL 14 DAY) AS friday_3}</td>
  </tr>
  <tr>
    <td>{sql-query:SELECT DATE_ADD(DATE_ADD(DATE_SUB(CURRENT_DATE(), INTERVAL (DAYOFWEEK(CURRENT_DATE())+1) % 7 DAY), INTERVAL (IF(DAYOFWEEK(CURRENT_DATE()) >= 6, 1, 0)) WEEK), INTERVAL 21 DAY) AS friday_4}</td>
  </tr>
  <tr>
    <td>{sql-query:SELECT DATE_ADD(DATE_ADD(DATE_SUB(CURRENT_DATE(), INTERVAL (DAYOFWEEK(CURRENT_DATE())+1) % 7 DAY), INTERVAL (IF(DAYOFWEEK(CURRENT_DATE()) >= 6, 1, 0)) WEEK), INTERVAL 28 DAY) AS friday_5}</td>
  </tr>
</table>{html}
{table-transformer}