select kod_firma_menu, kod_vu, blok, text_menu, nam_menu, tit_menu, h1_menu, dis_menu, keyw_menu, vis_menu, aktiv, tip_vert, zakaz, tip_vert, kod_vid_pub, vis_kontakt, fon1, karusel, tip_vidtov, tip_vidpub, kol_tov, kol_pub, papka, kol_tov as kol_tov_str, kol_pub as kol_pub_str, tit_menu_gorod, dis_menu_gorod, text_menu_gorod, goroda, UNIX_TIMESTAMP(lastmod) as lastmodifiedpage from firma_menu where kod_firm=2 and kod_firma_menu=8820 LIMIT 1
select kod_firm, google, yandex, yandex_verification, counter,
vkontakte, facebook, twitter, odnoklassniki, google_plus, kod_ag, kod_am
from firma
where kod_firm = 2 LIMIT 1
select fmi.kod_fmi, s.nam_vidinfo, s.kod_vidinfo, fmi.sort, fmi.tit_vidinfo, fmi.dis_vidinfo, fmi.vkl_vidinfo
from spr_vidinfo s, firma_menu_info fmi
where s.kod_admin = 0
and s.kod_vidinfo = fmi.kod_vidinfo
and fmi.kod_firm = 2
and fmi.kod_firma_menu = 8820
and fmi.kod_tov = 0
and fmi.kod_pub = 0
order by fmi.sort
select k.kod_kurs, k.kurs, k.kod_val, k.kod_kontr
from firma_kurs k, firma f
where k.kod_ag = f.kod_ag
and f.kod_firm = 2
and k.kod_kontr > 0
select k.kod_val, k.kurs
from firma_kurs k
where k.kod_firm = 2
and k.kod_firma_menu = 8820
select kod_firma_menu, kod_vu, tit_menu, opis_menu, nam_menu, nam_menu1, aktiv, papka, blok, class_menu, pic_menu, vertikal, goroda, 0 as kod_firma_menu_x
from firma_menu
where kod_firm=2
order by sort
select p.kod_mp, p.kod_firma_menu, p.kod_pr, p.kod_priznak, p.goroda, m.papka as papka_menu, m.nam_menu
from firma_menu_proizvoditel p, firma_menu m
where p.kod_firm=2
and m.kod_firm=2
and p.kod_firma_menu=m.kod_firma_menu
and m.blok != 1
select m.kod_firma_menu, m.kod_vu, m.tit_menu, m.nam_menu, m.nam_menu1, m.aktiv, m.papka, m.blok, m.class_menu, m.pic_menu, m.vertikal, m.goroda, x.kod_firma_menu as kod_firma_menu_x
from firma_menu m, firma_menu_menu x
where m.kod_firm=2
and x.kod_firm=2
and x.kod_firma_menu_x = m.kod_firma_menu
order by m.sort
select v.kod_priznakvid, v.nam_priznakvid, m.kod_firma_menu, v.tip_priznakvid
from firma_menu_priznak_vid m, firma_priznak_vid v
where m.kod_firm = 2
and v.kod_firm = 2
and m.kod_firma_menu = 8820
and m.kod_priznakvid = v.kod_priznakvid
and ((v.tip_priznakvid = 0)or(v.tip_priznakvid = 5))
order by m.sort
select m.kod_mp, m.kod_firma_menu, m.kod_pr, m.kod_priznak, p.kod_priznakvid, p.nam_priznak, p.papka_priznak, p.sin_1priznak, p.sin_4priznak, p.sin_5priznak, p.pic_pri
from firma_menu_proizvoditel m, firma_priznak p
where m.kod_firm = 2
and p.kod_firm = 2
and m.kod_firma_menu = 8820
and m.kod_priznak > 0
and m.kod_priznak = p.kod_priznak
order by p.sort
select m.kod_mp, m.kod_firma_menu, m.kod_pr, m.kod_priznak, p.nam_pr, p.papka_pr
from firma_menu_proizvoditel m, firma_proizvoditel p
where m.kod_firm = 2
and p.kod_firm = 2
and m.kod_pr > 0
and m.kod_pr = p.kod_pr
order by p.sort
