Lifestyle | Philstar.com
A portal of daily newspapers covering Philippine news headlines, business, lifestyle, advertisement, sports and entertainment. Also delivers Manila and Cebu news.
- Philstar.com
- The Philippine Star
- Pilipino Star Ngayon
- The Freeman
- Pang-Masa
- Banat
- Interaksyon
SUPPORT PHILSTAR
About Us |
Contact Us |
Advertise |
Privacy Policy |
Member Agreement |
Copyright Notice
Copyright © 2024. Philstar Global Corp. All Rights Reserved
-
nav
lifestyle==
HOME - HEADLINES
- OPINION
- NATION
- WORLD
- BUSINESS
- SPORTS
- ENTERTAINMENT
- LIFESTYLE
- OTHER SECTIONS
X
Array ( [0] => Array ( [id] => 375 [tag] => PINOY POP [url] => https://www.philstar.com/tags/pinoy-pop ) [1] => Array ( [id] => 366 [tag] => MISS UNIVERSE PHILIPPINES 2024 [url] => https://www.philstar.com/tags/miss-universe-philippines-2024 ) [2] => Array ( [id] => 350 [tag] => EVENTS AND HAPPENINGS [url] => https://www.philstar.com/tags/events-and-happenings ) [3] => Array ( [id] => 57 [tag] => ARTS AND CULTURE [url] => /lifestyle/arts-and-culture ) [4] => Array ( [id] => 270 [tag] => THE BUDGETARIAN [url] => /lifestyle/the-budgetarian ) [5] => Array ( [id] => 58 [tag] => BUSINESS LIFE [url] => /lifestyle/business-life ) [6] => Array ( [id] => 60 [tag] => FASHION AND BEAUTY [url] => /lifestyle/fashion-and-beauty ) [7] => Array ( [id] => 46 [tag] => FOOD [url] => /lifestyle/food-and-leisure ) [8] => Array ( [id] => 59 [tag] => HEALTH AND FAMILY [url] => /lifestyle/health-and-family ) [9] => Array ( [id] => 64 [tag] => ON THE RADAR [url] => /lifestyle/on-the-radar ) [10] => Array ( [id] => 67 [tag] => PETS [url] => /lifestyle/pet-life ) [11] => Array ( [id] => 47 [tag] => TRAVEL [url] => /lifestyle/travel-and-tourism ) [12] => Array ( [id] => 66 [tag] => SHOPPING [url] => /lifestyle/shopping-guide ) [13] => Array ( [id] => 61 [tag] => MODERN LIVING [url] => /lifestyle/modern-living ) [14] => Array ( [id] => 63 [tag] => GADGETS [url] => /lifestyle/gadgets ) )
Array ( [total] => 12 [items] => Array ( [0] => Array ( [SectionID] => 3 [SectionName] => Arts and Culture [SectionUrl] => arts-and-culture ) [1] => Array ( [SectionID] => 110001 [SectionName] => The Budgetarian [SectionUrl] => the-budgetarian ) [2] => Array ( [SectionID] => 6 [SectionName] => Lifestyle Business [SectionUrl] => business-life ) [3] => Array ( [SectionID] => 7 [SectionName] => Fashion and Beauty [SectionUrl] => fashion-and-beauty ) [4] => Array ( [SectionID] => 5 [SectionName] => Food and Leisure [SectionUrl] => food-and-leisure ) [5] => Array ( [SectionID] => 4 [SectionName] => Health And Family [SectionUrl] => health-and-family ) [6] => Array ( [SectionID] => 19 [SectionName] => On the Radar [SectionUrl] => on-the-radar ) [7] => Array ( [SectionID] => 13 [SectionName] => Pet Life [SectionUrl] => pet-life ) [8] => Array ( [SectionID] => 11 [SectionName] => Travel and Tourism [SectionUrl] => travel-and-tourism ) [9] => Array ( [SectionID] => 18 [SectionName] => Shopping Guide [SectionUrl] => shopping-guide ) [10] => Array ( [SectionID] => 9 [SectionName] => Modern Living [SectionUrl] => modern-living ) [11] => Array ( [SectionID] => 15 [SectionName] => Gadgets [SectionUrl] => gadgets ) ) )
top_news
Array ( [0] => Array ( [ArticleID] => 2374965 [Title] => Recipe: Moist, velvety Chocolate Cake [PostType] => Standard [Summary] => [Thumbnail] => https://media.philstar.com/photos/2024/08/02/chocolate-velvet_2024-08-02_18-12-39585_thumbnail.jpg [Orig] => https://media.philstar.com/photos/2024/08/02/chocolate-velvet_2024-08-02_18-12-39585.jpg [Tiny] => https://media.philstar.com/photos/2024/08/02/chocolate-velvet_2024-08-02_18-12-39585_tn.jpg [Alt] => [Link] => https://www.philstar.com/lifestyle/food-and-leisure/2024/10/06/2374965/recipe-moist-velvety-chocolate-cake ) [1] => Array ( [ArticleID] => 2390549 [Title] => 'Starstruck' alum, transman Jesi Corcuera pregnant with 1st child [PostType] => Standard [Summary] => [Thumbnail] => https://media.philstar.com/photos/2024/10/06/jesi-corcuera-ig_2024-10-06_12-25-37992_thumbnail.jpg [Orig] => https://media.philstar.com/photos/2024/10/06/jesi-corcuera-ig_2024-10-06_12-25-37992.jpg [Tiny] => https://media.philstar.com/photos/2024/10/06/jesi-corcuera-ig_2024-10-06_12-25-37992_tn.jpg [Alt] => [Link] => https://www.philstar.com/lifestyle/health-and-family/2024/10/06/2390549/starstruck-alum-transman-jesi-corcuera-pregnant-1st-child ) [2] => Array ( [ArticleID] => 2389474 [Title] => Recipe: Sinigang na Mackerel [PostType] => Standard [Summary] => [Thumbnail] => https://media.philstar.com/photos/2024/10/01/1_2024-10-01_22-06-34619_thumbnail.jpg [Orig] => https://media.philstar.com/photos/2024/10/01/1_2024-10-01_22-06-34619.jpg [Tiny] => https://media.philstar.com/photos/2024/10/01/1_2024-10-01_22-06-34619_tn.jpg [Alt] => [Link] => https://www.philstar.com/lifestyle/food-and-leisure/2024/10/06/2389474/recipe-sinigang-na-mackerel ) [3] => Array ( [ArticleID] => 2386204 [Title] => UNICEF's 2024 Christmas cards feature 4 Manuel Baldemor artworks [PostType] => Standard [Summary] => [Thumbnail] => https://media.philstar.com/photos/2024/09/18/christmas-cards_2024-09-18_16-39-06392_thumbnail.jpg [Orig] => https://media.philstar.com/photos/2024/09/18/christmas-cards_2024-09-18_16-39-06392.jpg [Tiny] => https://media.philstar.com/photos/2024/09/18/christmas-cards_2024-09-18_16-39-06392_tn.jpg [Alt] => [Link] => https://www.philstar.com/lifestyle/arts-and-culture/2024/10/06/2386204/unicefs-2024-christmas-cards-feature-4-manuel-baldemor-artworks ) )
What is OTOP? Davao chocolates, Salted Turmeric Egg featured at Makati fair
OTOP was a movement that started in the Oita Prefecture in Japan, and was adapted by many markets, including the Philippines.
q1 - SELECT ar.ArticleID, ar.Title, ar.DatePublished, se.SectionUrl, im.Alt, im.URL, ar.PostType, (Views + Comments + Shares) as pop FROM ArticlesRevised AS ar LEFT JOIN Images AS im ON ( ar.ArticleID = im.ArticleID AND im.ImageType = 'Thumbnail' ) LEFT JOIN ArticleStats as st on (ar.ArticleID = st.ArticleID) LEFT JOIN Articles_to_Sections as asec on (ar.ArticleID = asec.ArticleID) LEFT JOIN Sections as se on (asec.SectionID = se.SectionID) LEFT JOIN PriorityBypass as pb on (pb.ArticleID = ar.ArticleID AND pb.Section = 'Trending' AND pb.DateEnd > '2024-10-07') WHERE pb.Section is not null AND ar.Status = 'Approved' AND ar.PublicationID = :pid AND (asec.SectionID in (select SectionID from Sections where SectionID = 16 or Parent = 16)) AND pb.Weight is not null AND asec.Position = 1 ORDER BY pb.Weight DESC, pop DESC LIMIT 0, 4
Array ( [:pid] => 1 )
bakit wala
q2 - SELECT tr.Position, ar.ArticleID, ar.Title, ar.DatePublished, se.SectionUrl, im.Alt, im.URL, ar.PostType FROM ArticlesRevised AS ar LEFT JOIN Images AS im ON ( ar.ArticleID = im.ArticleID AND im.ImageType = 'Thumbnail' ) LEFT JOIN Trending as tr on (ar.ArticleID = tr.ArticleID) LEFT JOIN Articles_to_Sections as asec on (ar.ArticleID = asec.ArticleID) LEFT JOIN Sections as se on (asec.SectionID = se.SectionID) WHERE ar.PublicationID = :pid AND (tr.SectionID in (2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,22,43,136,110001)) AND ar.ArticleID not in (0,2390568,2374965,2390549,2389474,2386204) AND asec.Position = 1 ORDER BY tr.Position LIMIT 0, 4
Array ( [:pid] => 1 )
data_lifestyle_trend
Array ( [total] => 4 [items] => Array ( [0] => Array ( [Position] => 2 [ArticleID] => 2389624 [Title] => EU, ASEAN discuss efforts to boost investments and businesses’ participation in the green transition [DatePublished] => 2024-10-04 08:00:00 [SectionUrl] => on-the-radar [Alt] => [URL] => https://media.philstar.com/photos/2024/10/02/lead_2024-10-02_14-36-4185_thumbnail.jpg [PostType] => Sponsored ) [1] => Array ( [Position] => 48 [ArticleID] => 2390346 [Title] => Memes: Head-scratchers for Boomers and Gen Xers? [DatePublished] => 2024-10-05 00:00:00 [SectionUrl] => lifestyle [Alt] => [URL] => https://media.philstar.com/photos/2024/10/05/pahabol_2024-10-05_13-45-19328_thumbnail.jpg [PostType] => Standard ) [2] => Array ( [Position] => 97 [ArticleID] => 2389865 [Title] => Globally-renowned streetwear brand with Pinoy roots opens first store in the Philippines [DatePublished] => 2024-10-04 08:14:00 [SectionUrl] => fashion-and-beauty [Alt] => [URL] => https://media.philstar.com/photos/2024/10/03/ilest_2024-10-03_12-06-17636_thumbnail.jpg [PostType] => Standard ) [3] => Array ( [Position] => 117 [ArticleID] => 2390523 [Title] => Filipina-Kiwi Franki Russell wins Best National Costume at Miss Cosmo 2024 [DatePublished] => 2024-10-05 23:10:00 [SectionUrl] => fashion-and-beauty [Alt] => [URL] => https://media.philstar.com/photos/2024/10/05/franki-russell-best-natl-costume-miss-cosmo-2024-fr-ig_2024-10-05_22-59-15315_thumbnail.jpg [PostType] => Standard ) ) )
trend_index_new
Array ( [0] => Array ( [ArticleID] => 2389624 [Title] => EU, ASEAN discuss efforts to boost investments and businesses’ participation in the green transition [PostType] => Sponsored [Summary] => [Thumbnail] => https://media.philstar.com/photos/2024/10/02/lead_2024-10-02_14-36-4185_thumbnail.jpg [Orig] => https://media.philstar.com/photos/2024/10/02/lead_2024-10-02_14-36-4185.jpg [Tiny] => https://media.philstar.com/photos/2024/10/02/lead_2024-10-02_14-36-4185_tn.jpg [Alt] => [Link] => https://www.philstar.com/lifestyle/on-the-radar/2024/10/04/2389624/eu-asean-discuss-efforts-boost-investments-and-businesses-participation-green-transition ) [1] => Array ( [ArticleID] => 2390346 [Title] => Memes: Head-scratchers for Boomers and Gen Xers? [PostType] => Standard [Summary] => [Thumbnail] => https://media.philstar.com/photos/2024/10/05/pahabol_2024-10-05_13-45-19328_thumbnail.jpg [Orig] => https://media.philstar.com/photos/2024/10/05/pahabol_2024-10-05_13-45-19328.jpg [Tiny] => https://media.philstar.com/photos/2024/10/05/pahabol_2024-10-05_13-45-19328_tn.jpg [Alt] => [Link] => https://www.philstar.com/lifestyle/2024/10/05/2390346/memes-head-scratchers-boomers-and-gen-xers ) [2] => Array ( [ArticleID] => 2389865 [Title] => Globally-renowned streetwear brand with Pinoy roots opens first store in the Philippines [PostType] => Standard [Summary] => [Thumbnail] => https://media.philstar.com/photos/2024/10/03/ilest_2024-10-03_12-06-17636_thumbnail.jpg [Orig] => https://media.philstar.com/photos/2024/10/03/ilest_2024-10-03_12-06-17636.jpg [Tiny] => https://media.philstar.com/photos/2024/10/03/ilest_2024-10-03_12-06-17636_tn.jpg [Alt] => [Link] => https://www.philstar.com/lifestyle/fashion-and-beauty/2024/10/04/2389865/globally-renowned-streetwear-brand-pinoy-roots-opens-first-store-philippines ) [3] => Array ( [ArticleID] => 2390523 [Title] => Filipina-Kiwi Franki Russell wins Best National Costume at Miss Cosmo 2024 [PostType] => Standard [Summary] => [Thumbnail] => https://media.philstar.com/photos/2024/10/05/franki-russell-best-natl-costume-miss-cosmo-2024-fr-ig_2024-10-05_22-59-15315_thumbnail.jpg [Orig] => https://media.philstar.com/photos/2024/10/05/franki-russell-best-natl-costume-miss-cosmo-2024-fr-ig_2024-10-05_22-59-15315.jpg [Tiny] => https://media.philstar.com/photos/2024/10/05/franki-russell-best-natl-costume-miss-cosmo-2024-fr-ig_2024-10-05_22-59-15315_tn.jpg [Alt] => [Link] => https://www.philstar.com/lifestyle/fashion-and-beauty/2024/10/05/2390523/filipina-kiwi-franki-russell-wins-best-national-costume-miss-cosmo-2024 ) )