Studio98 Framework database error: [Unknown column 'a.product_id' in 'on clause']
SELECT DISTINCT p.`product_id` FROM `products` AS p LEFT JOIN `website_products` AS wp ON ( wp.`product_id` = p.`product_id` ) LEFT JOIN `product_images` AS pi ON ( pi.`product_id` = p.`product_id` ) LEFT JOIN `attribute_item_relations` AS air ON ( a.`product_id` = air.`product_id` ) WHERE p.`publish_visibility` = 'public' AND pi.`sequence` = 0 AND wp.`website_id` = 293 AND wp.`blocked` = 0 AND wp.`active` = 1 AND p.`category_id` IN(698,699,700,273,701) AND air.`attribute_item_id` IN(838,935) GROUP BY air.`product_id` HAVING COUNT(air.`product_id`) = 2

::DEBUG:: An error has occurred:

Failed to fetch product count including sub_categories.

array (
  'website_id' => 293,
  'message' => 'Failed to fetch product count including sub_categories.',
  'sql' => 'SELECT DISTINCT p.`product_id` FROM `products` AS p LEFT JOIN `website_products` AS wp ON ( wp.`product_id` = p.`product_id` ) LEFT JOIN `product_images` AS pi ON ( pi.`product_id` = p.`product_id` )  LEFT JOIN `attribute_item_relations` AS air ON ( a.`product_id` = air.`product_id` ) WHERE p.`publish_visibility` = \'public\' AND pi.`sequence` = 0 AND wp.`website_id` = 293 AND wp.`blocked` = 0 AND wp.`active` = 1 AND p.`category_id` IN(698,699,700,273,701) AND air.`attribute_item_id` IN(838,935) GROUP BY air.`product_id` HAVING COUNT(air.`product_id`) = 2',
  'sql_error' => 'Unknown column \'a.product_id\' in \'on clause\'',
  'page' => 'http://www.pricebustersmd.com/kids-furniture/beds/?a_150=838&a_171=935??a_150=838&a_171=935',
  'referer' => NULL,
  'line' => 599,
  'file' => '/gsr/platform/core/classes/products.php',
  'dir' => '/gsr/platform/core/classes',
  'function' => '',
  'class' => 'Products',
  'method' => 'Products::product_count',
  'browser_name' => 'unrecognized',
  'browser_version' => 'unknown',
  'browser_platform' => 'unrecognized',
  'browser_user_agent' => 'ccbot/2.0',
  'date_created' => '2013-05-18 16:36:46',
)

To disable these messages, edit s98_fw/config.php file.

Studio98 Framework database error: [Unknown column 'a.product_id' in 'on clause']
SELECT DISTINCT p.`product_id` FROM `products` AS p LEFT JOIN `website_products` AS wp ON ( wp.`product_id` = p.`product_id`) LEFT JOIN `product_images` AS pi ON ( pi.`product_id` = p.`product_id` ) LEFT JOIN `attribute_item_relations` AS air ON ( a.`product_id` = air.`product_id` ) WHERE p.`publish_visibility` = 'public' AND pi.`sequence` = 0 AND wp.`website_id` = 293 AND wp.`blocked` = 0 AND wp.`active` = 1 AND p.`category_id` = 701 AND air.`attribute_item_id` IN(838,935) GROUP BY air.`product_id` HAVING COUNT(air.`product_id`) = 2

::DEBUG:: An error has occurred:

Failed to fetch product count NOT including sub_categories.

array (
  'website_id' => 293,
  'message' => 'Failed to fetch product count NOT including sub_categories.',
  'sql' => 'SELECT DISTINCT p.`product_id` FROM `products` AS p LEFT JOIN `website_products` AS wp ON ( wp.`product_id` = p.`product_id`) LEFT JOIN `product_images` AS pi ON ( pi.`product_id` = p.`product_id` )  LEFT JOIN `attribute_item_relations` AS air ON ( a.`product_id` = air.`product_id` ) WHERE p.`publish_visibility` = \'public\' AND pi.`sequence` = 0 AND wp.`website_id` = 293 AND wp.`blocked` = 0 AND wp.`active` = 1 AND p.`category_id` = 701 AND air.`attribute_item_id` IN(838,935) GROUP BY air.`product_id` HAVING COUNT(air.`product_id`) = 2',
  'sql_error' => 'Unknown column \'a.product_id\' in \'on clause\'',
  'page' => 'http://www.pricebustersmd.com/kids-furniture/beds/?a_150=838&a_171=935??a_150=838&a_171=935',
  'referer' => NULL,
  'line' => 607,
  'file' => '/gsr/platform/core/classes/products.php',
  'dir' => '/gsr/platform/core/classes',
  'function' => '',
  'class' => 'Products',
  'method' => 'Products::product_count',
  'browser_name' => 'unrecognized',
  'browser_version' => 'unknown',
  'browser_platform' => 'unrecognized',
  'browser_user_agent' => 'ccbot/2.0',
  'date_created' => '2013-05-18 16:36:46',
)

