<br />
<b>Fatal error</b>:  Uncaught exception 'RuntimeException' with message 'ERROR:  invalid input syntax for integer: &quot;item.type.code&quot;
select
	count(*)
from
	product_tbl
	left join category_tbl product_tbl_category_tbl on product_tbl_category_tbl.code = product_tbl.category_code
	left join brand_tbl product_tbl_brand_tbl on product_tbl_brand_tbl.code = product_tbl.brand_code
	left join type_tbl product_tbl_type_tbl on product_tbl_type_tbl.code = product_tbl.type_code
	left join product_inventory_tbl product_tbl_product_inventory_tbl on product_tbl_product_inventory_tbl.code = product_tbl.code
	left join (
	select
		sum(a.amount) as amount,
		a.product_code as code
	from
		order_item_tbl a
		left outer join order_tbl b
			on b.order_number = a.order_number
	where
		COALESCE(b.status, 0) = 0
	group by
		code
) product_tbl_product_reserve on product_tbl_product_reserve.code = product_tbl.code
where
	product_tbl.category_code = $1
	and product_tbl.type_code = $2
' in /virtual/kyotoya78/private_data/class/common/DBItem.php:121
Stack trac in <b>/virtual/kyotoya78/private_data/class/common/DBItem.php</b> on line <b>121</b><br />