Error

Unknown column 'a.title_alias' in 'field list' SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 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,( SELECT MAX(contact.id) AS id FROM iyir2_contact_details AS contact WHERE contact.published = 1 AND contact.user_id = a.created_by) as contactid,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 iyir2_content AS a LEFT JOIN iyir2_categories AS c ON c.id = a.catid LEFT JOIN iyir2_users AS ua ON ua.id = a.created_by LEFT JOIN iyir2_users AS uam ON uam.id = a.modified_by LEFT JOIN iyir2_categories as parent ON parent.id = c.parent_id LEFT JOIN iyir2_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM iyir2_categories AS cat JOIN iyir2_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 iyir2_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND c.access IN (1,1) 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 <= '2016-09-25 18:59:47') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2016-09-25 18:59:47') ORDER BY c.lft, a.featured DESC, fp.ordering, a.created DESC

JOIN OUR MAILING LIST     facebook    twitter    skype

Guest Impressions
Heritage Day - Making our Mark
Last Updated on Sep 23 2016

Heritage Day - Making...

A true Muslim is one who has a genuine concern for the Ummat of Rasulullah ﷺ and humanity. He holds the condition, concerns and trials of humanity close to his heart. This Ummat has been given the mantle of being the best Ummat (nation) by virtue...
SA encouraged to save water
Last Updated on Sep 07 2016

SA encouraged to save...

The South African Weather Service has encouraged South Africans to use water sparingly as the country is still experiencing drought conditions.
‘Google’ can’t see Israel’s Apartheid Wall
Last Updated on Sep 07 2016

‘Google’ can’t see...

When the American technology giant Google was accused of deleting Palestine from its Maps app, following a global protest it admitted that it was never labelled as such in the first place, even though 136 members of the UN recognise Palestine as an...
Preparations for the day of Haj
Last Updated on Sep 07 2016

Preparations for the day...

Haj is a trip of lifetime; it is only required once from a Muslim and it is only the first one that counts as the fulfilment of the obligation.
France: First official refugee camp to open in Paris
Last Updated on Sep 07 2016

France: First official...

France is set to open its first approved refugee camp in the capital by the end of September, Paris Mayor Anne Hidalgo announced Wednesday. Hidalgo said a second camp will follow.

Tour Darul Ihsan

Tour Darul Ihsa...
Image Detail
Tour Darul Ihsa...
Image Detail
Tour Darul Ihsa...
Image Detail
Tour Darul Ihsa...
Image Detail

Nisab

Mahr Fatimi:  R14 191.44
Minimum Mahr:  R283.82
Zakaah Nisaab: R5676.57
Updated on 23 Sep 2016

Mufti Zubair Bayat

marriage_registration   vacancy1

banking details

GET CONNECTED WITH US       facebook       twitter      skype