Skip to Content
author's profile photo Former Member
Former Member

Database performance issues

We recently hit a problem in our development environment where the CPU of the database server (MySQL) hit 100%. This was when running an Initialize for product cockpit.

We have executed SHOW FULL PROCESSLIST on the database server to see what was running. There were 3 queries like this:

SELECT item_t0.PK, item_t0.TypePkString, item_t0.code, lp_t0.p_name, lp_t0_l1.p_name, lp_t0_l2.p_name, lp_t0_l3.p_name, lp_t0_l4.p_name, lp_t0_l5.p_name, lp_t0_l6.p_name, lp_t0_l7.p_name, lp_t0_l8.p_name, lp_t0_l9.p_name, lp_t0_l10.p_name, lp_t0_l11.p_name, lp_t0_l12.p_name, lp_t0_l13.p_name, lp_t0_l14.p_name, lp_t0_l15.p_name, lp_t0_l16.p_name, lp_t0_l17.p_name, lp_t0_l18.p_name, lp_t0_l19.p_name, lp_t0_l20.p_name, lp_t0_l21.p_name, lp_t0_l22.p_name, lp_t0_l23.p_name, lp_t0_l24.p_name, lp_t0_l25.p_name, lp_t0_l26.p_name, lp_t0_l27.p_name, lp_t0_l28.p_name, lp_t0_l29.p_name, lp_t0_l30.p_name, lp_t0_l31.p_name, lp_t0_l32.p_name, lp_t0_l33.p_name, lp_t0_l34.p_name, lp_t0_l35.p_name, lp_t0_l36.p_name, lp_t0_l37.p_name, lp_t0_l38.p_name, lp_t0_l39.p_name, lp_t0_l40.p_name, lp_t0_l41.p_name, lp_t0_l42.p_name, lp_t0_l43.p_name, lp_t0_l44.p_name, lp_t0_l45.p_name, lp_t0_l46.p_name, lp_t0_l47.p_name, lp_t0_l48.p_name FROM userrights item_t0 LEFT JOIN userrightslp lp_t0 ON item_t0.PK = lp_t0.ITEMPK AND lp_t0.LANGPK =8796096856096 LEFT JOIN userrightslp lp_t0_l1 ON item_t0.PK = lp_t0_l1.ITEMPK AND lp_t0_l1.LANGPK =8796099117088 LEFT JOIN userrightslp lp_t0_l2 ON item_t0.PK = lp_t0_l2.ITEMPK AND lp_t0_l2.LANGPK =8796099149856 LEFT JOIN userrightslp lp_t0_l3 ON item_t0.PK = lp_t0_l3.ITEMPK AND lp_t0_l3.LANGPK =8796095184928 LEFT JOIN userrightslp lp_t0_l4 ON item_t0.PK = lp_t0_l4.ITEMPK AND lp_t0_l4.LANGPK =8796096102432 LEFT JOIN userrightslp lp_t0_l5 ON item_t0.PK = lp_t0_l5.ITEMPK AND lp_t0_l5.LANGPK =8796098101280 LEFT JOIN userrightslp lp_t0_l6 ON item_t0.PK = lp_t0_l6.ITEMPK AND lp_t0_l6.LANGPK =8796095316000 LEFT JOIN userrightslp lp_t0_l7 ON item_t0.PK = lp_t0_l7.ITEMPK AND lp_t0_l7.LANGPK =8796096036896 LEFT JOIN userrightslp lp_t0_l8 ON item_t0.PK = lp_t0_l8.ITEMPK AND lp_t0_l8.LANGPK =8796098986016 LEFT JOIN userrightslp lp_t0_l9 ON item_t0.PK = lp_t0_l9.ITEMPK AND lp_t0_l9.LANGPK =8796096888864 LEFT JOIN userrightslp lp_t0_l10 ON item_t0.PK = lp_t0_l10.ITEMPK AND lp_t0_l10.LANGPK =8796095676448 LEFT JOIN userrightslp lp_t0_l11 ON item_t0.PK = lp_t0_l11.ITEMPK AND lp_t0_l11.LANGPK =8796095610912 LEFT JOIN userrightslp lp_t0_l12 ON item_t0.PK = lp_t0_l12.ITEMPK AND lp_t0_l12.LANGPK =8796093743136 LEFT JOIN userrightslp lp_t0_l13 ON item_t0.PK = lp_t0_l13.ITEMPK AND lp_t0_l13.LANGPK =8796096528416 LEFT JOIN userrightslp lp_t0_l14 ON item_t0.PK = lp_t0_l14.ITEMPK AND lp_t0_l14.LANGPK =8796095938592 LEFT JOIN userrightslp lp_t0_l15 ON item_t0.PK = lp_t0_l15.ITEMPK AND lp_t0_l15.LANGPK =8796097740832 LEFT JOIN userrightslp lp_t0_l16 ON item_t0.PK = lp_t0_l16.ITEMPK AND lp_t0_l16.LANGPK =8796094070816 LEFT JOIN userrightslp lp_t0_l17 ON item_t0.PK = lp_t0_l17.ITEMPK AND lp_t0_l17.LANGPK =8796094234656 LEFT JOIN userrightslp lp_t0_l18 ON item_t0.PK = lp_t0_l18.ITEMPK AND lp_t0_l18.LANGPK =8796093251616 LEFT JOIN userrightslp lp_t0_l19 ON item_t0.PK = lp_t0_l19.ITEMPK AND lp_t0_l19.LANGPK =8796098297888 LEFT JOIN userrightslp lp_t0_l21 ON item_t0.PK = lp_t0_l21.ITEMPK AND lp_t0_l21.LANGPK =8796093382688 LEFT JOIN userrightslp lp_t0_l20 ON item_t0.PK = lp_t0_l20.ITEMPK AND lp_t0_l20.LANGPK =8796095053856 LEFT JOIN userrightslp lp_t0_l22 ON item_t0.PK = lp_t0_l22.ITEMPK AND lp_t0_l22.LANGPK =8796095774752 LEFT JOIN userrightslp lp_t0_l23 ON item_t0.PK = lp_t0_l23.ITEMPK AND lp_t0_l23.LANGPK =8796096725024 LEFT JOIN userrightslp lp_t0_l24 ON item_t0.PK = lp_t0_l24.ITEMPK AND lp_t0_l24.LANGPK =8796098887712 LEFT JOIN userrightslp lp_t0_l25 ON item_t0.PK = lp_t0_l25.ITEMPK AND lp_t0_l25.LANGPK =8796095643680 LEFT JOIN userrightslp lp_t0_l26 ON item_t0.PK = lp_t0_l26.ITEMPK AND lp_t0_l26.LANGPK =8796098854944 LEFT JOIN userrightslp lp_t0_l27 ON item_t0.PK = lp_t0_l27.ITEMPK AND lp_t0_l27.LANGPK =8796095840288 LEFT JOIN userrightslp lp_t0_l28 ON item_t0.PK = lp_t0_l28.ITEMPK AND lp_t0_l28.LANGPK =8796093644832 LEFT JOIN userrightslp lp_t0_l29 ON item_t0.PK = lp_t0_l29.ITEMPK AND lp_t0_l29.LANGPK =8796093546528 LEFT JOIN userrightslp lp_t0_l30 ON item_t0.PK = lp_t0_l30.ITEMPK AND lp_t0_l30.LANGPK =8796093415456 LEFT JOIN userrightslp lp_t0_l31 ON item_t0.PK = lp_t0_l31.ITEMPK AND lp_t0_l31.LANGPK =8796096233504 LEFT JOIN userrightslp lp_t0_l32 ON item_t0.PK = lp_t0_l32.ITEMPK AND lp_t0_l32.LANGPK =8796095545376 LEFT JOIN userrightslp lp_t0_l33 ON item_t0.PK = lp_t0_l33.ITEMPK AND lp_t0_l33.LANGPK =8796095512608 LEFT JOIN userrightslp lp_t0_l34 ON item_t0.PK = lp_t0_l34.ITEMPK AND lp_t0_l34.LANGPK =8796093939744 LEFT JOIN userrightslp lp_t0_l35 ON item_t0.PK = lp_t0_l35.ITEMPK AND lp_t0_l35.LANGPK =8796095414304 LEFT JOIN userrightslp lp_t0_l36 ON item_t0.PK = lp_t0_l36.ITEMPK AND lp_t0_l36.LANGPK =8796093480992 LEFT JOIN userrightslp lp_t0_l37 ON item_t0.PK = lp_t0_l37.ITEMPK AND lp_t0_l37.LANGPK =8796094824480 LEFT JOIN userrightslp lp_t0_l38 ON item_t0.PK = lp_t0_l38.ITEMPK AND lp_t0_l38.LANGPK =8796099084320 LEFT JOIN userrightslp lp_t0_l39 ON item_t0.PK = lp_t0_l39.ITEMPK AND lp_t0_l39.LANGPK =8796098920480 LEFT JOIN userrightslp lp_t0_l40 ON item_t0.PK = lp_t0_l40.ITEMPK AND lp_t0_l40.LANGPK =8796093284384 LEFT JOIN userrightslp lp_t0_l41 ON item_t0.PK = lp_t0_l41.ITEMPK AND lp_t0_l41.LANGPK =8796097544224 LEFT JOIN userrightslp lp_t0_l42 ON item_t0.PK = lp_t0_l42.ITEMPK AND lp_t0_l42.LANGPK =8796098068512 LEFT JOIN userrightslp lp_t0_l43 ON item_t0.PK = lp_t0_l43.ITEMPK AND lp_t0_l43.LANGPK =8796099379232 LEFT JOIN userrightslp lp_t0_l44 ON item_t0.PK = lp_t0_l44.ITEMPK AND lp_t0_l44.LANGPK =8796097609760 LEFT JOIN userrightslp lp_t0_l45 ON item_t0.PK = lp_t0_l45.ITEMPK AND lp_t0_l45.LANGPK =8796097249312 LEFT JOIN userrightslp lp_t0_l46 ON item_t0.PK = lp_t0_l46.ITEMPK AND lp_t0_l46.LANGPK =8796093186080 LEFT JOIN userrightslp lp_t0_l47 ON item_t0.PK = lp_t0_l47.ITEMPK AND lp_t0_l47.LANGPK =8796094857248 LEFT JOIN userrightslp lp_t0_l48 ON item_t0.PK = lp_t0_l48.ITEMPK AND lp_t0_l48.LANGPK =8796095217696 WHERE (item_t0.TypePkString IN (8796134375506) AND (item_t0.PK IN (8796093055005,8796093087773,8796093120541,8796093153309,8796093186077))) AND (item_t0.TypePkString=8796134375506) ORDER BY item_t0.createdTS ASC, item_t0.PK ASC

