2Base base
0

Sögur

SELECT txt_lang.directory,txt_lang.title,txt_lang.teaser,txt_lang.txt_id,txt_lang.direct_link,txt.page_id,txt.creationdate,txt_lang.author,txt.video_url,images.entity_id,images.entity_type,images.mime_type,image_translations.seo_filename FROM txt,txt_lang,images,image_translations WHERE txt.txt_id=txt_lang.txt_id AND images.image_number=1 AND images.entity_id=txt.txt_id AND images.entity_type='txt' AND image_translations.image_id=images.image_id AND txt.active='1' AND txt_lang.title!='' AND image_translations.lang_code=txt_lang.lang_id AND txt.type_id=? AND txt_lang.lang_id=? ORDER BY RAND() LIMIT ? OFFSET ?
Top