To disable these messages, edit s98_fw/config.php file.

Studio98 Framework database error: [Unknown column 'a.product_id' in 'on clause']
SELECT p.`product_id`, p.`category_id`, p.`name`, p.`slug`, p.`description`, wp.`price`, wp.`sale_price`, wp.`price_note`, wp.`status`, pi.`image`, i.`name` AS industry, IF( wp.`weight` <> 0, wp.`weight`, p.`weight` ) AS `weight` FROM `products` AS p LEFT JOIN `website_products` AS wp ON ( wp.`product_id` = p.`product_id`) LEFT JOIN `product_images` AS pi ON ( pi.`product_id` = p.`product_id`) INNER JOIN `industries` AS i ON ( i.`industry_id` = p.`industry_id`) LEFT JOIN `attribute_item_relations` AS air ON ( a.`product_id` = air.`product_id` ) WHERE p.`publish_visibility` = 'public' AND wp.`website_id` = 293 AND wp.`blocked` = 0 AND wp.`active` = 1 AND pi.`sequence` = 0 AND p.`category_id` IN(698,699,700,273,701) AND air.`attribute_item_id` IN(838,935) GROUP BY p.`product_id` HAVING COUNT(air.`product_id`) = 2 ORDER BY wp.`sequence` LIMIT 0, 9

::DEBUG:: An error has occurred:

Failed to fetch products including sub_categories.

array (
  'website_id' => 293,
  'message' => 'Failed to fetch products including sub_categories.',
  'sql' => 'SELECT p.`product_id`, p.`category_id`, p.`name`, p.`slug`, p.`description`, wp.`price`, wp.`sale_price`, wp.`price_note`, wp.`status`, pi.`image`,  i.`name` AS industry, IF( wp.`weight` <> 0, wp.`weight`, p.`weight` ) AS `weight` FROM `products` AS p LEFT JOIN `website_products` AS wp ON ( wp.`product_id` = p.`product_id`) LEFT JOIN `product_images` AS pi ON ( pi.`product_id` = p.`product_id`) INNER JOIN `industries` AS i ON ( i.`industry_id` = p.`industry_id`)  LEFT JOIN `attribute_item_relations` AS air ON ( a.`product_id` = air.`product_id` ) WHERE p.`publish_visibility` = \'public\' AND wp.`website_id` = 293 AND wp.`blocked` = 0 AND wp.`active` = 1 AND pi.`sequence` = 0 AND p.`category_id` IN(698,699,700,273,701)  AND air.`attribute_item_id` IN(838,935) GROUP BY p.`product_id`  HAVING COUNT(air.`product_id`) = 2 ORDER BY wp.`sequence` LIMIT 0, 9',
  'sql_error' => 'Unknown column \'a.product_id\' in \'on clause\'',
  'page' => 'http://www.pricebustersmd.com/kids-furniture/beds/?a_150=838&a_171=935??a_150=838&a_171=935',
  'referer' => NULL,
  'line' => 73,
  'file' => '/gsr/platform/core/classes/products.php',
  'dir' => '/gsr/platform/core/classes',
  'function' => '',
  'class' => 'Products',
  'method' => 'Products::get_products',
  'browser_name' => 'unrecognized',
  'browser_version' => 'unknown',
  'browser_platform' => 'unrecognized',
  'browser_user_agent' => 'ccbot/2.0',
  'date_created' => '2013-05-18 16:36:46',
)

To disable these messages, edit s98_fw/config.php file.

Beds furniture Baltimore MD | Price Busters Furniture

Shopping Cart My Cart
0 items: $0.00

Welcome Sign In

Call the Store
Closest to you.

