SELECT store_id,
item_id,
itemname,
unit_name,
COALESCE(SUM(quantity), 0) AS qty
FROM fx_store_stock_view
WHERE store_id = 11
AND firm_id = 1
AND itemdisabled <> 1
AND item_id = 107
GROUP BY store_id, item_id
HAVING qty > 0;$folder = addslashes("\\assets\\img\\product\\");$stmt = $mysql->prepare("INSERT INTO `catalog`(`Name_Product`, `Operator`, `Internet`, `Minuts`, `Sms`, `Price_tarif`, `Price_sim`, `image`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)");
$stmt->bind_param("ssssssss", $Name_Product, $Operator, $Internet, $Minuts, $Sms, $Price_tarif, $Price_sim, $photoname);
$stmt->execute();Но уверен есть решение элегантнее и разумнее)
Или это ок?