Array ( [0] => item [1] => solny-roztok-airbalance-regumed--set-12ks-p0104 ) select p.id, p.name,p.code,p.descr,price,price2,vat,level,l1price,l1price2,f.name as fname,f.type,discount from products p inner join files f on p.id= f.product_id where f.name='solny-roztok-airbalance-regumed--set-12ks-p0104' and category_id<>0 limit 1