line 16:sql: select P.idnProPhoto,P.idnCustomer, P.idnStatus, P.folder,C.registrationID, C.name, C.BackDrop, S.Status
from SelfiesSantaProPhoto as P inner join SelfiesSantaCustomer as C on P.idnCustomer = C.idnCustomer inner join SelfiesSantaStatus as S on S.idnStatus = P.idnStatus
where ((P.idnStatus = 15) or (P.idnStatus = 14)) order by C.registrationID limit 5;
regID | Name | Backdrop | Status | Staged |
---|---|---|---|---|
2 | gabriela perez | fireplace | CHECKED IN | |
3 | marco subuyu | fireplace | CHECKED IN | |
4 | katy varlean | CHECKED IN | ||
5 | gloria Marquez | fireplace | CHECKED IN | |
6 | Yesenia Esqueda | Corner | CHECKED IN |