Грешка со WordPress базата на податоци: [Column 'term_taxonomy_id' in FROM is ambiguous]
SELECT COUNT( DISTINCT 50F6O_posts.ID ) AS term_count, terms.term_id AS term_count_id
FROM 50F6O_posts
LEFT JOIN 50F6O_term_relationships ON (50F6O_posts.ID = 50F6O_term_relationships.object_id)
INNER JOIN 50F6O_term_relationships AS term_relationships ON 50F6O_posts.ID = term_relationships.object_id
INNER JOIN 50F6O_term_taxonomy AS term_taxonomy USING( term_taxonomy_id )
INNER JOIN 50F6O_terms AS terms USING( term_id )
WHERE 50F6O_posts.post_type = 'product'
AND 50F6O_posts.post_status = 'publish'
AND (
50F6O_posts.ID NOT IN (
SELECT object_id
FROM 50F6O_term_relationships
WHERE term_taxonomy_id IN (7)
)
AND
50F6O_term_relationships.term_taxonomy_id IN (275)
)
AND terms.term_id IN (163,86,79,95,71,73,149,84,74,85,91,87,78,167,66,65,218,237,200,240,227,241,228,213,212)
GROUP BY terms.term_id
Грешка со WordPress базата на податоци: [Column 'term_taxonomy_id' in FROM is ambiguous]
SELECT COUNT( DISTINCT 50F6O_posts.ID ) AS term_count, terms.term_id AS term_count_id
FROM 50F6O_posts
LEFT JOIN 50F6O_term_relationships ON (50F6O_posts.ID = 50F6O_term_relationships.object_id)
INNER JOIN 50F6O_term_relationships AS term_relationships ON 50F6O_posts.ID = term_relationships.object_id
INNER JOIN 50F6O_term_taxonomy AS term_taxonomy USING( term_taxonomy_id )
INNER JOIN 50F6O_terms AS terms USING( term_id )
WHERE 50F6O_posts.post_type = 'product'
AND 50F6O_posts.post_status = 'publish'
AND (
50F6O_posts.ID NOT IN (
SELECT object_id
FROM 50F6O_term_relationships
WHERE term_taxonomy_id IN (7)
)
AND
50F6O_term_relationships.term_taxonomy_id IN (275)
)
AND terms.term_id IN (156,180,171,147,177,164,152,75,185,183,174,186,160,247,278,196,242,234,226,276,194,243,273,224,246,274,245,229,221,217,251,249,279,216,258,257,259,260,256)
GROUP BY terms.term_id
Грешка со WordPress базата на податоци: [Column 'term_taxonomy_id' in FROM is ambiguous]
SELECT COUNT( DISTINCT 50F6O_posts.ID ) AS term_count, terms.term_id AS term_count_id
FROM 50F6O_posts
LEFT JOIN 50F6O_term_relationships ON (50F6O_posts.ID = 50F6O_term_relationships.object_id)
INNER JOIN 50F6O_term_relationships AS term_relationships ON 50F6O_posts.ID = term_relationships.object_id
INNER JOIN 50F6O_term_taxonomy AS term_taxonomy USING( term_taxonomy_id )
INNER JOIN 50F6O_terms AS terms USING( term_id )
WHERE 50F6O_posts.post_type = 'product'
AND 50F6O_posts.post_status = 'publish'
AND (
50F6O_posts.ID NOT IN (
SELECT object_id
FROM 50F6O_term_relationships
WHERE term_taxonomy_id IN (7)
)
AND
50F6O_term_relationships.term_taxonomy_id IN (275)
)
AND terms.term_id IN (182,178,184,150,76,165,192,168,159,225,231,239,230,248,281,280,250)
GROUP BY terms.term_id
