×

Error

SQL=SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM q3ujw_content AS a LEFT JOIN q3ujw_categories AS c ON c.id = a.catid LEFT JOIN q3ujw_users AS ua ON ua.id = a.created_by LEFT JOIN q3ujw_users AS uam ON uam.id = a.modified_by LEFT JOIN q3ujw_categories as parent ON parent.id = c.parent_id LEFT JOIN q3ujw_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM q3ujw_categories AS cat JOIN q3ujw_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN q3ujw_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1,5) AND c.access IN (1,1,5) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-09-01 07:32:38') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-09-01 07:32:38') ORDER BY c.lft, a.featured DESC, fp.ordering, a.created DESC LIMIT 116, 4

Menu

LG G Pad 7.0

The LG G Pad 7.0 strikes a nice balance between price and features, making it a good starting point for entry-level Android tablets.

Read more

Top Stories

Hands-On: Apple OS X Yosemite Beta

Apple has released a free public beta of OS X Yosemite, the next version of the Mac operating system, scheduled for final release this fall....

MSI GS70 Stealth

The MSI GS70 Stealth is a slim, yet powerful, gaming laptop. It has a HDD/SSD combo and...

LG G Pad 7.0

The LG G Pad 7.0 strikes a nice balance between price and features, making it a good...

Buying Guides

How to Buy An Internal Hard Drive

Internal storage would seem like an easy thing to buy: Just find the biggest drive you can afford, and you're...

How to Buy Cheap Laptops

Everyone likes a good bargain—the trick is distinguishing what's truly a worthwhile deal from something you may regret after you've...

How to Buy a Smartphone

If you thought choosing a smartphone was difficult last year, it's even tougher now. That's a good thing, though, because...

More News & Reviews

August 28 Tablets

LG G Pad 7.0

The LG G Pad 7.0 strikes a nice balance between price and features, making it a good starting point for entry-level Android tablets.

Read more

August 14 Notebook Computers

MSI GS70 Stealth

The MSI GS70 Stealth is a slim, yet powerful, gaming laptop. It has a HDD/SSD combo and a high-performing i7 CPU that won't slow down. It does lack a touch screen, however, despite the high cost.

Read more

August 07 Notebook Computers

Apple MacBook Pro 13-Inch, Retina Display (2014)

The latest 13-inch Retina Apple MacBook Pro gives you top-notch performance and more than 13 hours of battery life in a beautifully designed laptop. It's our top pick for high-end ultraportables.

Read more

August 04 Software

Hands-On: Apple OS X Yosemite Beta

Apple has released a free public beta of OS X Yosemite, the next version of the Mac operating system, scheduled for final release this fall. The beta—the first public OS X beta since the first version back in 2001—is open to a million users.

Read more

July 29 Notebook Computers

HP EliteBook Folio 1040 G1

The rugged HP EliteBook Folio 1040 G1 ultrabook is equipped with a touch screen and trades physical connectivity for a slim and portable chassis. It's a good choice for a business that needs to buy new PCs for an entire staff.

Read more

July 21 Digital Cameras

Sony Cyber-shot DSC-RX100 III

The Sony Cyber-shot DSC-RX100 III compact camera earns Editors' Choice accolades because of its image quality and excellent EVF, even despite its high price.

Read more

July 15 Notebook Computers

The Best Laptops for College Students

These days, the PC of choice for the college-bound is a laptop. We winnow down the choices to our top-rated picks to take you through at least four years of campus life.

Read more

July 07 Features

The 10 Best Windows 8 Tablets

Tablets are everywhere today, with multiple new touch-friendly models released by every major manufacturer. Spurred on by the tablet-friendly Windows 8 and new hardware that fits PC power into slimmer and lighter devices, these handy PCs won't be disappearing anytime soon.

Read more