wat

gistfile1.txt

        SELECT *
          FROM products
         WHERE productId IN (
                SELECT relatedId
                  FROM product_suggestions
                 WHERE productId=?
         )
           AND live=1
           AND archive=0
           AND (
                    countryId=?
                 OR (
                        countryId=?
                    AND productId NOT IN (
                        SELECT productId
                          FROM products
                         WHERE productId IN (
                            SELECT relatedId
                              FROM product_suggestions
                             WHERE productId=?
                         )
                           AND countryId=?
                    )
                 )
           )
           AND productId IN (
                SELECT productId
                  FROM product_colours
                 WHERE productColourId IN (
                    SELECT productColourId
                      FROM price_list_items
                     WHERE priceListId=?
                 )
           )

gistfile2.txt

    SELECT *
      FROM products p
      JOIN product_suggestions sug
        ON sug.relatedId = p.productId
       AND sug.productID = ?
      JOIN product_colours col
        ON col.productId = p.productId
      JOIN price_list_items prices
        ON col.productColourId = prices.productColourId
       AND prices.priceListId = ?
     WHERE p.live = 1
       AND p.archive = 0
       AND ( p.countryId = ?
          OR p.countryId = ? )
  GROUP BY p.productId