BMS Megapolis - Aukcionai

 
 SELECT 
      id
 FROM 
      isparduotuve_structure
 WHERE 
      shortcut = 'catalog' AND
      lang = 'lt' 

 SELECT 
      COUNT(isparduotuve_product.id) AS count
 FROM 
      isparduotuve_product LEFT JOIN
      kain_prekes ON kain_prekes.SkuId  =  isparduotuve_product.sku_id LEFT JOIN
      kain_lygis3 ON kain_lygis3.id  =  kain_prekes.Pogrupis LEFT JOIN
      kain_lygis2 ON kain_lygis2.id  =  kain_lygis3.lygis2_id LEFT JOIN
      kain_lygis1 ON kain_lygis1.id  =  kain_lygis2.lygis1_id
 WHERE 
      kain_lygis1.id  =  10 AND
      isparduotuve_product.section = 'started' AND
      isparduotuve_product.start_date < NOW() AND
      isparduotuve_product.finish_date > NOW()

 SELECT 
      COUNT(isparduotuve_product.id) AS count
 FROM 
      isparduotuve_product LEFT JOIN
      kain_prekes ON kain_prekes.SkuId  =  isparduotuve_product.sku_id LEFT JOIN
      kain_lygis3 ON kain_lygis3.id  =  kain_prekes.Pogrupis LEFT JOIN
      kain_lygis2 ON kain_lygis2.id  =  kain_lygis3.lygis2_id LEFT JOIN
      kain_lygis1 ON kain_lygis1.id  =  kain_lygis2.lygis1_id
 WHERE 
      kain_lygis1.id  =  1 AND
      isparduotuve_product.section = 'started' AND
      isparduotuve_product.start_date < NOW() AND
      isparduotuve_product.finish_date > NOW()

 SELECT 
      COUNT(isparduotuve_product.id) AS count
 FROM 
      isparduotuve_product LEFT JOIN
      kain_prekes ON kain_prekes.SkuId  =  isparduotuve_product.sku_id LEFT JOIN
      kain_lygis3 ON kain_lygis3.id  =  kain_prekes.Pogrupis LEFT JOIN
      kain_lygis2 ON kain_lygis2.id  =  kain_lygis3.lygis2_id LEFT JOIN
      kain_lygis1 ON kain_lygis1.id  =  kain_lygis2.lygis1_id
 WHERE 
      kain_lygis1.id  =  2 AND
      isparduotuve_product.section = 'started' AND
      isparduotuve_product.start_date < NOW() AND
      isparduotuve_product.finish_date > NOW()

 SELECT 
      COUNT(isparduotuve_product.id) AS count
 FROM 
      isparduotuve_product LEFT JOIN
      kain_prekes ON kain_prekes.SkuId  =  isparduotuve_product.sku_id LEFT JOIN
      kain_lygis3 ON kain_lygis3.id  =  kain_prekes.Pogrupis LEFT JOIN
      kain_lygis2 ON kain_lygis2.id  =  kain_lygis3.lygis2_id LEFT JOIN
      kain_lygis1 ON kain_lygis1.id  =  kain_lygis2.lygis1_id
 WHERE 
      kain_lygis1.id  =  3 AND
      isparduotuve_product.section = 'started' AND
      isparduotuve_product.start_date < NOW() AND
      isparduotuve_product.finish_date > NOW()

 SELECT 
      COUNT(isparduotuve_product.id) AS count
 FROM 
      isparduotuve_product LEFT JOIN
      kain_prekes ON kain_prekes.SkuId  =  isparduotuve_product.sku_id LEFT JOIN
      kain_lygis3 ON kain_lygis3.id  =  kain_prekes.Pogrupis LEFT JOIN
      kain_lygis2 ON kain_lygis2.id  =  kain_lygis3.lygis2_id LEFT JOIN
      kain_lygis1 ON kain_lygis1.id  =  kain_lygis2.lygis1_id
 WHERE 
      kain_lygis1.id  =  4 AND
      isparduotuve_product.section = 'started' AND
      isparduotuve_product.start_date < NOW() AND
      isparduotuve_product.finish_date > NOW()

 SELECT 
      COUNT(isparduotuve_product.id) AS count
 FROM 
      isparduotuve_product LEFT JOIN
      kain_prekes ON kain_prekes.SkuId  =  isparduotuve_product.sku_id LEFT JOIN
      kain_lygis3 ON kain_lygis3.id  =  kain_prekes.Pogrupis LEFT JOIN
      kain_lygis2 ON kain_lygis2.id  =  kain_lygis3.lygis2_id LEFT JOIN
      kain_lygis1 ON kain_lygis1.id  =  kain_lygis2.lygis1_id
 WHERE 
      kain_lygis1.id  =  5 AND
      isparduotuve_product.section = 'started' AND
      isparduotuve_product.start_date < NOW() AND
      isparduotuve_product.finish_date > NOW()

 SELECT 
      COUNT(isparduotuve_product.id) AS count
 FROM 
      isparduotuve_product LEFT JOIN
      kain_prekes ON kain_prekes.SkuId  =  isparduotuve_product.sku_id LEFT JOIN
      kain_lygis3 ON kain_lygis3.id  =  kain_prekes.Pogrupis LEFT JOIN
      kain_lygis2 ON kain_lygis2.id  =  kain_lygis3.lygis2_id LEFT JOIN
      kain_lygis1 ON kain_lygis1.id  =  kain_lygis2.lygis1_id
 WHERE 
      kain_lygis1.id  =  6 AND
      isparduotuve_product.section = 'started' AND
      isparduotuve_product.start_date < NOW() AND
      isparduotuve_product.finish_date > NOW()

 SELECT 
      COUNT(isparduotuve_product.id) AS count
 FROM 
      isparduotuve_product LEFT JOIN
      kain_prekes ON kain_prekes.SkuId  =  isparduotuve_product.sku_id LEFT JOIN
      kain_lygis3 ON kain_lygis3.id  =  kain_prekes.Pogrupis LEFT JOIN
      kain_lygis2 ON kain_lygis2.id  =  kain_lygis3.lygis2_id LEFT JOIN
      kain_lygis1 ON kain_lygis1.id  =  kain_lygis2.lygis1_id
 WHERE 
      kain_lygis1.id  =  7 AND
      isparduotuve_product.section = 'started' AND
      isparduotuve_product.start_date < NOW() AND
      isparduotuve_product.finish_date > NOW()

 SELECT 
      COUNT(isparduotuve_product.id) AS count
 FROM 
      isparduotuve_product LEFT JOIN
      kain_prekes ON kain_prekes.SkuId  =  isparduotuve_product.sku_id LEFT JOIN
      kain_lygis3 ON kain_lygis3.id  =  kain_prekes.Pogrupis LEFT JOIN
      kain_lygis2 ON kain_lygis2.id  =  kain_lygis3.lygis2_id LEFT JOIN
      kain_lygis1 ON kain_lygis1.id  =  kain_lygis2.lygis1_id
 WHERE 
      kain_lygis1.id  =  8 AND
      isparduotuve_product.section = 'started' AND
      isparduotuve_product.start_date < NOW() AND
      isparduotuve_product.finish_date > NOW()

 SELECT 
      COUNT(isparduotuve_product.id) AS count
 FROM 
      isparduotuve_product LEFT JOIN
      kain_prekes ON kain_prekes.SkuId  =  isparduotuve_product.sku_id LEFT JOIN
      kain_lygis3 ON kain_lygis3.id  =  kain_prekes.Pogrupis LEFT JOIN
      kain_lygis2 ON kain_lygis2.id  =  kain_lygis3.lygis2_id LEFT JOIN
      kain_lygis1 ON kain_lygis1.id  =  kain_lygis2.lygis1_id
 WHERE 
      kain_lygis1.id  =  9 AND
      isparduotuve_product.section = 'started' AND
      isparduotuve_product.start_date < NOW() AND
      isparduotuve_product.finish_date > NOW()

 
 SELECT 
      COUNT(auctions.id)
 FROM 
      isparduotuve_view_get_auctions AS auctions
 WHERE 
      auctions.group_id IS NULL AND
      auctions.start_date < NOW() AND
      auctions.finish_date > NOW() AND
      auctions.auction_section  =  'started' 

 SELECT 
      *
 FROM 
      isparduotuve_banners
 WHERE 
      visible  =  1 AND
      type ! =  'pattern' AND
      lang  =  'lt' AND
      location  =  1 AND
      (1337272452 BETWEEN show_from AND
      show_to) AND
      IF(shows  =  0,
      1,
      showed < shows ) AND
      IF(clicks  =  0,
      1,
      clicked < clicks )
 ORDER BY 
      pos
 LIMIT 
      0,
      4

 SELECT 
      *
 FROM 
      isparduotuve_banners
 WHERE 
      visible  =  1 AND
      type ! =  'pattern' AND
      lang  =  'lt' AND
      location  =  3 AND
      (1337272452 BETWEEN show_from AND
      show_to) AND
      IF(shows  =  0,
      1,
      showed < shows ) AND
      IF(clicks  =  0,
      1,
      clicked < clicks )
 ORDER BY 
      pos
 LIMIT 
      0,
      1