No record
DataModel : 486
SELECT   `product`.`id` AS `productid`,
`product`.`id` AS `prikey`,
`product`.`id` AS `id`,
`product`.`order` AS `order`,
`product`.`name` AS `name`,
`product`.`noindex` AS `noindex`,
`product`.`name_fr` AS `name_lng`,
`product`.`og_description_fr` AS `og_description_lng`,
`product`.`description_fr` AS `description_lng`,
`product`.`category_id` AS `category_id`,
`product`.`style_id` AS `style_id`,
`product`.`finish_id` AS `finish_id`,
`product`.`detail_id` AS `detail_id`,
`product`.`list_image` AS `list_image`,
`product`.`product_number` AS `product_number`,
`product`.`price` AS `price`,
`product`.`price_ca` AS `price_ca`,
`product`.`price_us` AS `price_us`,
`product`.`etag` AS `etag`,
`product`.`instruction_manual` AS `instruction_manual`,
`product`.`shopify_id` AS `shopify_id`,
`product`.`shopify_id_us` AS `shopify_id_us`,
`product`.`shopify_id_ca` AS `shopify_id_ca`,
`product`.`enabled` AS `enabled`,
`product`.`stock` AS `stock`,
`product`.`artika_pro` AS `artika_pro`,
`product`.`smartika_item` AS `smartika_item`,
`product`.`energy_star` AS `energy_star`,
`product_category`.`id` AS `product_category___id`,
`product_category`.`order` AS `product_category___order`,
`product_category`.`name` AS `product_category___name`,
`product_category`.`name_fr` AS `product_category___name_lng`,
`product_category`.`image` AS `product_category___image`,
`product_category`.`header_image` AS `product_category___header_image`,
`product_category`.`header_label_fr` AS `product_category___header_label_lng`,
`product_category`.`link_label_fr` AS `product_category___link_label_lng`,
`product_category`.`hide` AS `product_category___hide`,
`product_category`.`hide_menu` AS `product_category___hide_menu`,
`product_category`.`meta_description_fr` AS `product_category___meta_description_lng`,
`product_category`.`og_image` AS `product_category___og_image` 
FROM `product` 
LEFT JOIN `product_category` AS `product_category` ON (`product`.`category_id` = `product_category`.`id`) AND (`product_category`.`___tmp` = 0) 
WHERE 
product.category_id NOT IN (14) AND `product`.`id` = '201' AND `product`.`enabled` = '1' AND (`product`.`___tmp` = 0) 
 
 
 
 LIMIT 1