Gsyfuy

How to secure an aircraft at a transient parking space?

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

Distinction between apt-cache and dpkg -l

Vocabulary for giving just numbers, not a full answer

Filtering SOQL results with optional conditionals

In the quantum hamiltonian, why does kinetic energy turn into an operator while potential doesn't?

What wound would be of little consequence to a biped but terrible for a quadruped?

Can Mathematica be used to create an Artistic 3D extrusion from a 2D image and wrap a line pattern around it?

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

How is the wildcard * interpreted as a command?

What Happens when Passenger Refuses to Fly Boeing 737 Max?

Intuition behind counterexample of Euler's sum of powers conjecture

Are there historical instances of the capital of a colonising country being temporarily or permanently shifted to one of its colonies?

Could you please stop shuffling the deck and play already?

Signed and unsigned numbers

Do I really need to have a scientific explanation for my premise?

Database Backup for data and log files

Do recommendation systems necessarily use machine learning algorithms?

Plausibility of Mushroom Buildings

Single word request: Harming the benefactor

Meaning of ちはース as an exclamation

Why does liquid water form when we exhale on a mirror?

How to draw cubes in a 3 dimensional plane

Is it "Vierergruppe" or "Viergruppe", or is there a distinction?

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

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

asked 1 min 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

asked 1 min 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

asked 1 min ago

VandanaVandana

12

SELECT 

share

asked 1 min ago

VandanaVandana

12

share

asked 1 min ago

VandanaVandana

12

asked 1 min ago

VandanaVandana

12

asked 1 min ago

VandanaVandana

12