"select *from google_ecommerce_keywords where is_footer=1"
"SELECT id,title,title_uniq,summary,head_image,published_at FROM `articles` where state = 1 order by published_at desc limit 3"
"""
select * from(\r\n
SELECT s.*,(ROW_NUMBER() OVER (PARTITION BY s.id)) AS row_num  FROM (\r\n
SELECT  DISTINCT a.id,a.keyword,a.keyword_uniq,c.`name`,c.name_uniq,c.head_img,c.price,c.star\r\n
FROM `google_ecommerce_keywords` a\r\n
join google_ecommerce_keyword_brand_items b on b.keyword_id = a.id \r\n
join google_ecommerce_items c on b.item_id= c.id\r\n
where a.is_home = 1 \r\n
) s ) t WHERE row_num<=4
"""
[Official] Online Jewelry Provider - JewelryOnLight