Array ( [0] => item [1] => regumed-protector-5g-gst82 ) 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='regumed-protector-5g-gst82' and category_id<>0 limit 1