Dtjytyk

Plausibility of Mushroom Buildings

Why the color red for the Republican Party

How can I ensure my trip to the UK will not have to be cancelled because of Brexit?

How to draw cubes in a 3 dimensional plane

What are some noteworthy "mic-drop" moments in math?

How are showroom/display vehicles prepared?

Bash script should only kill those instances of another script's that it has launched

Examples of a statistic that is not independent of sample's distribution?

Should I take out a loan for a friend to invest on my behalf?

How can I get players to stop ignoring or overlooking the plot hooks I'm giving them?

UART pins to unpowered MCU?

What are the threaded holes in Manfrotto camera brackets?

Signed and unsigned numbers

Is "history" a male-biased word ("his+story")?

How to secure an aircraft at a transient parking space?

What Happens when Passenger Refuses to Fly Boeing 737 Max?

Can one live in the U.S. and not use a credit card?

Accepted offer letter, position changed

Find longest word in a string: are any of these algorithms good?

List elements digit difference sort

Do recommendation systems necessarily use machine learning algorithms?

How do I express some one as a black person?

Do f-stop and exposure time perfectly cancel?

Does the nature of the Apocalypse in The Umbrella Academy change from the first to the last episode?

Item (Mage_Catalog_Model_Product) with the same id “35” already exist

Item (Mage_Core_Model_Config_Data) with the same id “0” already existMagento Admin Login Error: Item (Mage_Sales_Model_Order) with the same id “1178” already existGrid Export: Item (Neo_Affiliate_Model_Affiliate) with the same id “2977” already existErrors after re-index: Item (Mage_Core_Model_Url_Rewrite) with the same id “0” already exist"Item (Mage_Sales_Model_Order) with the same id already exist after Plesk UpgradeItem (Mage_Admin_Model_Block) with the same id “0” already existMagento error when product added to cart Item (Mage_Catalog_Model_Product) with the same id “1698” already existMganto1.9 : Item (Mage_Sales_Model_Order) with same id already existMagento 1.9: Maximum execution timeout after loginHow to get products filtering by category and attributes?

0

In admin, I can create multiple categories to shown in homepage.
This all categories are called on homepage via widget.
This is working as expected if all categories have unique products.

Suppose One product id is same in two category, magento give me error as
'Item (Mage_Catalog_Model_Product) with the same id "35" already exist'

So I researched and found one suggestion to add unique serial id to beginning of table by adding

SELECT 
`e`.*, 
`category_products_grid`.`product_id`, 
`category_products`.*, 
`eav_name`.`value` AS `category_name`, 
`eav_url`.`value` AS `category_url` 
FROM 
`catalog_product_entity` AS `e` 
INNER JOIN `category_products_grid` ON category_products_grid.product_id = 
e.entity_id 
INNER JOIN `category_products` ON category_products_grid.id = 
category_products.id 
INNER JOIN `catalog_category_entity_varchar` AS `eav_name` ON eav_name.entity_id = category_products.category 
and eav_name.attribute_id = 43 
INNER JOIN `catalog_category_entity_varchar` AS `eav_url` ON eav_url.entity_id = category_products.category 
and eav_url.attribute_id = 59

And the result is shown below
.

Can anyone help me with this query to append in magentoway?
If any one can suggest other way around, it will be helpful as well.

magento-1.9 database

share|improve this question

edited 12 mins ago

Muhammad Hasham

2,2581630

asked 17 mins ago

VandanaVandana

12

add a comment | 

0

In admin, I can create multiple categories to shown in homepage.
This all categories are called on homepage via widget.
This is working as expected if all categories have unique products.

Suppose One product id is same in two category, magento give me error as
'Item (Mage_Catalog_Model_Product) with the same id "35" already exist'

So I researched and found one suggestion to add unique serial id to beginning of table by adding

SELECT 
`e`.*, 
`category_products_grid`.`product_id`, 
`category_products`.*, 
`eav_name`.`value` AS `category_name`, 
`eav_url`.`value` AS `category_url` 
FROM 
`catalog_product_entity` AS `e` 
INNER JOIN `category_products_grid` ON category_products_grid.product_id = 
e.entity_id 
INNER JOIN `category_products` ON category_products_grid.id = 
category_products.id 
INNER JOIN `catalog_category_entity_varchar` AS `eav_name` ON eav_name.entity_id = category_products.category 
and eav_name.attribute_id = 43 
INNER JOIN `catalog_category_entity_varchar` AS `eav_url` ON eav_url.entity_id = category_products.category 
and eav_url.attribute_id = 59

And the result is shown below
.

Can anyone help me with this query to append in magentoway?
If any one can suggest other way around, it will be helpful as well.

magento-1.9 database

share|improve this question

edited 12 mins ago

Muhammad Hasham

2,2581630

asked 17 mins ago

VandanaVandana

12

add a comment | 

In admin, I can create multiple categories to shown in homepage.
This all categories are called on homepage via widget.
This is working as expected if all categories have unique products.

Suppose One product id is same in two category, magento give me error as
'Item (Mage_Catalog_Model_Product) with the same id "35" already exist'

So I researched and found one suggestion to add unique serial id to beginning of table by adding

SELECT 
`e`.*, 
`category_products_grid`.`product_id`, 
`category_products`.*, 
`eav_name`.`value` AS `category_name`, 
`eav_url`.`value` AS `category_url` 
FROM 
`catalog_product_entity` AS `e` 
INNER JOIN `category_products_grid` ON category_products_grid.product_id = 
e.entity_id 
INNER JOIN `category_products` ON category_products_grid.id = 
category_products.id 
INNER JOIN `catalog_category_entity_varchar` AS `eav_name` ON eav_name.entity_id = category_products.category 
and eav_name.attribute_id = 43 
INNER JOIN `catalog_category_entity_varchar` AS `eav_url` ON eav_url.entity_id = category_products.category 
and eav_url.attribute_id = 59

And the result is shown below
.

Can anyone help me with this query to append in magentoway?
If any one can suggest other way around, it will be helpful as well.

magento-1.9 database

share|improve this question

edited 12 mins ago

Muhammad Hasham

2,2581630

asked 17 mins ago

VandanaVandana

12

SELECT 
`e`.*, 
`category_products_grid`.`product_id`, 
`category_products`.*, 
`eav_name`.`value` AS `category_name`, 
`eav_url`.`value` AS `category_url` 
FROM 
`catalog_product_entity` AS `e` 
INNER JOIN `category_products_grid` ON category_products_grid.product_id = 
e.entity_id 
INNER JOIN `category_products` ON category_products_grid.id = 
category_products.id 
INNER JOIN `catalog_category_entity_varchar` AS `eav_name` ON eav_name.entity_id = category_products.category 
and eav_name.attribute_id = 43 
INNER JOIN `catalog_category_entity_varchar` AS `eav_url` ON eav_url.entity_id = category_products.category 
and eav_url.attribute_id = 59

share|improve this question

edited 12 mins ago

Muhammad Hasham

2,2581630

asked 17 mins ago

VandanaVandana

12

share|improve this question

edited 12 mins ago

Muhammad Hasham

2,2581630

asked 17 mins ago

VandanaVandana

12

edited 12 mins ago

Muhammad Hasham

2,2581630

edited 12 mins ago

Muhammad Hasham

2,2581630

asked 17 mins ago

VandanaVandana

12

asked 17 mins ago

VandanaVandana

12