 |
|
|
|
vidéos, cassettes, films
Nos tarifs
Eroare la listarea produselor
SELECT * from tbl_product AS pr
INNER JOIN tbl_support AS su
ON su.IdSupport = pr.IdSupport
INNER JOIN tbl_resolution AS re
ON re.IdResolution = pr.IdResolution
INNER JOIN tbl_fileformat AS ff
ON ff.IdFileFormat = pr.IdFileFormat
LEFT JOIN tbl_paperformat AS pa
ON pa.IdPaperFormat = pr.IdPaperFormat
WHERE ( (pr.IdSupport='10')) AND (pr.IdResolution = '1' AND (pr.IdPaperFormat = '0' OR pr.IdPaperFormat = '1')) ORDER BY su.PrintOrder, pa.PaperFormat, pr.QntMin, ff.FileFormat | | | | |