Sure enough, any attempt to run this query takes such a long time that we have not actually seen it return a result!

My assumption is that a query like this could be executed by Hybris in our production environment at any point in time (we're not live yet). Because of this, I'm keen to understand if there is anything we can do to ensure if the system ever executed such a query, then it would return a response quickly.

Possibly we're missing an index. An EXPLAIN on the above query shows:

id;select_type;table;type;possible_keys;key;key_len;ref;rows;Extra 1;SIMPLE;item_t0;ALL;PRIMARY;\N;\N;\N;5;Using where; Using temporary; Using filesort 1;SIMPLE;lp_t0;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l1;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l2;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l3;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l4;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l5;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l6;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l7;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l8;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l9;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l10;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l11;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l12;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l13;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l14;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l15;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l16;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l17;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l18;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l19;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l21;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l20;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l22;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l23;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l24;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l25;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l26;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l27;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l28;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l29;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l30;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l31;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l32;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l33;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l34;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l35;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l36;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l37;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l38;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l39;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l40;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l41;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l42;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l43;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l44;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l45;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l46;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l47;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop) 1;SIMPLE;lp_t0_l48;ALL;PRIMARY;\N;\N;\N;1;Using where; Using join buffer (Block Nested Loop)

Can anyone help at all?

Thanks, Martin

Add a comment
10|10000 characters needed characters exceeded

  • Former Member

    B2B or B2C? Looking at the parameters that are returned by the query it doesn't look like it's a standard query. Can you turn on the JDBC logging from the HAC console for a short period of time with trace appending enabled. The JDBC logs will show you the caller of this query (e.g. the Java code executing the query)

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Apr 15, 2015 at 11:39 PM

    Not sure if this has been resolved.

    I would start to check if there is an index on userrightslp (itempk, langpk )

     SELECT item_t0.pk, 
            item_t0.typepkstring, 
            item_t0.code, 
            lp_t0.p_name, 
            lp_t0_l1.p_name, 
            lp_t0_l2.p_name, 
            lp_t0_l3.p_name, 
            lp_t0_l4.p_name, 
            lp_t0_l5.p_name, 
            lp_t0_l6.p_name, 
            lp_t0_l7.p_name, 
            lp_t0_l8.p_name, 
            lp_t0_l9.p_name, 
            lp_t0_l10.p_name, 
            lp_t0_l11.p_name, 
            lp_t0_l12.p_name, 
            lp_t0_l13.p_name, 
            lp_t0_l14.p_name, 
            lp_t0_l15.p_name, 
            lp_t0_l16.p_name, 
            lp_t0_l17.p_name, 
            lp_t0_l18.p_name, 
            lp_t0_l19.p_name, 
            lp_t0_l20.p_name, 
            lp_t0_l21.p_name, 
            lp_t0_l22.p_name, 
            lp_t0_l23.p_name, 
            lp_t0_l24.p_name, 
            lp_t0_l25.p_name, 
            lp_t0_l26.p_name, 
            lp_t0_l27.p_name, 
            lp_t0_l28.p_name, 
            lp_t0_l29.p_name, 
            lp_t0_l30.p_name, 
            lp_t0_l31.p_name, 
            lp_t0_l32.p_name, 
            lp_t0_l33.p_name, 
            lp_t0_l34.p_name, 
            lp_t0_l35.p_name, 
            lp_t0_l36.p_name, 
            lp_t0_l37.p_name, 
            lp_t0_l38.p_name, 
            lp_t0_l39.p_name, 
            lp_t0_l40.p_name, 
            lp_t0_l41.p_name, 
            lp_t0_l42.p_name, 
            lp_t0_l43.p_name, 
            lp_t0_l44.p_name, 
            lp_t0_l45.p_name, 
            lp_t0_l46.p_name, 
            lp_t0_l47.p_name, 
            lp_t0_l48.p_name 
     FROM   userrights item_t0 
            LEFT JOIN userrightslp lp_t0 
                   ON item_t0.pk = lp_t0.itempk 
                      AND lp_t0.langpk = 8796096856096 
            LEFT JOIN userrightslp lp_t0_l1 
                   ON item_t0.pk = lp_t0_l1.itempk 
                      AND lp_t0_l1.langpk = 8796099117088 
            LEFT JOIN userrightslp lp_t0_l2 
                   ON item_t0.pk = lp_t0_l2.itempk 
                      AND lp_t0_l2.langpk = 8796099149856 
            LEFT JOIN userrightslp lp_t0_l3 
                   ON item_t0.pk = lp_t0_l3.itempk 
                      AND lp_t0_l3.langpk = 8796095184928 
            LEFT JOIN userrightslp lp_t0_l4 
                   ON item_t0.pk = lp_t0_l4.itempk 
                      AND lp_t0_l4.langpk = 8796096102432 
            LEFT JOIN userrightslp lp_t0_l5 
                   ON item_t0.pk = lp_t0_l5.itempk 
                      AND lp_t0_l5.langpk = 8796098101280 
            LEFT JOIN userrightslp lp_t0_l6 
                   ON item_t0.pk = lp_t0_l6.itempk 
                      AND lp_t0_l6.langpk = 8796095316000 
            LEFT JOIN userrightslp lp_t0_l7 
                   ON item_t0.pk = lp_t0_l7.itempk 
                      AND lp_t0_l7.langpk = 8796096036896 
            LEFT JOIN userrightslp lp_t0_l8 
                   ON item_t0.pk = lp_t0_l8.itempk 
                      AND lp_t0_l8.langpk = 8796098986016 
            LEFT JOIN userrightslp lp_t0_l9 
                   ON item_t0.pk = lp_t0_l9.itempk 
                      AND lp_t0_l9.langpk = 8796096888864 
            LEFT JOIN userrightslp lp_t0_l10 
                   ON item_t0.pk = lp_t0_l10.itempk 
                      AND lp_t0_l10.langpk = 8796095676448 
            LEFT JOIN userrightslp lp_t0_l11 
                   ON item_t0.pk = lp_t0_l11.itempk 
                      AND lp_t0_l11.langpk = 8796095610912 
            LEFT JOIN userrightslp lp_t0_l12 
                   ON item_t0.pk = lp_t0_l12.itempk 
                      AND lp_t0_l12.langpk = 8796093743136 
            LEFT JOIN userrightslp lp_t0_l13 
                   ON item_t0.pk = lp_t0_l13.itempk 
                      AND lp_t0_l13.langpk = 8796096528416 
            LEFT JOIN userrightslp lp_t0_l14 
                   ON item_t0.pk = lp_t0_l14.itempk 
                      AND lp_t0_l14.langpk = 8796095938592 
            LEFT JOIN userrightslp lp_t0_l15 
                   ON item_t0.pk = lp_t0_l15.itempk 
                      AND lp_t0_l15.langpk = 8796097740832 
            LEFT JOIN userrightslp lp_t0_l16 
                   ON item_t0.pk = lp_t0_l16.itempk 
                      AND lp_t0_l16.langpk = 8796094070816 
            LEFT JOIN userrightslp lp_t0_l17 
                   ON item_t0.pk = lp_t0_l17.itempk 
                      AND lp_t0_l17.langpk = 8796094234656 
            LEFT JOIN userrightslp lp_t0_l18 
                   ON item_t0.pk = lp_t0_l18.itempk 
                      AND lp_t0_l18.langpk = 8796093251616 
            LEFT JOIN userrightslp lp_t0_l19 
                   ON item_t0.pk = lp_t0_l19.itempk 
                      AND lp_t0_l19.langpk = 8796098297888 
            LEFT JOIN userrightslp lp_t0_l21 
                   ON item_t0.pk = lp_t0_l21.itempk 
                      AND lp_t0_l21.langpk = 8796093382688 
            LEFT JOIN userrightslp lp_t0_l20 
                   ON item_t0.pk = lp_t0_l20.itempk 
                      AND lp_t0_l20.langpk = 8796095053856 
            LEFT JOIN userrightslp lp_t0_l22 
                   ON item_t0.pk = lp_t0_l22.itempk 
                      AND lp_t0_l22.langpk = 8796095774752 
            LEFT JOIN userrightslp lp_t0_l23 
                   ON item_t0.pk = lp_t0_l23.itempk 
                      AND lp_t0_l23.langpk = 8796096725024 
            LEFT JOIN userrightslp lp_t0_l24 
                   ON item_t0.pk = lp_t0_l24.itempk 
                      AND lp_t0_l24.langpk = 8796098887712 
            LEFT JOIN userrightslp lp_t0_l25 
                   ON item_t0.pk = lp_t0_l25.itempk 
                      AND lp_t0_l25.langpk = 8796095643680 
            LEFT JOIN userrightslp lp_t0_l26 
                   ON item_t0.pk = lp_t0_l26.itempk 
                      AND lp_t0_l26.langpk = 8796098854944 
            LEFT JOIN userrightslp lp_t0_l27 
                   ON item_t0.pk = lp_t0_l27.itempk 
                      AND lp_t0_l27.langpk = 8796095840288 
            LEFT JOIN userrightslp lp_t0_l28 
                   ON item_t0.pk = lp_t0_l28.itempk 
                      AND lp_t0_l28.langpk = 8796093644832 
            LEFT JOIN userrightslp lp_t0_l29 
                   ON item_t0.pk = lp_t0_l29.itempk 
                      AND lp_t0_l29.langpk = 8796093546528 
            LEFT JOIN userrightslp lp_t0_l30 
                   ON item_t0.pk = lp_t0_l30.itempk 
                      AND lp_t0_l30.langpk = 8796093415456 
            LEFT JOIN userrightslp lp_t0_l31 
                   ON item_t0.pk = lp_t0_l31.itempk 
                      AND lp_t0_l31.langpk = 8796096233504 
            LEFT JOIN userrightslp lp_t0_l32 
                   ON item_t0.pk = lp_t0_l32.itempk 
                      AND lp_t0_l32.langpk = 8796095545376 
            LEFT JOIN userrightslp lp_t0_l33 
                   ON item_t0.pk = lp_t0_l33.itempk 
                      AND lp_t0_l33.langpk = 8796095512608 
            LEFT JOIN userrightslp lp_t0_l34 
                   ON item_t0.pk = lp_t0_l34.itempk 
                      AND lp_t0_l34.langpk = 8796093939744 
            LEFT JOIN userrightslp lp_t0_l35 
                   ON item_t0.pk = lp_t0_l35.itempk 
                      AND lp_t0_l35.langpk = 8796095414304 
            LEFT JOIN userrightslp lp_t0_l36 
                   ON item_t0.pk = lp_t0_l36.itempk 
                      AND lp_t0_l36.langpk = 8796093480992 
            LEFT JOIN userrightslp lp_t0_l37 
                   ON item_t0.pk = lp_t0_l37.itempk 
                      AND lp_t0_l37.langpk = 8796094824480 
            LEFT JOIN userrightslp lp_t0_l38 
                   ON item_t0.pk = lp_t0_l38.itempk 
                      AND lp_t0_l38.langpk = 8796099084320 
            LEFT JOIN userrightslp lp_t0_l39 
                   ON item_t0.pk = lp_t0_l39.itempk 
                      AND lp_t0_l39.langpk = 8796098920480 
            LEFT JOIN userrightslp lp_t0_l40 
                   ON item_t0.pk = lp_t0_l40.itempk 
                      AND lp_t0_l40.langpk = 8796093284384 
            LEFT JOIN userrightslp lp_t0_l41 
                   ON item_t0.pk = lp_t0_l41.itempk 
                      AND lp_t0_l41.langpk = 8796097544224 
            LEFT JOIN userrightslp lp_t0_l42 
                   ON item_t0.pk = lp_t0_l42.itempk 
                      AND lp_t0_l42.langpk = 8796098068512 
            LEFT JOIN userrightslp lp_t0_l43 
                   ON item_t0.pk = lp_t0_l43.itempk 
                      AND lp_t0_l43.langpk = 8796099379232 
            LEFT JOIN userrightslp lp_t0_l44 
                   ON item_t0.pk = lp_t0_l44.itempk 
                      AND lp_t0_l44.langpk = 8796097609760 
            LEFT JOIN userrightslp lp_t0_l45 
                   ON item_t0.pk = lp_t0_l45.itempk 
                      AND lp_t0_l45.langpk = 8796097249312 
            LEFT JOIN userrightslp lp_t0_l46 
                   ON item_t0.pk = lp_t0_l46.itempk 
                      AND lp_t0_l46.langpk = 8796093186080 
            LEFT JOIN userrightslp lp_t0_l47 
                   ON item_t0.pk = lp_t0_l47.itempk 
                      AND lp_t0_l47.langpk = 8796094857248 
            LEFT JOIN userrightslp lp_t0_l48 
                   ON item_t0.pk = lp_t0_l48.itempk 
                      AND lp_t0_l48.langpk = 8796095217696 
     WHERE  ( item_t0.typepkstring IN ( 8796134375506 ) 
              AND ( item_t0.pk IN ( 8796093055005, 8796093087773, 8796093120541, 8796093153309, 8796093186077 ) ) )
            AND ( item_t0.typepkstring = 8796134375506 ) 
     ORDER  BY item_t0.createdts ASC, 
               item_t0.pk ASC 
    
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 11, 2016 at 03:20 AM

    The status of this issue can be checked here: https://jira.hybris.com/browse/ECP-959

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.