lifeguard
select a.id,a.title,a.lead,a.pic_s,video_storyid,s.dir||d.fullpath,a.publishdate,a.pic_alt,d.id, a.linked from articles a, articles_categories b, directories d, structure s where a.id=b.articleid and d.id=a.categoryid AND d.structureid=s.id AND s.id=1041 AND b.categoryid=1042 and a.status=1 and (a.publishdate

Glābēji

Vēlies strādāt Līvu Akvaparkā??? Aizpildi pieteikuma anketu on-line.

Personāls

Gribi zināt pirmais?

select a.id, a.title, a.lead, d.fullpath, s.dir from articles a, directories d, structure s where a.status=1 and d.id=a.categoryid and s.id=d.structureid and d.structureid=1041 order by a.publishdate desc, a.publishtime desc limit 2 offset 0


SELECT s.image, s.url, s.caption FROM self_ads s, directories d WHERE d.structureid=1041 AND parentid=0 AND s.directoryid=d.id ORDER BY order_


Pirmdienās un otrdienās Līvu Akvaparks ir slēgts!