select n.id,n.parents,nl.cate_name,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and n.parent=0 and nl.lang="vn" GROUP BY n.id ORDER BY n.orderby asc limit 0,15select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=173 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=177 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=174 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=176 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=794 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=179 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=178 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1602 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=542 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1686 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=432 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=320 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=848 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1291 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=849 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1650 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=937 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=980 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1236 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=855 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2095 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1623 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1757 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1763 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1668 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1624 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1670 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1056 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1627 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1669 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1755 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2352 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1759 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2099 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1067 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2101 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2087 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2258 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2098 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1677 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1915 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1008 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1005 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1015 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1002 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1695 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2156 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2344 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1696 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1004 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1705 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1706 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2155 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2100 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1999 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1294 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1012 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1678 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2527 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2407 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=828 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2160 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2216 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1787 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1735 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2281 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1024 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2218 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2042 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1733 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2210 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2243 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1028 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=480 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2473 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=408 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2037 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2386 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1742 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2141 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2038 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2027 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2115 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2114 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=489 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=791 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=169 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=761 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2123 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=785 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1035 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2119 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1086 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=790 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1680 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1306 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1307 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1322 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1308 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1304 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1309 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1556 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1565 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1310 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=171 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=184 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=595 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1095 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=185 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=596 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1097 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=186 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=951 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1235 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=170 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2526 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=805 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=693 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2044 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2045 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1117 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1144 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1145 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1420 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1884 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1266 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1621 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2002 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2005 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2117 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1162 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2015 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2062 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1993 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1994 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=811 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=700 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1324 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1350 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2070 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2423 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1516 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1616 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1837 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=470 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1894 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1473 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1263 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1264 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1895 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1457 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1953 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1839 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2105 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2019 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1681 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1293 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1313 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1314 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1405 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1407 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1315 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1312 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=997 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1410 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1397 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1398 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=998 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.parent=0 and nl.lang="vn" GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and nl.lang="vn" and n.parent=173 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=177 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=174 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=176 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=794 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=179 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=178 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1602 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=542 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1686 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=432 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=320 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and nl.lang="vn" and n.parent=848 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1291 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=849 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1650 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=937 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=980 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1236 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=855 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and nl.lang="vn" and n.parent=2095 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1623 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1757 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1763 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1668 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1624 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1670 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1056 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1627 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1669 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1755 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2352 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1759 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2099 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1067 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2101 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2087 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2258 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2098 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and nl.lang="vn" and n.parent=1677 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1915 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1008 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1005 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1015 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1002 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1695 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2156 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2344 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1696 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1004 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1705 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1706 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2155 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2100 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1999 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1294 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1012 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and nl.lang="vn" and n.parent=1678 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2527 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2407 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=828 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2160 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2216 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1787 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1735 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2281 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1024 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2218 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2042 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1733 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2210 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2243 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1028 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and nl.lang="vn" and n.parent=480 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2473 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=408 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2037 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2386 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1742 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2141 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2038 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2027 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2115 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2114 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=489 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=791 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and nl.lang="vn" and n.parent=169 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=761 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2123 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=785 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1035 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2119 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1086 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=790 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and nl.lang="vn" and n.parent=1680 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1306 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1307 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1322 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1308 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1304 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1309 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1556 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1565 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1310 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and nl.lang="vn" and n.parent=171 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=184 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=595 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1095 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=185 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=596 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1097 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=186 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=951 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1235 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and nl.lang="vn" and n.parent=170 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2526 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=805 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=693 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2044 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2045 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1117 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1144 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1145 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1420 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1884 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1266 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1621 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2002 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2005 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2117 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1162 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and nl.lang="vn" and n.parent=2015 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2062 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1993 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1994 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=811 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=700 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1324 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1350 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2070 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2423 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1516 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1616 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1837 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=470 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and nl.lang="vn" and n.parent=1894 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1473 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1263 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1264 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1895 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1457 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1953 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1839 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2105 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2019 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and nl.lang="vn" and n.parent=1681 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1293 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1313 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1314 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1405 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1407 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1315 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1312 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1410 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=997 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1397 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1398 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=998 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and nl.lang="vn" and n.parent=1748 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1664 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1363 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1366 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1749 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=503 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1030 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1750 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1367 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1039 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1793 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1800 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1747 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1921 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1991 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2223 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1791 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1792 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1753 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.brand_thumb,nl.brand_name,nl.brand_slug from `brand` n join brand_lang nl on n.id = nl.brand_id left join product p on p.product_brand = n.id where 1 and nl.lang ="vn" and n.brand_index=1 GROUP BY n.id ORDER BY n.brand_orderby asc limit 0,14select n.id,n.video_name,n.video_thumb,n.video_update from `video` n where 1 and n.video_index=1 and n.video_hide =1 GROUP BY n.id ORDER BY n.id desc limit 0,4select n.id,n.catalog_name,n.catalog_thumb,n.catalog_file,n.catalog_update from `catalog` n where 1 and n.catalog_index=1 and n.catalog_hide =1 GROUP BY n.id ORDER BY n.id desc limit 0,4select n.id,nl.cate_name,n.cate_hide,n.orderby from `cate_news` n join news_cate_lang nl on n.id = nl.cate_id where 1 and n.parent=0 and n.type=1 and nl.lang="vn" GROUP BY n.id ORDER BY n.cate_hide desc,n.orderby asc limit 0,10select n.id,nl.cate_name,n.cate_hide,n.orderby from `cate_news` n join news_cate_lang nl on n.id = nl.cate_id where 1 and n.parent=0 and n.type=2 and nl.lang="vn" GROUP BY n.id ORDER BY n.cate_hide desc,n.orderby asc limit 0,1select n.id,nl.news_name,n.news_status from `news` n join news_lang nl on n.id = nl.news_id where 1 and n.news_hide=1 and n.parent=1 and nl.lang="vn" GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.news_name,n.news_status from `news` n join news_lang nl on n.id = nl.news_id where 1 and n.news_hide=1 and n.parent=2 and nl.lang="vn" GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.news_name,n.news_status from `news` n join news_lang nl on n.id = nl.news_id where 1 and n.news_hide=1 and n.parent=3 and nl.lang="vn" GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.news_name,n.news_status from `news` n join news_lang nl on n.id = nl.news_id where 1 and n.news_hide=1 and n.parent=4 and nl.lang="vn" GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,nl.cate_slug from `cate_news` n join news_cate_lang nl on n.id = nl.cate_id where 1 and n.parent=0 and n.type=3 and nl.lang="vn" GROUP BY n.id ORDER BY n.cate_hide desc,n.orderby asc limit 0,1select n.id,nl.news_name,n.news_status from `news` n join news_lang nl on n.id = nl.news_id where 1 and n.news_hide=1 and n.parent=6 and nl.lang="vn" GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.cate_hide,n.orderby from `cate_news` n join news_cate_lang nl on n.id = nl.cate_id where 1 and n.parent=0 and n.type=4 and nl.lang="vn" GROUP BY n.id ORDER BY n.cate_hide desc , n.orderby asc limit 0,1select n.id,nl.news_name,n.news_thumb,n.news_status,n.news_create,n.news_update from `news` n join news_lang nl on n.id = nl.news_id where 1 and n.news_index=1 and n.news_hide=1 and n.parent=7 and nl.lang="vn" GROUP BY n.id ORDER BY n.orderby asc,n.id desc limit 0,4select n.id,n.news_name,n.news_thumb,n.news_update from `news1` n where 1 and n.news_event_index=1 and n.news_hide=1 GROUP BY n.id ORDER BY n.id desc limit 0,4select n.id,n.cate_name,n.cate_hide,n.orderby from `cate_news1` n where 1 and n.cate_hide=1 GROUP BY n.id ORDER BY n.orderby asc,n.id desc select n.id,nl.name,nl.link,n.orderby from `link` n join link_lang nl on n.id = nl.link_id where 1 and nl.lang="vn" and n.parent=0 and n.link_hide=1 GROUP BY n.id ORDER BY n.orderby asc select k.NguoiLienHe from `tbl_user` n left join customer_detail_online k on k.ID_User = n.id where 1 and k.ID_User="" GROUP BY n.id ORDER BY k.ID desc select n.id as id_select,n.product_ship,n.product_view,n.product_thumbs,n.product_cate,n.product_video,n.product_video2,n.product_video3,n.product_title_video,n.product_title_video2,n.product_title_video3,n.product_view_video,n.product_view_video2,n.product_view_video3,n.product_file,n.product_file_manual,n.product_title_catalogue,n.product_title_manual,n.product_down_catalogue,n.product_down_manual,n.product_price_goc,n.product_price,n.product_promotion,n.product_negotiate,n.product_limit,n.product_price_liquidation,n.product_price_partner,n.product_price_nhanvien,n.product_price_trade,n.product_price_friend,n.product_price_special,n.product_code,bl.brand_name,bl.brand_name1,bl.brand_name2,nl.*,n.product_create,n.product_update,n.product_date_price,m.name,n.product_weight,n.product_status,n.product_name_bill,n.product_linkreplace,n.product_model1,n.product_model2,n.product_model3,n.product_related,n.product_seri_type,n.product_type_shipper,n.product_date_shipper_other,n.product_radio_checked from `product` n inner join product_lang nl on n.id = nl.product_id left join brand_lang bl on nl.product_brand = bl.id left join member m on n.product_user_update = m.id where 1 and n.id=565 and nl.lang="vn" GROUP BY n.id ORDER BY n.product_index desc,n.product_orderby asc,n.id desc limit 0,1select n.id as id_select,n.product_ship,n.product_view,n.product_thumbs,n.product_cate,n.product_video,n.product_video2,n.product_video3,n.product_title_video,n.product_title_video2,n.product_title_video3,n.product_view_video,n.product_view_video2,n.product_view_video3,n.product_file,n.product_file_manual,n.product_title_catalogue,n.product_title_manual,n.product_down_catalogue,n.product_down_manual,n.product_price_goc,n.product_price,n.product_promotion,n.product_negotiate,n.product_limit,n.product_price_liquidation,n.product_price_partner,n.product_price_nhanvien,n.product_price_trade,n.product_price_friend,n.product_price_special,n.product_code,bl.brand_name,bl.brand_name1,bl.brand_name2,nl.*,n.product_create,n.product_update,n.product_date_price,m.name,n.product_weight,n.product_status,n.product_name_bill,n.product_linkreplace,n.product_model1,n.product_model2,n.product_model3,n.product_related,n.product_seri_type,n.product_type_shipper,n.product_date_shipper_other,n.product_radio_checked from `product` n inner join product_lang nl on n.id = nl.product_id left join brand_lang bl on nl.product_brand = bl.id left join member m on n.product_user_update = m.id where 1 and n.id=565 and nl.lang="en" GROUP BY n.id ORDER BY n.product_index desc,n.product_orderby asc,n.id desc limit 0,1select n.ID_DH ,sum(n.SL) as luotmua from `tbl_donhang` n left join tbl_giaodich0 nl ON nl.ID_DonHang = n.ID_BG where 1 and nl.TrangThai = 4 and n.ID_DH=565 and n.ID_BG != 0 and n.Buoc >= 7 GROUP BY n.id select n.order_product, sum(n.order_number) as bbgh from `detail_order` n join order_user o ON n.order_id = o.id where 1 and n.order_product=565 and o.order_trangthai = 2 GROUP BY n.id select sum(n.SL) as baogia from `tbl_donhang` n left join tbl_giaodich0 nl ON nl.ID_DonHang = n.ID_BG where 1 and n.ID_DH=565 and n.ID_BG != 0 GROUP BY n.id select sum(n.order_number) as luotmuacu from `detail_order_qldh` n where 1 and n.id_product=565 GROUP BY n.id select n.* from `catalog` n where 1 and n.catalog_hide=1 and n.catalog_cate IN(565) GROUP BY n.id ORDER BY n.id desc select n.* from `video` n where 1 and n.video_hide=1 and n.video_cate IN(565) GROUP BY n.id ORDER BY n.id desc select n.id,nl.news_name from `news` n left join news_lang nl on n.id = nl.news_id left join cate_news c on n.parent = c.id where 1 and c.type=4 and nl.lang="vn" and n.news_cate =173 GROUP BY n.id ORDER BY n.news_hide desc,c.type asc,n.parent asc,n.orderby asc limit 0,6select n.id,nl.cate_name,nl.cate_slug,n.parent,n.parents,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.id=2531 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,nl.cate_slug,n.parent,n.parents,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2531 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.news_name,n.news_thumb,n.news_update from `news1` n where 1 and n.news_hide=1 and n.news_cate LIKE "%173%" GROUP BY n.id ORDER BY n.id desc limit 0,20select n.id,n.news_name,n.news_thumb,n.news_update from `news1` n where 1 and n.news_hide=1 and n.news_product LIKE "%565%" GROUP BY n.id ORDER BY n.id desc limit 0,20select n.* from `service_related` n join product p on p.id=n.product_id where 1 and n.service_hide=1 and n.product_id LIKE CONCAT('%',565,'%') GROUP BY n.id ORDER BY n.id desc select n.id,n.product_ship,nl.product_unit,nl.product_thumb,n.product_code,n.product_model1,n.product_model2,n.product_model3,n.product_price,nl.product_name,n.product_code,bl.brand_name,nl.product_date_shipper from `product` n join product_lang nl on n.id = nl.product_id left join brand_lang bl on nl.product_brand = bl.id where 1 and n.product_vn=1 and n.product_hide =1 and nl.lang ="vn" and n.product_cate IN(2533) and n.id!=565 GROUP BY n.id ORDER BY n.product_index desc,n.product_orderby asc,n.id desc limit 30,10select sum(n.instock_num) as coun from `instock` n where 1 and n.product_id="565" and n.instock_status="1" GROUP BY n.instock_status select sum(n.instock_num) as coun from `instock` n where 1 and n.product_id="565" and n.instock_status="2" and n.instock_order_type="2" GROUP BY n.instock_status select sum(n.instock_num) as coun from `instock` n where 1 and n.product_id="565" and n.instock_status="2" and n.instock_order_type="3" GROUP BY n.instock_status select sum(n.instock_num) as coun from `instock` n where 1 and n.product_id="565" and n.instock_status="2" and n.instock_order_type="5" GROUP BY n.instock_status select sum(n.instock_num) as coun from `instock` n where 1 and n.product_id="565" and n.instock_status="2" and n.instock_order = 0 GROUP BY n.instock_status select sum(n.instock_num)as tong,kho.instock_name as kho_hang,ke.instock_name as ke_hang from `instock` n join product p on p.id=n.product_id left join instock_info kho on kho.id=n.instock_info left join instock_info ke on ke.id=n.instock_ke where 1 and p.id=565 GROUP BY n.instock_ke select n.id,n.provice_name from `provice` n where 1 and n.id>0 GROUP BY n.id ORDER BY n.provice_sort asc select n.*,m.Hinh,m.HoTen as user_reply,m.ChucVu from `comment_news` n left join member_info m on m.id=n.ID_User_Info where 1 and n.comment_hide=1 and n.parent=0 and n.comment_news =565 GROUP BY n.id ORDER BY n.id desc limit 0,40 Thước cặp đồng hồ 0-200mm 142-20 MooreAndWright
Thước cặp đồng hồ 0-200mm  142-20 MooreAndWright Mã đặt hàng:565
Click vào hình lớn để xem ảnh phóng to

Thước cặp đồng hồ 0-200mm 142-20 Mooreandwright

Giá bán:
Thông tin tồn kho:
Liên hệ
Thời gian nhập hàng dự kiến: Liên hệ
Hàng đã qua sử dụng: (0) sản phẩm từ muabanmaycu.com
Dịch vụ liên quan: (0) dịch vụ được tìm thấy
Tên sản phẩm: Thước cặp đồng hồ 0-200mm
Mã sản phẩm ( Model / Code / Part No. ): 142-20
Thương hiệu: Mooreandwright
Đơn vị tính: Cái
0 Khách hàng đã đánh giá về sản phẩm này
0/5
5
0%
4
0%
3
0%
2
0%
1
0%
Hỏi đáp về sản phẩm Thước cặp đồng hồ 0-200mm 142-20 Mooreandwright (0)
(Email và điện thoại sẽ không được hiển thị theo chính sách bảo mật thông tin khách hàng của chúng tôi)