SELECT COUNT(web_termek_torzs.TermekKod) AS num FROM web_termek_torzs, web_termek_szovegek, web_listaar, web_termek_kepek, web_keszlet
WHERE
web_termek_szovegek.CegKod='NYESTER'
AND
web_termek_szovegek.Nyelv='HUN'
AND
web_termek_torzs.CegKod='NYESTER'
AND
web_listaar.CegKod='NYESTER'
AND
web_termek_kepek.CegKod='NYESTER'
AND
web_keszlet.CegKod='NYESTER'
AND
web_keszlet.TermekKod=web_termek_torzs.TermekKod
AND
web_keszlet.Raktar = '0'
AND
web_keszlet.Mennyiseg >= '10'
AND
web_keszlet.Mennyiseg >= RendelesiEgyseg
AND
web_termek_torzs.TermekKod=web_termek_kepek.TermekKod
AND
web_termek_kepek.Filenev_norm<>''
AND
web_listaar.AlapAr > '0'
AND
web_termek_torzs.TermekKod=web_termek_szovegek.TermekKod
AND
web_listaar.TermekKod=web_termek_torzs.TermekKod
AND
(
web_termek_torzs.seria_value=''
OR
(
web_termek_torzs.seria_value<>'' AND
(
web_termek_torzs.seria_list_show='1' OR
web_termek_torzs.seria_list_show='2' OR
web_termek_torzs.seria_list_show='3' OR
web_termek_torzs.seria_list_show='4' OR
web_termek_torzs.seria_list_show='5' OR
web_termek_torzs.seria_list_show='6' OR
web_termek_torzs.seria_list_show='7' OR
web_termek_torzs.seria_list_show='8' OR
web_termek_torzs.seria_list_show='9'
)
)
)
AND web_termek_torzs.Statusza IN ('V', 'S') AND (web_termek_torzs.TermekTipus LIKE 'V%' OR web_termek_torzs.TermekTipus2 like 'V%') GROUP by ArlistaNev
