Prima pagina   Contact   Inscriere   Login
Cautare  
SP: g4e_ClassifiedsA_act
Table 'rombiz.Classifieds' doesn't exist
SELECT c.*, s.fontColor, s.bgColor, s.borderColor, s.borderPx
FROM Classifieds c, ClassifiedStyle s
WHERE c.styleId = s.styleId
AND c.activeInd = 'Y'
AND c.classifiedTypeId = 1
AND c.effectiveFrom < NOW()
AND c.effectiveTo > NOW()
ORDER BY c.position DESC, c.effectiveFrom DESC