ps_DB Object
(
[row] => 0
[record] => Array
(
[0] => stdClass Object
(
[product_id] => 41096
[product_sales] => 4
[product_name] => KOI Yuzu Lemon Meringue 120МЛ 3МГ
[products_per_row] => 3
[category_browsepage] => managed
[category_flypage] => flypage.tpl
[category_id] => 1193
[product_full_image] => _________________5fea14d04691e.jpg
[product_thumb_image] => resized/_________________5fea14d031c91_350x350.jpg
[product_s_desc] =>
[product_parent_id] => 0
[product_publish] => Y
[product_in_stock] => 0
[product_sku] => KOI Yuzu Lemon Meringue
[product_url] =>
[product_weight] => 0.2000
[product_weight_uom] => кг.
[product_length] => 5.0000
[product_width] => 5.0000
[product_height] => 10.0000
[product_lwh_uom] => см.
[product_available_date] => 1608595200
[product_availability] =>
[mdate] => 1612370114
[cdate] => 1608659126
)
[1] => stdClass Object
(
[product_id] => 41095
[product_sales] => 0
[product_name] => KOI Yatsuhashi 120МЛ 3МГ
[products_per_row] => 3
[category_browsepage] => managed
[category_flypage] => flypage.tpl
[category_id] => 1193
[product_full_image] => _________________5fea15202f350.jpg
[product_thumb_image] => resized/_________________5fea1520179f4_350x350.jpg
[product_s_desc] =>
[product_parent_id] => 0
[product_publish] => Y
[product_in_stock] => 1
[product_sku] => KOI Yatsuhashi
[product_url] =>
[product_weight] => 0.2000
[product_weight_uom] => кг.
[product_length] => 5.0000
[product_width] => 5.0000
[product_height] => 10.0000
[product_lwh_uom] => см.
[product_available_date] => 1608595200
[product_availability] =>
[mdate] => 1609176352
[cdate] => 1608659099
)
[2] => stdClass Object
(
[product_id] => 41094
[product_sales] => 0
[product_name] => KOI Sakuramochi Ice Cream 120МЛ 3МГ
[products_per_row] => 3
[category_browsepage] => managed
[category_flypage] => flypage.tpl
[category_id] => 1193
[product_full_image] => _________________5fea14f7adf61.jpg
[product_thumb_image] => resized/_________________5fea14f79b5a9_350x350.jpg
[product_s_desc] =>
[product_parent_id] => 0
[product_publish] => Y
[product_in_stock] => 1
[product_sku] => KOI Sakuramochi Ice Cream
[product_url] =>
[product_weight] => 0.2000
[product_weight_uom] => кг.
[product_length] => 5.0000
[product_width] => 5.0000
[product_height] => 10.0000
[product_lwh_uom] => см.
[product_available_date] => 1608595200
[product_availability] =>
[mdate] => 1609176311
[cdate] => 1608659063
)
[3] => stdClass Object
(
[product_id] => 41093
[product_sales] => 2
[product_name] => KOI Castella 120МЛ 3МГ
[products_per_row] => 3
[category_browsepage] => managed
[category_flypage] => flypage.tpl
[category_id] => 1193
[product_full_image] => KOI_Castella_120_601d40b6967ac.jpg
[product_thumb_image] => resized/KOI_Castella_120_601d40b68be99_350x350.jpg
[product_s_desc] =>
[product_parent_id] => 0
[product_publish] => Y
[product_in_stock] => 0
[product_sku] => KOI Castella
[product_url] =>
[product_weight] => 0.2000
[product_weight_uom] => кг.
[product_length] => 5.0000
[product_width] => 5.0000
[product_height] => 10.0000
[product_lwh_uom] => см.
[product_available_date] => 1608595200
[product_availability] =>
[mdate] => 1612529846
[cdate] => 1608658963
)
)
[error] =>
[errno] =>
[_sql] => SELECT DISTINCT `#__vm_product`.`product_id`, `product_sales`, `product_name`, `products_per_row`, `category_browsepage`, `category_flypage`, `#__vm_category`.`category_id`, `product_full_image`, `product_thumb_image`, `product_s_desc`, `product_parent_id`, `product_publish`, `product_in_stock`, `product_sku`, `product_url`, `product_weight`, `product_weight_uom`, `product_length`, `product_width`, `product_height`, `product_lwh_uom`, `product_available_date`, `product_availability`, `#__vm_product`.`mdate`, `#__vm_product`.`cdate` FROM (`#__vm_product`, `#__vm_category`, `#__vm_product_category_xref`,`#__vm_shopper_group`) LEFT JOIN `#__vm_product_price` ON `#__vm_product`.`product_id` = `#__vm_product_price`.`product_id` WHERE `#__vm_product_category_xref`.`product_id`=`#__vm_product`.`product_id`
AND `#__vm_product_category_xref`.`category_id`=`#__vm_category`.`category_id`
AND `#__vm_product_category_xref`.`category_id`=1193
AND ((`#__vm_product`.`product_id`=`#__vm_product_price`.`product_id` AND `#__vm_shopper_group`.`shopper_group_id`=`#__vm_product_price`.`shopper_group_id`) OR `#__vm_product_price`.`product_id` IS NULL)
AND `#__vm_shopper_group`.`default` = 1
AND `product_parent_id`=0
AND `product_publish`='Y'
AND `category_publish`='Y'
GROUP BY `#__vm_product`.`product_sku`
ORDER BY `#__vm_product`.`cdate` DESC LIMIT 0, 5
[_query_set] =>
[called] => 1
[_database] => JDatabaseMySQL Object
(
[name] => mysql
[_nullDate] => 0000-00-00 00:00:00
[_nameQuote] => `
[_sql] => SELECT DISTINCT `jos_vm_product`.`product_id`, `product_sales`, `product_name`, `products_per_row`, `category_browsepage`, `category_flypage`, `jos_vm_category`.`category_id`, `product_full_image`, `product_thumb_image`, `product_s_desc`, `product_parent_id`, `product_publish`, `product_in_stock`, `product_sku`, `product_url`, `product_weight`, `product_weight_uom`, `product_length`, `product_width`, `product_height`, `product_lwh_uom`, `product_available_date`, `product_availability`, `jos_vm_product`.`mdate`, `jos_vm_product`.`cdate` FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`) LEFT JOIN `jos_vm_product_price` ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id` WHERE `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id`
AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id`
AND `jos_vm_product_category_xref`.`category_id`=1193
AND ((`jos_vm_product`.`product_id`=`jos_vm_product_price`.`product_id` AND `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id`) OR `jos_vm_product_price`.`product_id` IS NULL)
AND `jos_vm_shopper_group`.`default` = 1
AND `product_parent_id`=0
AND `product_publish`='Y'
AND `category_publish`='Y'
GROUP BY `jos_vm_product`.`product_sku`
ORDER BY `jos_vm_product`.`cdate` DESC LIMIT 0, 5
[_errorNum] => 0
[_errorMsg] =>
[_table_prefix] => jos_
[_resource] => Resource id #14
[_cursor] => Resource id #137
[_debug] => 0
[_limit] => 0
[_offset] => 0
[_ticker] => 0
[_log] => Array
(
)
[_utf] => 1
[_quoted] => Array
(
)
[_hasQuoted] =>
[_errors] => Array
(
)
[debug] => 0
)
)
KOI by Element