Not enough arguments passed for statement. Expected 4 got 0 - SELECT group_concat(" " || T1.value,'
'), group_concat(" " || T2.value,'
'), group_concat(" " || T3.value,'
'), group_concat(" " || T4.value,'
'), group_concat(" " || T5.value,'
')
FROM (
SELECT DISTINCT pages.pid AS pid
FROM pages LEFT JOIN data AS T1 ON T1.pid = pages.pid AND T1.key = 'type' LEFT JOIN data AS T2 ON T2.pid = pages.pid AND T2.key = 'film' LEFT JOIN data AS T3 ON T3.pid = pages.pid AND T3.key = 'film' LEFT JOIN data AS T4 ON T4.pid = pages.pid AND T4.key = 'year'
WHERE 1 = 1 AND T1.value = 'film' AND T2.value != 'film/' AND T3.value != '' AND T4.value = '????'
) AS W1
LEFT JOIN data AS T1 ON T1.pid = W1.pid AND T1.key = 'film' LEFT JOIN data AS T2 ON T2.pid = W1.pid AND T2.key = 'yearlabel' LEFT JOIN data AS T3 ON T3.pid = W1.pid AND T3.key = 'director' LEFT JOIN data AS T4 ON T4.pid = W1.pid AND T4.key = 'producer' LEFT JOIN data AS T5 ON T5.pid = W1.pid AND T5.key = 'starring'
LEFT JOIN pages ON W1.pid=pages.pid
GROUP BY W1.pid
ORDER BY T2.value ASC LIMIT 11
List of Hausa Films
Here you'll find a running list (work-in-progress) of all Hausa films. Realize what a daunting task this is so to make the list as “complete” as possible so we'll need some help. If you're a fan of Hausa films or just want to contribute, you can easily sign up, log in, and start adding and editing this list. Your contributions are greatly be appreciated!
Browse by year of release: 2018 | 2017 | 2016 | 2015 | 2014 | 2013 | 2012 | 2011 | 2010 | List all the Hausa movies*1)
827 Hausa Movies Total
+Add New Film