|
Login / Anmeldung |
|
|
|
|
Aktuelle Termine |
|
|
|
|
|
|
Rubriken |
|
|
Wählen Sie eine Rubrik, um kostenlos Kleinanzeigen aufgeben zu können.
|
|
|
Suchen |
|
|
| SELECT identry, advert_entry.idtree as idtree, iduser, title, body, priceeuro, pricestate, state, name, ort, plz,
advert_entry.count as count, path, created, valid, sponsorlevel, producer,
CHAR_LENGTH(advert_entry.image) as image, CHAR_LENGTH(advert_entry.image_small) as image_small
FROM advert_entry
left join orte on orte.idtownship=advert_entry.idort
left join advert_tree on advert_tree.idtree=advert_entry.idtree
WHERE (advert_entry.idtree='4' or advert_entry.subtree='4' or advert_entry.toptree='4') and valid >= now()
and created<>'0000-00-00 00:00:00'
order by created desc, title limit 5 | ANZEIGE |