select text_marquee from texte_marquee
where text_marquee_id = (select text_marquee_id from texte_marquee_relatii
where section_id=1 and city_id= order by text_marquee_id desc limit 1)
select text_marquee from texte_marquee
where text_marquee_id = (select text_marquee_id from texte_marquee_relatii
where section_id=2 and city_id= order by text_marquee_id desc limit 1)
select count(a.article_id)
from articles a, sections b, articles_cities c
where a.section_id='40'
and year(a.article_date) = year(now()) and month(a.article_date) = month(now())
and b.section_id = a.section_id
and a.article_id=c.article_id
and c.city_id=
select a.*,
(select image_url from articles_images
where article_id=a.article_id order by image_type limit 1) as image_url
from articles a, sections b, articles_cities c
where a.section_id='40'
and year(a.article_date) = year(now()) and month(a.article_date) = month(now()) and b.section_id = a.section_id
and a.article_id=c.article_id
and c.city_id= order by a.article_id desc
limit 0 , 10
select a.*,
(select image_url from articles_images
where article_id=a.article_id order by image_type limit 1) as image_url
from articles a, sections b, articles_cities c
where a.section_id=40 and b.section_id = a.section_id
and a.article_id=c.article_id
and c.city_id= order by a.article_id desc
limit 10
Warning: Invalid argument supplied for foreach() in /var/www/localhost/htdocs/patru.dwd.ro/new_/1001romania/sections/arata_detalii_categorie.php on line 95
select a.*,
(select image_url from articles_images where article_id=a.article_id limit 1) as image_url,
b.section_colour, c.city_id
from articles a, sections b, articles_cities c
where a.section_id=40 and b.section_id = a.section_id
and a.article_id=c.article_id and c.city_id= and a.article_show_on_index='1'
order by a.article_id desc
limit 4
Warning: Invalid argument supplied for foreach() in /var/www/localhost/htdocs/patru.dwd.ro/new_/1001romania/sections/arata_detalii_categorie.php on line 116
select year(a.article_date) as article_year, month(a.article_date) as article_month
from articles a, articles_cities c
where a.section_id=40 and PERIOD_DIFF(DATE_FORMAT(now(), '%Y%m') , DATE_FORMAT(a.article_date, '%Y%m')) > 0 and c.city_id =
and a.article_id=c.article_id
order by article_year desc, article_month
select a.* from banere a where a.baner_type=1 and a.baner_status='1'
and a.baner_id =(select baner_id from banere_orase where city_id= limit 1) limit 1
select a.* from banere a where a.baner_type=2 and a.baner_status='1'
and a.baner_id in (select baner_id from banere_orase where city_id=)
select a.* from banere a where a.baner_type=3 and a.baner_status='1'
and a.baner_id in (select baner_id from banere_orase where city_id=)
select a.* from banere a where a.baner_type=4 and a.baner_status='1'
and a.baner_id in (select baner_id from banere_orase where city_id=)
limit 1
select a.* from banere a where a.baner_type=5 and a.baner_status='1'
and a.baner_id in (select baner_id from banere_orase where city_id=)
limit 1
select a.* from banere a where a.baner_type=6 and a.baner_status='1'
and a.baner_id in (select baner_id from banere_orase where city_id=)
limit 1
select a.* from banere a where a.baner_type=7 and a.baner_status='1'
and a.baner_id in (select baner_id from banere_orase where city_id=)
limit 1
SELECT UNIX_TIMESTAMP(b.article_date_go) AS date
FROM events_cities a, events b
WHERE a.city_id =
and a.active='1'
and b.article_id = a.article_id
and year(b.article_date_go) = 2010
and month(b.article_date_go) = 3
and day(b.article_date_go) >= day(now())
Warning: Invalid argument supplied for foreach() in /var/www/localhost/htdocs/patru.dwd.ro/new_/1001romania/calendar/calendar.php on line 57
select a.*, c.city_id
from events a, sections_events b, events_cities c
where TO_DAYS(a.article_date_go) - TO_DAYS(now()) >=0
and a.article_show_on_index='1'
and b.section_id = a.section_id
and a.article_id=c.article_id and c.city_id= and c.active='1'
order by a.article_date_go limit 3
Warning: Invalid argument supplied for foreach() in /var/www/localhost/htdocs/patru.dwd.ro/new_/1001romania/root/setari_diverse.php on line 25
select max_deg, now_deg from weather_new where city_id= order by day
