|
|
|
|
REKLAMA  |
|
|
|
|
REKLAMA  |
|
REKLAMA  |
|
Out of resources when opening file '/var/tmp/#sql_27ad_4.MAI' (Errcode: 24)
SELECT b.id_user_advertisement, b.title, b.text, b.email, b.telephone_1, b.telephone_2, b.www
, b.id_user_advertisement_type, b.address, b.city, b.id_wojewodztwo, b.is_visible, v.wojewodztwo
, b.is_new, b.sort_order, b.id_user, b.IP, b.id_departament, b.created_on_readonly
, at.advertisement_type, b.company, b.picture_1, b.picture_2,b.picture_3
FROM zzz_user_advertisement b
LEFT JOIN zzz_wojewodztwo v using (id_wojewodztwo)
LEFT JOIN zzz_user_advertisement_type at using (id_user_advertisement_type)
WHERE 1=1 and b.is_visible=1 and Now() <= adddate(b.created_on_readonly, interval 1 month) and b.id_user_advertisement_type in (3) ORDER BY RAND() limit 1
Out of resources when opening file '/var/tmp/#sql_27ad_4.MAD' (Errcode: 24)
SELECT
id_youtube,
title,
'youtube' as `page`,
small_html, description
FROM zzz_youtube b WHERE is_visible=1 union all SELECT
id_video,
title,
'video' as `page`,
small_html, description
FROM zzz_video b WHERE is_visible=1 order by RAND()
| |
DODATKI
