Last active
November 15, 2017 15:56
-
-
Save DimaSoroka/b2be019a6921e972d3b21e4c8d2fed1d to your computer and use it in GitHub Desktop.
query to review
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT | |
o0_.serialized_data AS serialized_data_0, | |
o0_.id AS id_1, | |
o0_.materialized_path AS materialized_path_2, | |
o0_.title AS title_3, | |
o0_.created_at AS created_at_4, | |
o0_.updated_at AS updated_at_5, | |
o0_.tree_left AS tree_left_6, | |
o0_.tree_level AS tree_level_7, | |
o0_.tree_right AS tree_right_8, | |
o0_.tree_root AS tree_root_9, | |
o1_.id AS id_10, | |
o0_.id AS id_11 | |
FROM | |
oro_catalog_category o0_ | |
INNER JOIN oro_product o1_ | |
ON ( | |
EXISTS | |
(SELECT | |
1 | |
FROM | |
oro_category_to_product o2_ | |
INNER JOIN oro_product o3_ | |
ON o2_.product_id = o3_.id | |
WHERE o2_.category_id = o0_.id | |
AND o3_.id IN (o1_.id)) | |
) | |
WHERE o1_.id IN ( | |
557001, | |
557002, | |
557003, | |
557004, | |
557005, | |
557006, | |
557007, | |
557008, | |
557009, | |
557010, | |
557011, | |
557012, | |
557013, | |
557014, | |
557015, | |
557016, | |
557017, | |
557018, | |
557019, | |
557020, | |
557021, | |
557022, | |
557023, | |
557024, | |
557025, | |
557026, | |
557027, | |
557028, | |
557029, | |
557030, | |
557031, | |
557032, | |
557033, | |
557034, | |
557035, | |
557036, | |
557037, | |
557038, | |
557039, | |
557040, | |
557041, | |
557042, | |
557043, | |
557044, | |
557045, | |
557046, | |
557047, | |
557048, | |
557049, | |
557050, | |
557051, | |
557052, | |
557053, | |
557054, | |
557055, | |
557056, | |
557057, | |
557058, | |
557059, | |
557060, | |
557061, | |
557062, | |
557063, | |
557064, | |
557065, | |
557066, | |
557067, | |
557068, | |
557069, | |
557070, | |
557071, | |
557072, | |
557073, | |
557074, | |
557075, | |
557076, | |
557077, | |
557078, | |
557079, | |
557080, | |
557081, | |
557082, | |
557083, | |
557084, | |
557085, | |
557086, | |
557087, | |
557088, | |
557089, | |
557090, | |
557091, | |
557092, | |
557093, | |
557094, | |
557095, | |
557096, | |
557097, | |
557098, | |
557099, | |
557100 | |
) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment