SELECT `p`.`id`, `p`.`product_unique_id`, `p`.`product_visible`, `p`.`product_title`, `p`.`product_name`, `p`.`path`, `p`.`can_pre_order`, `p`.`color`, `p`.`brand_id`, `p`.`main_category_id`, `p`.`gross`, `p`.`sale_gross`, `p`.`sale_start`, `p`.`sale_end`, `p`.`product_description`, `p`.`product_meta_description`, `p`.`product_meta_keywords`, `b`.`name` AS `brand_name`, `b`.`path` AS `brand_path`, `b`.`description` AS `brand_description`, `c`.`title` AS `main_category`, `c`.`path` AS `main_category_path`
FROM `webshop_product` `p`
LEFT JOIN `webshop_brands` `b` ON `b`.`brand_id`=`p`.`brand_id`
JOIN `webshop_category` `c` ON `c`.`category_id`=`p`.`main_category_id`
WHERE `p`.`path` = 'coerver-extra-vasteras-fredagar'
AND `p`.`active` = 1
AND `p`.`product_visible` = 1
404 Page Not Found