|
|
| Current Articles |
| Displaying 41 to 50 (of 179 articles) |
Result Pages: 5 |
|
 |
1 - Can't create/write to file '/tmp/#sql_1de6_1.MYI' (Errcode: 28)
select a.articles_id, a.articles_date_added, ad.articles_name, ad.articles_head_desc_tag, au.authors_id, au.authors_name, td.topics_id, td.topics_name
from articles a,
authors au,
articles_description ad,
articles_to_topics a2t,
topics_description td
where a.articles_status = '1'
and (a.articles_date_available is null or to_days(a.articles_date_available) <= to_days(now()))
and a.authors_id = au.authors_id
and a.articles_id = a2t.articles_id
and a.articles_id = ad.articles_id
and a2t.topics_id = td.topics_id
and ad.language_id = '1'
and td.language_id = '1'
order by a.articles_date_added desc, ad.articles_name limit 40, 10
[TEP STOP]
| | | | | |
