2 | SELECT `Special`.`id`, `Special`.`name`, `Special`.`available_width`, `Special`.`available_length`, `Special`.`discount`, `Special`.`product_id`, `Special`.`product_formulas_id`, `Special`.`description`, `Product`.`id`, `Product`.`slug`, `Product`.`title`, `Product`.`display_title`, `Product`.`description`, `Product`.`img`, `Product`.`coa`, `Product`.`cropping`, `Product`.`deckled`, `Product`.`dropdown`, `Product`.`edge`, `Product`.`hanger`, `Product`.`mount`, `Product`.`ships`, `Product`.`weight`, `Product`.`w_min`, `Product`.`w_max`, `Product`.`h_min`, `Product`.`h_max`, `Product`.`active`, `Product`.`display_active`, `Product`.`modified`, `Product`.`size_text`, `Product`.`created`, `ProductFormula`.`id`, `ProductFormula`.`product_id`, `ProductFormula`.`product_type_id`, `ProductFormula`.`order_id`, `ProductFormula`.`title`, `ProductFormula`.`area_waste`, `ProductFormula`.`scrap`, `ProductFormula`.`medium`, `ProductFormula`.`ink`, `ProductFormula`.`packing_constant1`, `ProductFormula`.`packing_constant2`, `ProductFormula`.`coating`, `ProductFormula`.`bars_constant1`, `ProductFormula`.`bars_constant2`, `ProductFormula`.`labor`, `ProductFormula`.`multiplier`, `ProductFormula`.`add_labor`, `ProductFormula`.`add_edge`, `ProductFormula`.`active`, `ProductFormula`.`created`, `ProductFormula`.`modified` FROM `aae_cake_stage`.`specials` AS `Special` LEFT JOIN `aae_cake_stage`.`products` AS `Product` ON (`Special`.`product_id` = `Product`.`id`) LEFT JOIN `aae_cake_stage`.`product_formulas` AS `ProductFormula` ON (`Special`.`product_id` = `ProductFormula`.`id`) WHERE 1 = 1 LIMIT 20 | | 9 | 9 | 2 |