ps_DB Object
(
[row] => 0
[record] => Array
(
[0] => stdClass Object
(
[product_id] => 39627
[product_sales] => 1
[product_name] => Nasty Berry STAR GAZING 60мл 3мг
[products_per_row] => 3
[category_browsepage] => managed
[category_flypage] => flypage.tpl
[category_id] => 995
[product_full_image] => _________________5c5064f86c82d.jpg
[product_thumb_image] => resized/_________________5c5064f8627b7_350x350.jpg
[product_s_desc] =>
[product_parent_id] => 0
[product_publish] => Y
[product_in_stock] => 2
[product_sku] => 365
[product_url] =>
[product_weight] => 0.1100
[product_weight_uom] => кг.
[product_length] => 5.0000
[product_width] => 5.0000
[product_height] => 10.0000
[product_lwh_uom] => см.
[product_available_date] => 0
[product_availability] =>
[mdate] => 1593188482
[cdate] => 1548092517
)
)
[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`=995
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`=995
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 #129
[_debug] => 0
[_limit] => 0
[_offset] => 0
[_ticker] => 0
[_log] => Array
(
)
[_utf] => 1
[_quoted] => Array
(
)
[_hasQuoted] =>
[_errors] => Array
(
)
[debug] => 0
)
)
Nasty Juice
