1.) Select Background 2.) Select Pattern 3.) Select Color
Query: SELECT `Custompatterncolor`.`id`, `Custompatterncolor`.`custompattern_id`, `Custompatterncolor`.`filepath`, `Custompatterncolor`.`thumbpath`, `Custompatterncolor`.`name`, `Custompattern`.`id`, `Custompattern`.`filepath`, `Custompattern`.`thumbpath`, `Custompattern`.`name`, `Custompattern`.`blurb`, `Custompattern`.`displayorder` FROM `custompatterncolors` AS `Custompatterncolor` LEFT JOIN `custompatterns` AS `Custompattern` ON (`Custompatterncolor`.`custompattern_id` = `Custompattern`.`id`) WHERE custompattern_id = ORDER BY `Custompatterncolor`.`name` ASC Warning: SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY `Custompatterncolor`.`name` ASC' at line 1 in /big/dom/xwalterknabe/www/cake/libs/model/datasources/dbo_source.php on line 463
1.) Select Background 2.) Select Pattern 3.) Select Color