West Baltimore: 443-919-6616
East Baltimore: 410-662-4071
Highlandtown/Essex: 410-282-4562
Brooklyn/Glen Burnie: 410-789-5666
Edgewood/Aberdeen: 410-612-1627

Payment Processing

Home > Products > Kids Furniture > Beds > Style: Traditional ^(x) > Type: Storage ^(x)

Narrow Your Search

Categories:

Studio98 Framework database error: [Unknown column 'a.product_id' in 'on clause']
SELECT DISTINCT p.`product_id` FROM `products` AS p LEFT JOIN `website_products` AS wp ON ( wp.`product_id` = p.`product_id` ) LEFT JOIN `product_images` AS pi ON ( pi.`product_id` = p.`product_id` ) LEFT JOIN `attribute_item_relations` AS air ON ( a.`product_id` = air.`product_id` ) WHERE p.`publish_visibility` = 'public' AND pi.`sequence` = 0 AND wp.`website_id` = 293 AND wp.`blocked` = 0 AND wp.`active` = 1 AND p.`category_id` IN(698) AND air.`attribute_item_id` IN(838,935) GROUP BY air.`product_id` HAVING COUNT(air.`product_id`) = 2

::DEBUG:: An error has occurred:

Failed to fetch product count including sub_categories.

array (
  'website_id' => 293,
  'message' => 'Failed to fetch product count including sub_categories.',
  'sql' => 'SELECT DISTINCT p.`product_id` FROM `products` AS p LEFT JOIN `website_products` AS wp ON ( wp.`product_id` = p.`product_id` ) LEFT JOIN `product_images` AS pi ON ( pi.`product_id` = p.`product_id` )  LEFT JOIN `attribute_item_relations` AS air ON ( a.`product_id` = air.`product_id` ) WHERE p.`publish_visibility` = \'public\' AND pi.`sequence` = 0 AND wp.`website_id` = 293 AND wp.`blocked` = 0 AND wp.`active` = 1 AND p.`category_id` IN(698) AND air.`attribute_item_id` IN(838,935) GROUP BY air.`product_id` HAVING COUNT(air.`product_id`) = 2',
  'sql_error' => 'Unknown column \'a.product_id\' in \'on clause\'',
  'page' => 'http://www.pricebustersmd.com/kids-furniture/beds/?a_150=838&a_171=935??a_150=838&a_171=935',
  'referer' => NULL,
  'line' => 599,
  'file' => '/gsr/platform/core/classes/products.php',
  'dir' => '/gsr/platform/core/classes',
  'function' => '',
  'class' => 'Products',
  'method' => 'Products::product_count',
  'browser_name' => 'unrecognized',
  'browser_version' => 'unknown',
  'browser_platform' => 'unrecognized',
  'browser_user_agent' => 'ccbot/2.0',
  'date_created' => '2013-05-18 16:36:46',
)

To disable these messages, edit s98_fw/config.php file.

Studio98 Framework database error: [Unknown column 'a.product_id' in 'on clause']
SELECT DISTINCT p.`product_id` FROM `products` AS p LEFT JOIN `website_products` AS wp ON ( wp.`product_id` = p.`product_id` ) LEFT JOIN `product_images` AS pi ON ( pi.`product_id` = p.`product_id` ) LEFT JOIN `attribute_item_relations` AS air ON ( a.`product_id` = air.`product_id` ) WHERE p.`publish_visibility` = 'public' AND pi.`sequence` = 0 AND wp.`website_id` = 293 AND wp.`blocked` = 0 AND wp.`active` = 1 AND p.`category_id` IN(699) AND air.`attribute_item_id` IN(838,935) GROUP BY air.`product_id` HAVING COUNT(air.`product_id`) = 2

::DEBUG:: An error has occurred:

Failed to fetch product count including sub_categories.

