Автори | Гоголівська академія

Українська банерна мережа

Украинская Баннерная Сеть



	ПОШУК

АВТОРУ:

	Ім’ я користувача

	Пароль



Бажаєте зареєструватися? Забули пароль?

Гоголівський ФОРУМ

AlmaNAH

Наша статистика

Авторів:	2710
Творів:	52097
Рецензій:	96321

Наша кнопка

Код:

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '2176'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '743'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '1933'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '48'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '3514'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '1839'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '1733'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '2390'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '3780'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '457'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '375'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '3709'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '1355'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '442'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '980'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '427'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '214'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '2162'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '2217'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '4357'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '740'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '2237'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '2098'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '3687'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '4456'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '662'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '3308'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '5166'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '2825'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '4022'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '4378'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '1052'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '5081'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '3846'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '4245'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '4734'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '4241'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '6169'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Уляна Галич (Консуело)
Свіжі твори

Владислав Неживий
Свіжі твори

Нема
Свіжі твори

Третє Я (колишній ТШЗ)
Свіжі твори


Свіжі твори

Іван Лузан
Свіжі твори

Богдана
Свіжі твори

Сергій Аркуша
Свіжі твори

Estrella del Mar
Свіжі твори

Vasyl R
Свіжі твори

Дана Рудик
Свіжі твори

Аnnie
Свіжі твори

Черезова Варвара
Свіжі твори

Viktoria Jichova
Свіжі твори

Юлія-Ванда Мусаковська
Свіжі твори

Михайло Карповий
Свіжі твори

koka cherkaskij
Свіжі твори

Наталка Ліщинська
Свіжі твори

Platon
Свіжі твори

Пономаренко Алла
Свіжі твори

Явна Уляна
Свіжі твори

Кактусь
Свіжі твори

Дара К.
Свіжі твори

Наталка Тактреба
Свіжі твори

Віта Парфенович
Свіжі твори

Валерія
Свіжі твори

Микола Ільків-Свидницький (Левандівський)
Свіжі твори

Сергій Русаков
Свіжі твори

Олександра
Свіжі твори

Зоряна Львів
Свіжі твори

Коляда Роман
Свіжі твори

Маріанна Малина
Свіжі твори

Віктор Чубенко
Свіжі твори

div4yna_zirka
Свіжі твори

Заза Пауалішвілі
Свіжі твори

Руденьке сонечко
Свіжі твори

Любомир Коблик
Свіжі твори

***
Свіжі твори

| | | [ Лімерики] | | | |

Згенеровано за 1.6121599674225 сек.

Усі права застережено.
Всі права на сайт належать ТОВ «Джерела М»
Авторські права на твори та рецензії належать їх авторам.
Дизайн та програмування KP-design

Часопис української культури

Що почитати

• Погляд на світ через призму пародії.
«Прометей поміж грудей» – тільки ця провокативна назва збірки чого варта! І це не натяк, це те, про …→

• День Соборності України
Вітаємо всіх з днем Соборності! Бажаємо нашій державі незламності, непохитності, витримки та величчі! …→

• Українські традиції та звичаї
Друзі! На сайті “Онлайн Криївка” є дуже цікава добірка книг про українські традиції та звичаї. …→

• Графічний роман “Серед овець”
Графічний роман Корешкова Олександра «Серед овець», можна було б сміливо віднести до антиутопії, як …→