|
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,
RAWPRICE_PRO, RAWPRICEDATE_PRO, PRICE_PRI, OLDPRICE_PRI, ITEM_TPT, VALUE_VAT,
VAR.ID_VAR, IS_VARIANT_PRO, NAME_VAR, NUM_VAR, PIC_VAR, DESC_VAR
FROM EPCC, DAO_LGG, DAO, PRO, VAR, PRI, VAT, TPT
WHERE ID_EPCP = 10 AND DAO.NUM_DAO = EPCC.NUM_TO_EPCC 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_EPCC must be numeric, but are 0 and . Process aborted.
|
