<?php
$sql = 'SELECT
ff.id AS field_id,
c.id AS calculation_id,
c.answer AS calculation_answer,
c.operation AS calculation_operation,
c.value AS calculation_value,
c.variable AS calculation_variable
FROM calculations c
RIGHT JOIN form_field ff ON ff.id = c.field_id
INNER JOIN form f ON f.id = ff.form_id AND f.id = :form_id';
echo $sql;
SELECT
ff.id AS field_id,
c.id AS calculation_id,
c.answer AS calculation_answer,
c.operation AS calculation_operation,
c.value AS calculation_value,
c.variable AS calculation_variable
FROM calculations c
RIGHT JOIN form_field ff ON ff.id = c.field_id
INNER JOIN form f ON f.id = ff.form_id AND f.id = :form_id
Output for 8.3.5
Warning: PHP Startup: Unable to load dynamic library 'sodium.so' (tried: /usr/lib/php/8.3.5/modules/sodium.so (libsodium.so.23: cannot open shared object file: No such file or directory), /usr/lib/php/8.3.5/modules/sodium.so.so (/usr/lib/php/8.3.5/modules/sodium.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
SELECT
ff.id AS field_id,
c.id AS calculation_id,
c.answer AS calculation_answer,
c.operation AS calculation_operation,
c.value AS calculation_value,
c.variable AS calculation_variable
FROM calculations c
RIGHT JOIN form_field ff ON ff.id = c.field_id
INNER JOIN form f ON f.id = ff.form_id AND f.id = :form_id