getRecords fatal error:
Unknown column 'p.pdf' in 'order clause'
SELECT
gr.*
,i.Recom_Picture_file
,i.Recom_PDF
,i.Recom_PDF_Link
,i.Recom_ArtGrBezDatenblatt as ArtGrBez
,p.ProductFamily
,p.Power
,p.Power_UoM
,p.Isolation
FROM
(dbo_KHKArtikelgruppen as gr
, dbo_RECOM_Artikelgruppenzusatzinfos as i
,dbo_KHKArtikel as p
)
WHERE
1=1
AND
gr.Gruppenebene != '1'
AND
gr.Artikelgruppe IN ('RS3-S_D(Z)','REC3-SRW_DRW','REC3-SR_DR','REC3-SRWZ_DRWZ','REC5-SRWZ_DRWZ','REC5-SRW_DRW','REC7.5-S/DRW')
AND
gr.Artikelgruppe = i.Artikelgruppe
AND
gr.Artikelgruppe = p.Artikelgruppe
AND
gr.Gruppenebene != '1'
AND
WebStartDate <= CURDATE()
AND
WebEndDate > CURDATE()
#AND
# p.USER_CustomerDesign = 0
#AND (
# (p.USER_PortfolioAktuell = -1)
# OR
# (i.Recom_Website = -1)
# )
GROUP BY
gr.Artikelgruppe
ORDER BY
p.pdf
LIMIT
0, 20