 |
getRecords error: Unknown column 'get_pdf' in 'order clause'
SELECT
t.*
,(SELECT btt2.text
FROM merkblaetter as t2,bausteintitel as bt2, bausteintexte as btt2, mb_bt_btt AS mn2
WHERE t.id = mn2.merkblatt_id AND
mn2.bausteintitel_id = bt2.id AND
bt2.name = 'Entsprechende Rahmenrezeptur (CPNP)' AND
mn2.bausteintext_id = btt2.id
GROUP BY mn2.merkblatt_id) as btt_text
FROM
merkblaetter_gruppen AS mb_gp,
merkblaetter as t
WHERE
t.id = mb_gp.merkblatt_id
AND
mb_gp.gruppe_id = 5
AND
t.visibility = 'show'
ORDER BY
get_pdf
LIMIT
0, 20
|