SELECT xcart_categories.categoryid , xcart_categories.category, xcart_images_C.image_path, xcart_images_C.image_x, xcart_images_C.image_y, xcart_categories_subcount.subcategory_count, IF((xcart_categories_lng.category IS NOT NULL AND xcart_categories_lng.category != ''), xcart_categories_lng.category, xcart_categories.category) as category, IF((xcart_categories_lng.description IS NOT NULL AND xcart_categories_lng.description != ''), xcart_categories_lng.description, xcart_categories.description) as description, xcart_categories.category as category_name_orig, xcart_clean_urls.clean_url, xcart_clean_urls.mtime FROM xcart_categories  LEFT JOIN xcart_images_C ON xcart_images_C.id = xcart_categories.categoryid LEFT JOIN xcart_categories_subcount ON xcart_categories_subcount.categoryid = xcart_categories.categoryid AND xcart_categories_subcount.membershipid = '' LEFT JOIN xcart_category_memberships ON xcart_category_memberships.categoryid = xcart_categories.categoryid  LEFT JOIN xcart_categories_lng ON xcart_categories_lng.code='en' AND xcart_categories_lng.categoryid=xcart_categories.categoryid  LEFT JOIN xcart_clean_urls ON resource_type = 'C' AND resource_id = '1488' WHERE xcart_categories.categoryid IN ('299','1488') AND xcart_categories.avail = 'Y' GROUP BY xcart_categories.categoryid ORDER BY NULL2 != 2Array
(
    [299] => Array
        (
            [category] => Cigars
            [image_path] => 
            [image_x] => 
            [image_y] => 
            [subcategory_count] => 1102
            [description] => 
            [category_name_orig] => Cigars
            [clean_url] => My-Father-The-Judge-Cigars
            [mtime] => 1716313633
        )

    [1488] => Array
        (
            [category] => My Father The Judge
            [image_path] => ./images/C/My-Father_The-Judge-cigar.jpg
            [image_x] => 1000
            [image_y] => 765
            [subcategory_count] => 0
            [description] => <p>Although the Garcia family has been crafting some of the world’s best cigars for some time, including their breakout success with Pete Johnson’s Tatuaje brand, it wasn’t until 2009 that their own My Father brand started gaining serious acclaim—following a head-turning ranking as Cigar Aficionado’s #3 Cigar of the Year for 2009.</p>
<p>My Father Cigars has since gone on to win multiple other accolades, including the prestigious #1 Cigar of the Year designation (2012 & 2015). The brand has expanded well beyond the original, eponymously titled “My Father” blend, including two sister blends—My Father Le Bijou 1922 and My Father Connecticut.</p>
<p>Now, the Garcia family has introduced the latest expansion to the legendary My Father lineup—My Father The Judge. Donning a recreation of an antique, Victorian lithograph circa 1905, The Judge takes on the posh look of sophistication. It was reportedly inspired from a friend of the Garcias, whom happens to share the judiciary occupation. For this new take on the brand’s flagship cigar, the Garcias have opted to showcase a fuller-bodied experience. A double binder of Nicaraguan Corojo and Criollo tobaccos envelops a special selection of Nicaraguan tobaccos, harvested from three of the Garcia’s own farms (La Bonita Two, El Pedrero and San Rafael). This is where the blend derives its strength, which has been cleverly disguised by a sweet, dark brown, Sumatra Oscuro wrapper. Box-pressed and rolled in two commanding sizes (6x56 Toro and 5x60 Grand Robusto), The Judge is an intense smoking experience, chock-full with palate-smacking flavors for the enthusiast.</p>
            [category_name_orig] => My Father The Judge
            [clean_url] => My-Father-The-Judge-Cigars
            [mtime] => 1716313633
        )

)