array (
  'website_id' => 293,
  'message' => 'Failed to fetch product count including sub_categories.',
  'sql' => 'SELECT DISTINCT p.`product_id` FROM `products` AS p LEFT JOIN `website_products` AS wp ON ( wp.`product_id` = p.`product_id` ) LEFT JOIN `product_images` AS pi ON ( pi.`product_id` = p.`product_id` )  LEFT JOIN `attribute_item_relations` AS air ON ( a.`product_id` = air.`product_id` ) WHERE p.`publish_visibility` = \'public\' AND pi.`sequence` = 0 AND wp.`website_id` = 293 AND wp.`blocked` = 0 AND wp.`active` = 1 AND p.`category_id` IN(699) AND air.`attribute_item_id` IN(838,935) GROUP BY air.`product_id` HAVING COUNT(air.`product_id`) = 2',
  'sql_error' => 'Unknown column \'a.product_id\' in \'on clause\'',
  'page' => 'http://www.pricebustersmd.com/kids-furniture/beds/?a_150=838&a_171=935??a_150=838&a_171=935',
  'referer' => NULL,
  'line' => 599,
  'file' => '/gsr/platform/core/classes/products.php',
  'dir' => '/gsr/platform/core/classes',
  'function' => '',
  'class' => 'Products',
  'method' => 'Products::product_count',
  'browser_name' => 'unrecognized',
  'browser_version' => 'unknown',
  'browser_platform' => 'unrecognized',
  'browser_user_agent' => 'ccbot/2.0',
  'date_created' => '2013-05-18 16:36:46',
)

To disable these messages, edit s98_fw/config.php file.

Studio98 Framework database error: [Unknown column 'a.product_id' in 'on clause']
SELECT DISTINCT p.`product_id` FROM `products` AS p LEFT JOIN `website_products` AS wp ON ( wp.`product_id` = p.`product_id` ) LEFT JOIN `product_images` AS pi ON ( pi.`product_id` = p.`product_id` ) LEFT JOIN `attribute_item_relations` AS air ON ( a.`product_id` = air.`product_id` ) WHERE p.`publish_visibility` = 'public' AND pi.`sequence` = 0 AND wp.`website_id` = 293 AND wp.`blocked` = 0 AND wp.`active` = 1 AND p.`category_id` IN(700) AND air.`attribute_item_id` IN(838,935) GROUP BY air.`product_id` HAVING COUNT(air.`product_id`) = 2

::DEBUG:: An error has occurred:

Failed to fetch product count including sub_categories.

array (
  'website_id' => 293,
  'message' => 'Failed to fetch product count including sub_categories.',
  'sql' => 'SELECT DISTINCT p.`product_id` FROM `products` AS p LEFT JOIN `website_products` AS wp ON ( wp.`product_id` = p.`product_id` ) LEFT JOIN `product_images` AS pi ON ( pi.`product_id` = p.`product_id` )  LEFT JOIN `attribute_item_relations` AS air ON ( a.`product_id` = air.`product_id` ) WHERE p.`publish_visibility` = \'public\' AND pi.`sequence` = 0 AND wp.`website_id` = 293 AND wp.`blocked` = 0 AND wp.`active` = 1 AND p.`category_id` IN(700) AND air.`attribute_item_id` IN(838,935) GROUP BY air.`product_id` HAVING COUNT(air.`product_id`) = 2',
  'sql_error' => 'Unknown column \'a.product_id\' in \'on clause\'',
  'page' => 'http://www.pricebustersmd.com/kids-furniture/beds/?a_150=838&a_171=935??a_150=838&a_171=935',
  'referer' => NULL,
  'line' => 599,
  'file' => '/gsr/platform/core/classes/products.php',
  'dir' => '/gsr/platform/core/classes',
  'function' => '',
  'class' => 'Products',
  'method' => 'Products::product_count',
  'browser_name' => 'unrecognized',
  'browser_version' => 'unknown',
  'browser_platform' => 'unrecognized',
  'browser_user_agent' => 'ccbot/2.0',
  'date_created' => '2013-05-18 16:36:46',
)

To disable these messages, edit s98_fw/config.php file.

Studio98 Framework database error: [Unknown column 'a.product_id' in 'on clause']
SELECT DISTINCT p.`product_id` FROM `products` AS p LEFT JOIN `website_products` AS wp ON ( wp.`product_id` = p.`product_id` ) LEFT JOIN `product_images` AS pi ON ( pi.`product_id` = p.`product_id` ) LEFT JOIN `attribute_item_relations` AS air ON ( a.`product_id` = air.`product_id` ) WHERE p.`publish_visibility` = 'public' AND pi.`sequence` = 0 AND wp.`website_id` = 293 AND wp.`blocked` = 0 AND wp.`active` = 1 AND p.`category_id` IN(273) AND air.`attribute_item_id` IN(838,935) GROUP BY air.`product_id` HAVING COUNT(air.`product_id`) = 2

