CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `elastic_working2`.`view_skus` AS select `elastic_working2`.`clients`.`name` AS `client`,`elastic_working2`.`products`.`name` AS `name`,`elastic_working2`.`products`.`num` AS `product_num`,`elastic_working2`.`products`.`weight` AS `weight`,`elastic_working2`.`products`.`sex` AS `sex`,`elastic_working2`.`products`.`about` AS `about`,`elastic_working2`.`product_colors`.`name` AS `product_color`,`elastic_working2`.`product_sizes`.`name` AS `size`,`elastic_working2`.`product_skus`.`sku` AS `sku`,`elastic_working2`.`products`.`id` AS `product_id`,`elastic_working2`.`product_skus`.`id` AS `product_sku_id` from ((((((`elastic_working2`.`products` join `elastic_working2`.`product_skus` on((`elastic_working2`.`product_skus`.`product_id` = `elastic_working2`.`products`.`id`))) join `elastic_working2`.`product_colors` on((`elastic_working2`.`product_colors`.`id` = `elastic_working2`.`product_skus`.`product_color_id`))) join `elastic_working2`.`product_sizes` on((`elastic_working2`.`product_sizes`.`id` = `elastic_working2`.`product_skus`.`product_size_id`))) join `elastic_working2`.`product_regions` on((`elastic_working2`.`product_regions`.`product_id` = `elastic_working2`.`products`.`id`))) join `elastic_working2`.`regions` on((`elastic_working2`.`regions`.`id` = `elastic_working2`.`product_regions`.`region_id`))) join `elastic_working2`.`clients` on((`elastic_working2`.`clients`.`id` = `elastic_working2`.`regions`.`client_id`))) where ((`elastic_working2`.`products`.`is_deleted` = 0) and (`elastic_working2`.`product_skus`.`is_deleted` = 0) and (`elastic_working2`.`product_colors`.`is_deleted` = 0) and (`elastic_working2`.`product_sizes`.`is_deleted` = 0) and (`elastic_working2`.`product_regions`.`is_deleted` = 0) and (`elastic_working2`.`regions`.`is_deleted` = 0) and (`elastic_working2`.`clients`.`is_deleted` = 0));