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` != 180126 AND `EstoreProduct`.`user_id` = 340 AND `EstoreProductsCategory`.`category_id` = 20051 AND `EstoreProduct`.`title`
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` != 180126 AND `EstoreProduct`.`user_id` = 340 AND `EstoreProductsCategory`.`category_id` = 20051 AND `EstoreProduct`.`title`>Calftail - Red ORDER BY `EstoreProduct`.`title` ASC LIMIT 1
Warning: SQL Error: 1054: Unknown column 'Calftail' in 'where clause' in /home/pagetree/public_html/cake/libs/model/datasources/dbo_source.php on line 492
Calftail - Red
$1.85