::DEBUG:: An error has occurred:

Failed to fetch product count including sub_categories.

array (
  'website_id' => 293,
  'message' => 'Failed to fetch product count including sub_categories.',
  'sql' => 'SELECT DISTINCT p.`product_id` FROM `products` AS p LEFT JOIN `website_products` AS wp ON ( wp.`product_id` = p.`product_id` ) LEFT JOIN `product_images` AS pi ON ( pi.`product_id` = p.`product_id` )  LEFT JOIN `attribute_item_relations` AS air ON ( a.`product_id` = air.`product_id` ) WHERE p.`publish_visibility` = \'public\' AND pi.`sequence` = 0 AND wp.`website_id` = 293 AND wp.`blocked` = 0 AND wp.`active` = 1 AND p.`category_id` IN(273) AND air.`attribute_item_id` IN(838,935) GROUP BY air.`product_id` HAVING COUNT(air.`product_id`) = 2',
  'sql_error' => 'Unknown column \'a.product_id\' in \'on clause\'',
  'page' => 'http://www.pricebustersmd.com/kids-furniture/beds/?a_150=838&a_171=935??a_150=838&a_171=935',
  'referer' => NULL,
  'line' => 599,
  'file' => '/gsr/platform/core/classes/products.php',
  'dir' => '/gsr/platform/core/classes',
  'function' => '',
  'class' => 'Products',
  'method' => 'Products::product_count',
  'browser_name' => 'unrecognized',
  'browser_version' => 'unknown',
  'browser_platform' => 'unrecognized',
  'browser_user_agent' => 'ccbot/2.0',
  'date_created' => '2013-05-18 16:36:46',
)

To disable these messages, edit s98_fw/config.php file.

Studio98 Framework database error: [Unknown column 'a.product_id' in 'on clause']
SELECT DISTINCT p.`product_id` FROM `products` AS p LEFT JOIN `website_products` AS wp ON ( wp.`product_id` = p.`product_id` ) LEFT JOIN `product_images` AS pi ON ( pi.`product_id` = p.`product_id` ) LEFT JOIN `attribute_item_relations` AS air ON ( a.`product_id` = air.`product_id` ) WHERE p.`publish_visibility` = 'public' AND pi.`sequence` = 0 AND wp.`website_id` = 293 AND wp.`blocked` = 0 AND wp.`active` = 1 AND p.`category_id` IN(698,699,700,273,701) AND air.`attribute_item_id` IN(838,935) GROUP BY air.`product_id` HAVING COUNT(air.`product_id`) = 2

::DEBUG:: An error has occurred:

Failed to fetch product count including sub_categories.

array (
  'website_id' => 293,
  'message' => 'Failed to fetch product count including sub_categories.',
  'sql' => 'SELECT DISTINCT p.`product_id` FROM `products` AS p LEFT JOIN `website_products` AS wp ON ( wp.`product_id` = p.`product_id` ) LEFT JOIN `product_images` AS pi ON ( pi.`product_id` = p.`product_id` )  LEFT JOIN `attribute_item_relations` AS air ON ( a.`product_id` = air.`product_id` ) WHERE p.`publish_visibility` = \'public\' AND pi.`sequence` = 0 AND wp.`website_id` = 293 AND wp.`blocked` = 0 AND wp.`active` = 1 AND p.`category_id` IN(698,699,700,273,701) AND air.`attribute_item_id` IN(838,935) GROUP BY air.`product_id` HAVING COUNT(air.`product_id`) = 2',
  'sql_error' => 'Unknown column \'a.product_id\' in \'on clause\'',
  'page' => 'http://www.pricebustersmd.com/kids-furniture/beds/?a_150=838&a_171=935??a_150=838&a_171=935',
  'referer' => NULL,
  'line' => 599,
  'file' => '/gsr/platform/core/classes/products.php',
  'dir' => '/gsr/platform/core/classes',
  'function' => '',
  'class' => 'Products',
  'method' => 'Products::product_count',
  'browser_name' => 'unrecognized',
  'browser_version' => 'unknown',
  'browser_platform' => 'unrecognized',
  'browser_user_agent' => 'ccbot/2.0',
  'date_created' => '2013-05-18 16:36:46',
)

To disable these messages, edit s98_fw/config.php file.

Clear Selections

Beds

Showing 1 – 0 of 0 Results

Items per page: