SELECT SQL_CALC_FOUND_ROWS BA.ARTICLE_ID,AMOUNT_LAST_UPDATE,STORE_AMOUNT_ALL

  FROM b_articles BA

LEFT JOIN ( SELECT ARTICLE_ID,MAX(AMOUNT_LAST_UPDATE) AMOUNT_LAST_UPDATE,SUM(TBAV.AMOUNT) STORE_AMOUNT_ALL

                FROM b_availability TBAV

                WHERE TBAV.BARSY_ID IN (1,194,314,134,376,164,346,284,361,344,224,254,391)

               GROUP BY TBAV.ARTICLE_ID

            ) BAV USING (ARTICLE_ID)

WHERE

BA.PARENT_ID IS NULL 

AND BA.PICTURE IS NOT NULL 

AND BA.ARTICLE_ID IN ( SELECT DISTINCT ARTICLE_ID FROM b_article_cats ) 

AND BA.ARTICLE_ID IN ( SELECT DISTINCT IBA.ARTICLE_ID

                         FROM b_articles IBA

                        INNER JOIN b_availability IBAV USING (ARTICLE_ID)

                         LEFT JOIN (b_article_details IBAD  

                                   INNER JOIN b_article_detail_key_values IBADKV USING (DETAIL_ID) ) ON IBA.ARTICLE_ID = IBAD.ARTICLE_ID AND IBAD.KEY_ID = -1                                   

                         WHERE (IBADKV.DETAIL_VALUE IS NULL 

                               OR IBADKV.DETAIL_VALUE = "" 

                               OR IBA.LAST_UPDATE > IBADKV.DETAIL_VALUE 

                               OR IBAV.AMOUNT_LAST_UPDATE > IBADKV.DETAIL_VALUE

                              ) 

                          AND IBAV.BARSY_ID IN (1,194,314,134,376,164,346,284,361,344,224,254,391)

                      )