ps_DB Object ( [row] => -1 [record] => Array ( ) [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`=952 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, 36 [_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`=952 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, 36 [_errorNum] => 0 [_errorMsg] => [_table_prefix] => jos_ [_resource] => Resource id #24 [_cursor] => Resource id #239 [_debug] => 0 [_limit] => 0 [_offset] => 0 [_ticker] => 0 [_log] => Array ( ) [_utf] => 1 [_quoted] => Array ( ) [_hasQuoted] => [_errors] => Array ( ) [debug] => 0 ) )