SQL: SELECT id, headline, byline, date, ct.num_comments, summary, photo AS image, photo_index AS image_198,
photo_large AS image_476, headline_url
FROM feature_article AS fa
LEFT JOIN sitellite_user AS su ON su.username = fa.byline
LEFT JOIN comment_thread AS ct ON ct.article_id = fa.id AND ct.section_id = "lifestyle"
WHERE type = "lifestyle"
AND date <= NOW()
AND sitellite_status ="approved"
ORDER BY fa.date DESC, fa.id DESC LIMIT 0, 28
array(28) {
[0]=>
array(10) {
["id"]=>
string(4) "1423"
["headline"]=>
string(27) "DJ Hero: Built From Scratch"
["byline"]=>
string(12) "omar.burgess"
["date"]=>
string(10) "2009-10-12"
["num_comments"]=>
NULL
["summary"]=>
string(120) "Forget a review. DX went behind the scenes with actual deejays and gave developers to see if DJ Hero is worth the money."
["image"]=>
string(42) "/images/features/20091012FDJHERO_55x55.jpg"
["image_198"]=>
string(43) "/images/features/20091012FDJHERO_230x75.jpg"
["image_476"]=>
string(44) "/images/features/20091012FDJHERO_160x240.jpg"
["headline_url"]=>
string(0) ""
}
[1]=>
array(10) {
["id"]=>
string(4) "1418"
["headline"]=>
string(39) "Daryl "Chill" Mitchell: Survival Skills"
["byline"]=>
string(11) "paul.arnold"
["date"]=>
string(10) "2009-09-29"
["num_comments"]=>
NULL
["summary"]=>
string(117) "Star of House Party and Brothers tells DX about childhood friend Rakim, onetime group Groove B Chill, and much more. "
["image"]=>
string(41) "/images/features/20090929FCHILL_55x55.jpg"
["image_198"]=>
string(42) "/images/features/20090929FCHILL_230x75.jpg"
["image_476"]=>
string(43) "/images/features/20090929FCHILL_160x240.jpg"
["headline_url"]=>
string(0) ""
}
[2]=>
array(10) {
["id"]=>
string(4) "1415"
["headline"]=>
string(30) "LaMarr Woodley: Back In Black "
["byline"]=>
string(15) "quiton.hatfield"
["date"]=>
string(10) "2009-09-24"
["num_comments"]=>
NULL
["summary"]=>
string(122) "The NFL sack-man talks about Superbowl rings, his University of Michigan maturation, and the hardest defense in football. "
["image"]=>
string(41) "/images/features/20090924FLAMAR_55x55.jpg"
["image_198"]=>
string(42) "/images/features/20090924FLAMAR_230x75.jpg"
["image_476"]=>
string(43) "/images/features/20090924FLAMAR_160x240.jpg"
["headline_url"]=>
string(0) ""
}
[3]=>
array(10) {
["id"]=>
string(4) "1381"
["headline"]=>
string(34) "Marsha Ambrosius: The Flow Goes On"
["byline"]=>
string(7) "mgoakes"
["date"]=>
string(10) "2009-07-21"
["num_comments"]=>
NULL
["summary"]=>
string(116) "The former Floetry member talks about working with Michael Jackson, her long-awaited debut, and the group's fallout."
["image"]=>
string(40) "/images/features/200907FMARSHA_55x55.jpg"
["image_198"]=>
string(41) "/images/features/200907FMARSHA_230x75.jpg"
["image_476"]=>
string(42) "/images/features/200907FMARSHA_160x240.jpg"
["headline_url"]=>
string(0) ""
}
[4]=>
array(10) {
["id"]=>
string(4) "1375"
["headline"]=>
string(27) "Julia Bond: The Naked Truth"
["byline"]=>
string(10) "jake.paine"
["date"]=>
string(10) "2009-07-15"
["num_comments"]=>
NULL
["summary"]=>
string(137) "The former adult film box-cover queen talks about her deep love of Hip Hop, the parallel hustles, and her own aspirations to kick verses."
["image"]=>
string(39) "/images/features/200907FJULIA_55x55.jpg"
["image_198"]=>
string(40) "/images/features/200907FJULIA_230x75.jpg"
["image_476"]=>
string(41) "/images/features/200907FJULIA_160x240.jpg"
["headline_url"]=>
string(0) ""
}
[5]=>
array(10) {
["id"]=>
string(4) "1367"
["headline"]=>
string(34) "The Kickdrums: The Heart Of It All"
["byline"]=>
string(10) "jake.paine"
["date"]=>
string(10) "2009-06-24"
["num_comments"]=>
NULL
["summary"]=>
string(137) "The Slaughterhouse producers talk about their Ohio and David Axelrod-inspired album, and being dope in two games, like Pee Wee Kirkland. "
["image"]=>
string(43) "/images/features/200906FKICKDRUMS_55x55.jpg"
["image_198"]=>
string(44) "/images/features/200906FKICKDRUMS_230x75.jpg"
["image_476"]=>
string(45) "/images/features/200906FKICKDRUMS_160x240.jpg"
["headline_url"]=>
string(0) ""
}
[6]=>
array(10) {
["id"]=>
string(4) "1358"
["headline"]=>
string(32) "Baron Davis: Balance And Options"
["byline"]=>
string(12) "omar.burgess"
["date"]=>
string(10) "2009-06-17"
["num_comments"]=>
NULL
["summary"]=>
string(133) "Davis explains his transition from blacktop courts to corporate board rooms and how the story of the Bloods and Crips relates to his."
["image"]=>
string(39) "/images/features/200906FBARON_55x55.jpg"
["image_198"]=>
string(40) "/images/features/200906FBARON_230x75.jpg"
["image_476"]=>
string(41) "/images/features/200906FBARON_160x240.jpg"
["headline_url"]=>
string(0) ""
}
[7]=>
array(10) {
["id"]=>
string(4) "1363"
["headline"]=>
string(19) "Cassie: Gossip Girl"
["byline"]=>
string(13) "kathy.iandoli"
["date"]=>
string(10) "2009-06-16"
["num_comments"]=>
NULL
["summary"]=>
string(110) "The Bad Boy princess explains how she treads through the gossip, and if her new album will match the hairdoo. "
["image"]=>
string(40) "/images/features/200906FCASSIE_55x55.jpg"
["image_198"]=>
string(41) "/images/features/200906FCASSIE_230x75.jpg"
["image_476"]=>
string(42) "/images/features/200906FCASSIE_160x240.jpg"
["headline_url"]=>
string(0) ""
}
[8]=>
array(10) {
["id"]=>
string(4) "1350"
["headline"]=>
string(26) "Mike Epps: Release Therapy"
["byline"]=>
string(8) "demarcow"
["date"]=>
string(10) "2009-05-20"
["num_comments"]=>
NULL
["summary"]=>
string(95) "Funnyman talks about Next Day Air, getting his break in the biz, and how acting can be therapy."
["image"]=>
string(42) "/images/features/200905FMIKEEPPS_55x55.jpg"
["image_198"]=>
string(43) "/images/features/200905FMIKEEPSS_230x75.jpg"
["image_476"]=>
string(44) "/images/features/200905FMIKEEPPS_160x240.jpg"
["headline_url"]=>
string(0) ""
}
[9]=>
array(10) {
["id"]=>
string(4) "1345"
["headline"]=>
string(30) "Tiallondra Kemp: Tia Told Me "
["byline"]=>
string(11) "paul.arnold"
["date"]=>
string(10) "2009-05-12"
["num_comments"]=>
NULL
["summary"]=>
string(84) "In this jaw-dropping interview, Rick Ross’ baby’s mother tells all about the Bawse. "
["image"]=>
string(39) "/images/features/20090512FTIA_55x55.jpg"
["image_198"]=>
string(40) "/images/features/200905FTKEMP_230x75.jpg"
["image_476"]=>
string(41) "/images/features/200905FTKEMP_160x240.jpg"
["headline_url"]=>
string(0) ""
}
[10]=>
array(10) {
["id"]=>
string(4) "1329"
["headline"]=>
string(41) "Nicholas Cage: National (Guilty) Pleasure"
["byline"]=>
string(8) "demarcow"
["date"]=>
string(10) "2009-04-09"
["num_comments"]=>
NULL
["summary"]=>
string(84) "Think Sam Jackson is the busiest man in Hollywood? Try keeping up with Nicolas Cage."
["image"]=>
string(38) "/images/features/200904FCAGE_55x55.jpg"
["image_198"]=>
string(39) "/images/features/200904FCAGE_230x75.jpg"
["image_476"]=>
string(40) "/images/features/200904FCAGE_160x240.jpg"
["headline_url"]=>
string(0) ""
}
[11]=>
array(10) {
["id"]=>
string(4) "1307"
["headline"]=>
string(34) "B+: Kicks, Snares And B-Boy Glares"
["byline"]=>
string(10) "jake.paine"
["date"]=>
string(10) "2009-02-11"
["num_comments"]=>
NULL
["summary"]=>
string(125) "With the DVD just out, west coast scholar B+ breaks down Madlib, Cut Chemist, will.i.am, and how they battled for supremacy. "
["image"]=>
string(39) "/images/features/200901FCLASH_55x80.jpg"
["image_198"]=>
string(40) "/images/features/200901FCLASH_230x75.jpg"
["image_476"]=>
string(41) "/images/features/200901FCLASH_160x240.jpg"
["headline_url"]=>
string(0) ""
}
[12]=>
array(10) {
["id"]=>
string(4) "1301"
["headline"]=>
string(24) "Biz Markie: Child's Play"
["byline"]=>
string(6) "aewing"
["date"]=>
string(10) "2009-01-28"
["num_comments"]=>
NULL
["summary"]=>
string(172) "After 20 years in the game, Biz is still going strong. Find out what he thinks of using Hip Hop to teach kids on “Yo Gabba Gabba” and the lost art of playing Pong on Atari."
["image"]=>
string(39) "/images/features/200901FGABBA_55x55.jpg"
["image_198"]=>
string(40) "/images/features/200901FGABBA_230x75.jpg"
["image_476"]=>
string(41) "/images/features/200901FGABBA_160x240.jpg"
["headline_url"]=>
string(0) ""
}
[13]=>
array(10) {
["id"]=>
string(4) "1300"
["headline"]=>
string(20) "R-Truth: Fight Music"
["byline"]=>
string(10) "mjasarevic"
["date"]=>
string(10) "2009-01-27"
["num_comments"]=>
NULL
["summary"]=>
string(164) "The WWE's resident rhymer/wrestler, R-Truth, explains his transition from hanging with Eazy-E and 2Pac to trading blows in the ring and entertaining troops in Iraq."
["image"]=>
string(40) "/images/features/200901FRTRUTH_55x55.jpg"
["image_198"]=>
string(41) "/images/features/200901FRTRUTH_230x75.jpg"
["image_476"]=>
string(45) "/images/features/200901FRTRUTH_160x240[1].jpg"
["headline_url"]=>
string(0) ""
}
[14]=>
array(10) {
["id"]=>
string(4) "1299"
["headline"]=>
string(37) "Porn Week: Diana Devoe - Ladies First"
["byline"]=>
string(9) "aspringer"
["date"]=>
string(10) "2009-01-24"
["num_comments"]=>
NULL
["summary"]=>
string(98) "DX's Porn Week concludes with Diana Devoe, the first black female director in the history of porn."
["image"]=>
string(37) "/images/features/200901FDIV_55x55.jpg"
["image_198"]=>
string(38) "/images/features/200901FDIV_230x75.jpg"
["image_476"]=>
string(39) "/images/features/200901FDIV_160x240.jpg"
["headline_url"]=>
string(0) ""
}
[15]=>
array(10) {
["id"]=>
string(4) "1298"
["headline"]=>
string(45) "Porn Week: D'Evils - Investigating Child Porn"
["byline"]=>
string(9) "aspringer"
["date"]=>
string(10) "2009-01-23"
["num_comments"]=>
NULL
["summary"]=>
string(115) "Part five of our week speaks to attorneys and weighs in the rights of young people and the ever-changing Internet. "
["image"]=>
string(39) "/images/features/200901FCHILD_55x55.jpg"
["image_198"]=>
string(40) "/images/features/200901FCHILD_230x75.jpg"
["image_476"]=>
string(41) "/images/features/200901FCHILD_160x240.jpg"
["headline_url"]=>
string(0) ""
}
[16]=>
array(10) {
["id"]=>
string(4) "1296"
["headline"]=>
string(50) "Porn Week: Stacie Lane & Crystal Clear - Firm Biz "
["byline"]=>
string(9) "aspringer"
["date"]=>
string(10) "2009-01-22"
["num_comments"]=>
NULL
["summary"]=>
string(111) "Two starlets of the porn industry explain challenges faced as a BBW, and how to "grab chicks at a strip club." "
["image"]=>
string(43) "/images/features/200901FSTCY_flashTHUMB.jpg"
["image_198"]=>
string(39) "/images/features/200901FSTCY_230x75.jpg"
["image_476"]=>
string(40) "/images/features/200901FSTCY_160x240.jpg"
["headline_url"]=>
string(0) ""
}
[17]=>
array(10) {
["id"]=>
string(4) "1295"
["headline"]=>
string(32) "Porn Week: What A Vibrant Thing "
["byline"]=>
string(6) "aewing"
["date"]=>
string(10) "2009-01-21"
["num_comments"]=>
NULL
["summary"]=>
string(114) "Part three of our second annual Porn Week, DX was in Vegas at the Adult Entertainment Expo, gandering at gadgets. "
["image"]=>
string(38) "/images/features/200901FDOLL_55x55.jpg"
["image_198"]=>
string(39) "/images/features/200901FDOLL_230x75.jpg"
["image_476"]=>
string(40) "/images/features/200901FDOLL_160x240.jpg"
["headline_url"]=>
string(0) ""
}
[18]=>
array(10) {
["id"]=>
string(4) "1293"
["headline"]=>
string(46) "Porn Week: Is Pornography Degrading To Women? "
["byline"]=>
string(9) "aspringer"
["date"]=>
string(10) "2009-01-20"
["num_comments"]=>
NULL
["summary"]=>
string(128) "In part two of our second-annual Porn Week, DX spoke to Ryder Skye, Madison Scott and the XXX Church with the age-old question. "
["image"]=>
string(38) "/images/features/200901FDGRD_55x55.jpg"
["image_198"]=>
string(39) "/images/features/200901FDGRD_230x75.jpg"
["image_476"]=>
string(40) "/images/features/200901FDGRD_160x240.jpg"
["headline_url"]=>
string(0) ""
}
[19]=>
array(10) {
["id"]=>
string(4) "1292"
["headline"]=>
string(42) "Porn Vs. The Bedroom: Class Is In Session "
["byline"]=>
string(6) "aewing"
["date"]=>
string(10) "2009-01-19"
["num_comments"]=>
NULL
["summary"]=>
string(114) "Adult film legend and educator Nina Hartley and columnist Jamye Waxman tell DX readers the facts and the fiction. "
["image"]=>
string(38) "/images/features/200901FBDRM_55x55.jpg"
["image_198"]=>
string(39) "/images/features/200901FBDRM_230x75.jpg"
["image_476"]=>
string(40) "/images/features/200901FBDRM_160x240.jpg"
["headline_url"]=>
string(0) ""
}
[20]=>
array(10) {
["id"]=>
string(4) "1290"
["headline"]=>
string(29) "Notorious: It Was All A Dream"
["byline"]=>
string(8) "demarcow"
["date"]=>
string(10) "2009-01-16"
["num_comments"]=>
NULL
["summary"]=>
string(103) "A chat with those who brought Notorious, Christopher Wallace’s ashy-to-classy tale, to the big screen. "
["image"]=>
string(37) "/images/features/200901FBIG_55x55.jpg"
["image_198"]=>
string(38) "/images/features/200901FBIG_230x75.jpg"
["image_476"]=>
string(39) "/images/features/200901FBIG_160x240.jpg"
["headline_url"]=>
string(0) ""
}
[21]=>
array(10) {
["id"]=>
string(4) "1289"
["headline"]=>
string(28) "Anthony Hamilton: Soul Food "
["byline"]=>
string(8) "talston "
["date"]=>
string(10) "2009-01-12"
["num_comments"]=>
NULL
["summary"]=>
string(129) "One of Hip Hop's favorite Soul voices explains label patience, life changes, and the recipe to his southern fried musical charm. "
["image"]=>
string(40) "/images/features/200812FANTHAM_55x55.jpg"
["image_198"]=>
string(41) "/images/features/200812FANTHAM_230x75.jpg"
["image_476"]=>
string(42) "/images/features/200812FANTHAM_160x240.jpg"
["headline_url"]=>
string(0) ""
}
[22]=>
array(10) {
["id"]=>
string(4) "1270"
["headline"]=>
string(32) "Saul Williams: Gifted Unlimited "
["byline"]=>
string(10) "mjasarevic"
["date"]=>
string(10) "2008-12-16"
["num_comments"]=>
NULL
["summary"]=>
string(120) "After selling 300,000 units this year, a film directed by Scarlett Johansson coming, Saul Williams' redefines artistry. "
["image"]=>
string(38) "/images/features/200812FSAUL_55x55.jpg"
["image_198"]=>
string(39) "/images/features/200812FSAUL_230x75.jpg"
["image_476"]=>
string(40) "/images/features/200812FSAUL_160x240.jpg"
["headline_url"]=>
string(0) ""
}
[23]=>
array(10) {
["id"]=>
string(4) "1276"
["headline"]=>
string(24) "Akon: The Future Is Now "
["byline"]=>
string(10) "mjasarevic"
["date"]=>
string(10) "2008-12-10"
["num_comments"]=>
NULL
["summary"]=>
string(124) "The superstar explains his new alternative to the CD, his album's broad spectrum, Kardinal Offishall, and his philanthropy. "
["image"]=>
string(38) "/images/features/200812FAKON_55x55.jpg"
["image_198"]=>
string(39) "/images/features/200812FAKON_230x75.jpg"
["image_476"]=>
string(40) "/images/features/200812FAKON_160x240.jpg"
["headline_url"]=>
string(0) ""
}
[24]=>
array(10) {
["id"]=>
string(4) "1274"
["headline"]=>
string(18) "Slim: 112 Percent "
["byline"]=>
string(15) "william.ketchum"
["date"]=>
string(10) "2008-12-06"
["num_comments"]=>
NULL
["summary"]=>
string(126) "The 112 front-man explains his transition to solo, making rap dreams R&B, and how Puffy almost dogged out Mase on "Only You." "
["image"]=>
string(38) "/images/features/200811FSLIM_55x55.jpg"
["image_198"]=>
string(39) "/images/features/200811FSLIM_230x75.jpg"
["image_476"]=>
string(40) "/images/features/200811FSLIM_160x240.jpg"
["headline_url"]=>
string(0) ""
}
[25]=>
array(10) {
["id"]=>
string(4) "1268"
["headline"]=>
string(23) "Chef Roble: The Recipe "
["byline"]=>
string(10) "mjasarevic"
["date"]=>
string(10) "2008-11-26"
["num_comments"]=>
NULL
["summary"]=>
string(125) "On honor of Thanksgiving, DX spoke to the only chef with a deejay on his cooking show who cooks grouper listening to Ghost. "
["image"]=>
string(38) "/images/features/200811FCHEF_55x55.jpg"
["image_198"]=>
string(39) "/images/features/200811FCHEF_230x75.jpg"
["image_476"]=>
string(40) "/images/features/200811FCHEF_160x240.jpg"
["headline_url"]=>
string(0) ""
}
[26]=>
array(10) {
["id"]=>
string(4) "1262"
["headline"]=>
string(20) "Cassie: The Rebirth "
["byline"]=>
string(7) "andrest"
["date"]=>
string(10) "2008-11-14"
["num_comments"]=>
NULL
["summary"]=>
string(111) "Cassie's well-aware of your criticisms, but Bad Boy's princess has grown up, worked hard, and earned her spot. "
["image"]=>
string(38) "/images/features/200811FCASS_55x55.jpg"
["image_198"]=>
string(39) "/images/features/200811FCASS_230x75.jpg"
["image_476"]=>
string(40) "/images/features/200811FCASS_160x240.jpg"
["headline_url"]=>
string(0) ""
}
[27]=>
array(10) {
["id"]=>
string(4) "1248"
["headline"]=>
string(30) "Karina: Year Of The Young Lady"
["byline"]=>
string(8) "Sdedeyan"
["date"]=>
string(10) "2008-10-20"
["num_comments"]=>
NULL
["summary"]=>
string(131) "Karina might be the most daring artist on Def Jam, her "16 @ War" challenged teens everywhere, get close to Quincy's god-daughter. "
["image"]=>
string(38) "/images/features/200810FKRNE_55x55.jpg"
["image_198"]=>
string(39) "/images/features/200810FKRNE_230x75.jpg"
["image_476"]=>
string(40) "/images/features/200810FKRNE_160x240.jpg"
["headline_url"]=>
string(0) ""
}
}
SQL: SELECT id, headline, byline, date, ct.num_comments, summary, photo AS image, photo_index AS image_198,
photo_large AS image_476, headline_url
FROM feature_article AS fa
LEFT JOIN sitellite_user AS su ON su.username = fa.byline
LEFT JOIN comment_thread AS ct ON ct.article_id = fa.id AND ct.section_id = "lifestyle"
WHERE type = "lifestyle"
AND date <= NOW()
AND sitellite_status ="approved"
ORDER BY fa.date DESC, fa.id DESC LIMIT 0, 5
array(5) {
[0]=>
array(10) {
["id"]=>
string(4) "1423"
["headline"]=>
string(27) "DJ Hero: Built From Scratch"
["byline"]=>
string(12) "omar.burgess"
["date"]=>
string(10) "2009-10-12"
["num_comments"]=>
NULL
["summary"]=>
string(120) "Forget a review. DX went behind the scenes with actual deejays and gave developers to see if DJ Hero is worth the money."
["image"]=>
string(42) "/images/features/20091012FDJHERO_55x55.jpg"
["image_198"]=>
string(43) "/images/features/20091012FDJHERO_230x75.jpg"
["image_476"]=>
string(44) "/images/features/20091012FDJHERO_160x240.jpg"
["headline_url"]=>
string(0) ""
}
[1]=>
array(10) {
["id"]=>
string(4) "1418"
["headline"]=>
string(39) "Daryl "Chill" Mitchell: Survival Skills"
["byline"]=>
string(11) "paul.arnold"
["date"]=>
string(10) "2009-09-29"
["num_comments"]=>
NULL
["summary"]=>
string(117) "Star of House Party and Brothers tells DX about childhood friend Rakim, onetime group Groove B Chill, and much more. "
["image"]=>
string(41) "/images/features/20090929FCHILL_55x55.jpg"
["image_198"]=>
string(42) "/images/features/20090929FCHILL_230x75.jpg"
["image_476"]=>
string(43) "/images/features/20090929FCHILL_160x240.jpg"
["headline_url"]=>
string(0) ""
}
[2]=>
array(10) {
["id"]=>
string(4) "1415"
["headline"]=>
string(30) "LaMarr Woodley: Back In Black "
["byline"]=>
string(15) "quiton.hatfield"
["date"]=>
string(10) "2009-09-24"
["num_comments"]=>
NULL
["summary"]=>
string(122) "The NFL sack-man talks about Superbowl rings, his University of Michigan maturation, and the hardest defense in football. "
["image"]=>
string(41) "/images/features/20090924FLAMAR_55x55.jpg"
["image_198"]=>
string(42) "/images/features/20090924FLAMAR_230x75.jpg"
["image_476"]=>
string(43) "/images/features/20090924FLAMAR_160x240.jpg"
["headline_url"]=>
string(0) ""
}
[3]=>
array(10) {
["id"]=>
string(4) "1381"
["headline"]=>
string(34) "Marsha Ambrosius: The Flow Goes On"
["byline"]=>
string(7) "mgoakes"
["date"]=>
string(10) "2009-07-21"
["num_comments"]=>
NULL
["summary"]=>
string(116) "The former Floetry member talks about working with Michael Jackson, her long-awaited debut, and the group's fallout."
["image"]=>
string(40) "/images/features/200907FMARSHA_55x55.jpg"
["image_198"]=>
string(41) "/images/features/200907FMARSHA_230x75.jpg"
["image_476"]=>
string(42) "/images/features/200907FMARSHA_160x240.jpg"
["headline_url"]=>
string(0) ""
}
[4]=>
array(10) {
["id"]=>
string(4) "1375"
["headline"]=>
string(27) "Julia Bond: The Naked Truth"
["byline"]=>
string(10) "jake.paine"
["date"]=>
string(10) "2009-07-15"
["num_comments"]=>
NULL
["summary"]=>
string(137) "The former adult film box-cover queen talks about her deep love of Hip Hop, the parallel hustles, and her own aspirations to kick verses."
["image"]=>
string(39) "/images/features/200907FJULIA_55x55.jpg"
["image_198"]=>
string(40) "/images/features/200907FJULIA_230x75.jpg"
["image_476"]=>
string(41) "/images/features/200907FJULIA_160x240.jpg"
["headline_url"]=>
string(0) ""
}
}
SQL: SELECT id, headline, summary, headline_url
FROM feature_article AS fa
WHERE type = "lifestyle"
AND date <= NOW()
AND sitellite_status ="approved"
AND fa.date >= DATE_SUB(NOW(), INTERVAL 3 MONTH)
ORDER BY fa.times_read DESC
LIMIT 0,5
array(3) {
[0]=>
array(4) {
["id"]=>
string(4) "1423"
["headline"]=>
string(27) "DJ Hero: Built From Scratch"
["summary"]=>
string(120) "Forget a review. DX went behind the scenes with actual deejays and gave developers to see if DJ Hero is worth the money."
["headline_url"]=>
string(0) ""
}
[1]=>
array(4) {
["id"]=>
string(4) "1418"
["headline"]=>
string(39) "Daryl "Chill" Mitchell: Survival Skills"
["summary"]=>
string(117) "Star of House Party and Brothers tells DX about childhood friend Rakim, onetime group Groove B Chill, and much more. "
["headline_url"]=>
string(0) ""
}
[2]=>
array(4) {
["id"]=>
string(4) "1415"
["headline"]=>
string(30) "LaMarr Woodley: Back In Black "
["summary"]=>
string(122) "The NFL sack-man talks about Superbowl rings, his University of Michigan maturation, and the hardest defense in football. "
["headline_url"]=>
string(0) ""
}
}
SQL: SELECT id, headline, summary, headline_url
FROM feature_article AS fa
LEFT JOIN comment_thread AS ct ON ct.article_id = fa.id AND ct.section_id = ""
WHERE type = "lifestyle"
AND date <= NOW()
AND sitellite_status ="approved"
AND fa.date >= DATE_SUB(NOW(), INTERVAL 3 MONTH)
ORDER BY ct.num_comments DESC
LIMIT 0,5
array(3) {
[0]=>
array(4) {
["id"]=>
string(4) "1415"
["headline"]=>
string(30) "LaMarr Woodley: Back In Black "
["summary"]=>
string(122) "The NFL sack-man talks about Superbowl rings, his University of Michigan maturation, and the hardest defense in football. "
["headline_url"]=>
string(0) ""
}
[1]=>
array(4) {
["id"]=>
string(4) "1418"
["headline"]=>
string(39) "Daryl "Chill" Mitchell: Survival Skills"
["summary"]=>
string(117) "Star of House Party and Brothers tells DX about childhood friend Rakim, onetime group Groove B Chill, and much more. "
["headline_url"]=>
string(0) ""
}
[2]=>
array(4) {
["id"]=>
string(4) "1423"
["headline"]=>
string(27) "DJ Hero: Built From Scratch"
["summary"]=>
string(120) "Forget a review. DX went behind the scenes with actual deejays and gave developers to see if DJ Hero is worth the money."
["headline_url"]=>
string(0) ""
}
}