|
 |
 |
 |
 |
 |
 |
 |
|
 |
 |
 |
|
|
|
from and size in query SELECT DAO.ID_DAO AS OID, NUM_DAO, NAME_DAO_LGG, DESC_DAO_LGG, MANUFAC1_PRO, MANUFAC2_PRO, IS_WSTREL_PRO,
PIC_DAO, PIC_B_DAO, PIC_S_DAO, PIC_MORE_DAO, PIC_MORE_B_DAO, IS_4DOWNLOAD_PRO, FILENAME_PRO,
RAWPRICE_PRO, RAWPRICEDATE_PRO, PRICE_PRI, OLDPRICE_PRI, OLDPRICE_PRI/PRICE_PRI AS SAVING, ITEM_TPT, VALUE_VAT,
VAR.ID_VAR, IS_VARIANT_PRO, NAME_VAR, NUM_VAR, PIC_VAR, DESC_VAR
FROM DAO_RLX, DAO_LGG, DAO, PRO, VAR, PRI, VAT, TPT
WHERE DAO_RLX.NUM_FROM_DAO = "RELIGIONEN_DER_MENSCHHEIT_1650" AND ASSOC_RLX = "P2G" AND DAO.ID_DAO = DAO_RLX.ID_TO_DAO AND IS_ACTIVE_DAO AND (PUB_FROM_DAO IS NULL OR PUB_FROM_DAO <= NOW()) AND (PUB_TO_DAO IS NULL OR PUB_TO_DAO >= NOW()) AND DAO_LGG.ID_DAO = DAO.ID_DAO AND DAO_LGG.ID_VAR = 0 AND DAO_LGG.LGGTYPE_LGG = "DE" AND
DAO.ID_DAO = PRO.ID_DAO AND VAR.ID_DAO = DAO.ID_DAO AND IS_DEFAULT_VAR AND PRI.ID_VAR = VAR.ID_VAR AND VON_PRI = 1 AND CURTYPE = "EUR" AND
PCATTYPE = "STANDARD" AND
VAT.VATTYPE = PRO.VATTYPE AND
TPT.ID_TPT = DAO.ID_TPT
ORDER BY ORDNUM_DAO_RLX, PIC_DAO DESC, NAME_DAO_LGG must be numeric, but are 0 and . Process aborted. | |