E-Store
Query: SELECT DISTINCT `EstoreProduct`.`id`, `EstoreProduct`.*, `EstoreProductsCategory`.*, IFNULL(`EstoreProduct`.`active`, "") AS `active`, `EstoreProduct`.`id` FROM `estore_products` AS `EstoreProduct` LEFT JOIN `estore_brands` AS `EstoreBrand` ON (`EstoreProduct`.`brand_id` = `EstoreBrand`.`id`) LEFT JOIN `estore_products_categories` AS `EstoreProductsCategory` ON (`EstoreProductsCategory`.`product_id` = `EstoreProduct`.`id`) WHERE `EstoreProduct`.`id` != 181240 AND `EstoreProduct`.`user_id` = 340 AND `EstoreProductsCategory`.`category_id` = 19959 AND `EstoreProduct`.`title`