SELECT `value`
FROM `product_field_values`
WHERE `product_id` = '461'
AND `product_field_id` = 2<pre>Array
(
    [id] => 461
    [code] => C3N2TB
    [url_code] => transcend-c3n-extra-slim-2-5-quot-2tb-ultra-portable-hdd
    [quantity] => 0
    [cat_id] => 41
    [cat_id_second] => 275
    [cat_id_third] => 0
    [inc_tax] => 0
    [inc_vat] => 0
    [free_ship] => 0
    [meta_desc] => Branded ultra slim HDD available in Nepal, price of 2TB ultra portable HDD in Nepal, best price for 2TB hard disk drive in Nepal
    [meta_keyword] => HDD, hard disk, external storage device, 2 TB, transcend, HDD available in Nepal, 2TB HDD
    [status] => 1
    [googlebase] => 0
    [views] => 682
    [featured] => 0
    [newproduct] => 0
    [discounted] => 0
    [bestseller] => 0
    [related_prods] => ,
    [digitalprodid] => 0
    [category_id] => 41
    [name] => TRANSCEND C3N Extra Slim 2.5&amp;amp;quot; 2TB Ultra Portable HDD
    [price] => 12875
    [discounted_price] => 0.136
    [original_price] => 12875
    [brand] => Transcend
    [promo_line] => Extra Slim Ultra Portable Hard Disk Drive
    [description] => &lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;PRODUCT INFORMATION&amp;nbsp;&lt;/p&gt;&lt;div&gt;&amp;nbsp;&lt;/div&gt;&lt;div&gt;Brand : Transcend&amp;nbsp;&lt;/div&gt;&lt;div&gt;Item Model No : C3N&lt;/div&gt;&lt;div&gt;Memory : 2 TGB&amp;nbsp;&lt;/div&gt;&lt;div&gt;USB: 3.0&amp;nbsp;&lt;/div&gt;&lt;div&gt;Item Weight : 0.136 kg&amp;nbsp;&lt;/div&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;
    [product_id] => 461
    [image] => 1transcend-c3n-extra-slim-2-5-quot-2tb-ultra-portab.jpg
    [images] => Array
        (
            [0] => Array
                (
                    [image] => 1transcend-c3n-extra-slim-2-5-quot-2tb-ultra-portab.jpg
                )

            [1] => Array
                (
                    [image] => 2transcend-c3n-extra-slim-2-5-quot-2tb-ultra-portab.jpg
                )

            [2] => Array
                (
                    [image] => 3transcend-c3n-extra-slim-2-5-quot-2tb-ultra-portab.jpg
                )

            [3] => Array
                (
                    [image] => 4transcend-c3n-extra-slim-2-5-quot-2tb-ultra-portab.jpg
                )

            [4] => Array
                (
                    [image] => 5transcend-c3n-extra-slim-2-5-quot-2tb-ultra-portab.jpg
                )

            [5] => Array
                (
                    [image] => 1transcend-c3n-extra-slim-2-5-quot-2tb-ultra-portab.jpg
                )

        )

    [ip] => 18.97.14.86
    [related_products] => Array
        (
            [0] => stdClass Object
                (
                    [id] => 435
                    [code] => A3k Piano Flash 1 TB
                    [url_code] => transcend-a3k-piano-finish-2-5-039-039-1tb-hdd-usb
                    [quantity] => 0
                    [newproduct] => 0
                    [bestseller] => 0
                    [discounted] => 0
                    [name] => TRANSCEND A3k Piano Finish 1TB HDD/ USB 3.0
                    [price] => 8500
                    [discounted_price] => 0.21
                    [original_price] => 8500
                    [brand] => Transcend
                    [promo_line] => Compatible with Superspeed USB 3.0
                    [image] => 43571h5G7FeTkL._SL1500_.jpg
                )

            [1] => stdClass Object
                (
                    [id] => 436
                    [code] => M3 Rubber Case HDD
                    [url_code] => transcend-m3-rubber-case-2-5-039-039-500-gb-portab
                    [quantity] => 0
                    [newproduct] => 0
                    [bestseller] => 0
                    [discounted] => 0
                    [name] => TRANSCEND M3 rubber case /500 GB Portable Hard Disk Drive
                    [price] => 7625
                    [discounted_price] => 0.18
                    [original_price] => 7625
                    [brand] => Transcend
                    [promo_line] => Compatible with Superspeed USB 3.0
                    [image] => 43681SaDTelmlL._SL1500_.jpg
                )

            [2] => stdClass Object
                (
                    [id] => 437
                    [code] => M3 Rubber Case 1 TB HDD
                    [url_code] => transcend-m3-rubber-case-2-5-039-039-1-tb-portable
                    [quantity] => 0
                    [newproduct] => 0
                    [bestseller] => 0
                    [discounted] => 0
                    [name] => TRANSCEND M3 Rubber Case 1 TB Portable Hard Disk Drive
                    [price] => 9250
                    [discounted_price] => 0.21
                    [original_price] => 9250
                    [brand] => Transcend
                    [promo_line] => Every memories last long with this shock resistance rubber cased Hard disk drive.
                    [image] => 43771kglGj1OaL._SL1500_.jpg
                )

            [3] => stdClass Object
                (
                    [id] => 438
                    [code] => H3-2TB
                    [url_code] => transcend-h3-rubber-case-series-2-5-039-039-2-tb-hdd-usb-3-0-hard-disk
                    [quantity] => 0
                    [newproduct] => 0
                    [bestseller] => 0
                    [discounted] => 0
                    [name] => TRANSCEND H3 Rubber Case Series / 2 TB HDD/ USB 3.0 Hard Disk
                    [price] => 12750
                    [discounted_price] => 0.21
                    [original_price] => 13500
                    [brand] => Transcend
                    [promo_line] => Compatible with Superspeed USB 3.0
                    [image] => 43871sAk4VcF8L._SL1500_.jpg
                )

            [4] => stdClass Object
                (
                    [id] => 460
                    [code] => C3N
                    [url_code] => transcend-c3n-extra-slim-2-5-quot-1tb-ultra-portable-hdd
                    [quantity] => 0
                    [newproduct] => 0
                    [bestseller] => 0
                    [discounted] => 0
                    [name] => TRANSCEND C3N Extra Slim 2.5&amp;amp;quot; 1TB Ultra Portable HDD
                    [price] => 9000
                    [discounted_price] => 0.136
                    [original_price] => 9000
                    [brand] => Transcend
                    [promo_line] => Extra Slim Portable Hard Disk Drive
                    [image] => 1transcend-c3n-extra-slim-2-5-quot-1tb-ultra-portab.jpg
                )

            [5] => stdClass Object
                (
                    [id] => 462
                    [code] => H34TB
                    [url_code] => transcend-h3-rubber-case-4-tb-portable-hdd-2-5-quot-new
                    [quantity] => 0
                    [newproduct] => 0
                    [bestseller] => 0
                    [discounted] => 0
                    [name] => TRANSCEND H3 Rubber Case 4 TB Portable HDD-2.5&amp;amp;quot; New
                    [price] => 21250
                    [discounted_price] => 0.308
                    [original_price] => 22375
                    [brand] => Transcend
                    [promo_line] => Military Grade Shock Resistance One-Touch Auto-Backup Button First Portable 4 TB in Nepal
                    [image] => 1transcend-h3-rubber-case-4-tb-portable-hdd-2-5-quo.jpg
                )

            [6] => stdClass Object
                (
                    [id] => 463
                    [code] => M3-1TB
                    [url_code] => transcend-m3-rubber-case-1tb-hdd-2-5-quot-type-c
                    [quantity] => 0
                    [newproduct] => 0
                    [bestseller] => 0
                    [discounted] => 0
                    [name] => TRANSCEND M3 Rubber Case 1TB HDD-2.5&amp;amp;quot; Type C
                    [price] => 8875
                    [discounted_price] => .230
                    [original_price] => 9250
                    [brand] => Transcend
                    [promo_line] => Shock Resistance Qualities with Speed
                    [image] => 1transcend-m3-rubber-case-1tb-hdd-2-5-quot-type-c.jpg
                )

            [7] => stdClass Object
                (
                    [id] => 3133
                    [code] => Desktop-HDD-2TB
                    [url_code] => Buy-2TB-Desktop-Hard-Disk-Drive-in-Nepal
                    [quantity] => 0
                    [newproduct] => 0
                    [bestseller] => 0
                    [discounted] => 0
                    [name] =>  Hard Disk Drive Desktop HDD 2TB
                    [price] => 10000
                    [discounted_price] => 
                    [original_price] => 10000
                    [brand] => Lenovo
                    [promo_line] => powerful storage capacity 
                    [image] => 1transcend-35t3-4-tb-2-5-quot-usb-3-0-desktop-hdd.jpg
                )

            [8] => stdClass Object
                (
                    [id] => 7085
                    [code] => HD680
                    [url_code] => adata-military-grade-shock-proof-external-hdd-hd680
                    [quantity] => 5
                    [newproduct] => 0
                    [bestseller] => 0
                    [discounted] => 0
                    [name] => ADATA Military-Grade Shock-Proof External HDD(HD680)
                    [price] => 11000
                    [discounted_price] => 
                    [original_price] => 13000
                    [brand] => ADATA
                    [promo_line] => Defend your data with Military Grade Protection.
                    [image] => 309944080-adata-military-grade-shock-proof-external-hdd(hd680).jpg
                )

            [9] => stdClass Object
                (
                    [id] => 6469
                    [code] => HD710P
                    [url_code] => adata-durable-series-hd710-pro-external-hdd
                    [quantity] => 5
                    [newproduct] => 0
                    [bestseller] => 0
                    [discounted] => 0
                    [name] => Adata Durable series HD710 Pro External HDD
                    [price] => 9100
                    [discounted_price] => 
                    [original_price] => 9100
                    [brand] => ADATA
                    [promo_line] => Waterproof and dust proof High quality external HDD.
                    [image] => 1975566316-adata-durable-series-hd710-pro-1tb-external-hdd.jpg
                )

            [10] => stdClass Object
                (
                    [id] => 6470
                    [code] => HD720
                    [url_code] => adata-durable-series-hd720-external-hdd
                    [quantity] => 5
                    [newproduct] => 0
                    [bestseller] => 0
                    [discounted] => 0
                    [name] => Adata Durable series HD720  External HDD
                    [price] => 9100
                    [discounted_price] => 
                    [original_price] => 9100
                    [brand] => ADATA
                    [promo_line] => Waterproof, Shockproof and Dustproof External HDD.
                    [image] => 1372671924-adata-durable-series-hd720-waterproof-shock-resistant-external-hdd-1tb.jpg
                )

            [11] => stdClass Object
                (
                    [id] => 6472
                    [code] => HD330 4TB
                    [url_code] => adata-shock-resistant-extra-slim-external-hdd-hd330-4tb
                    [quantity] => 0
                    [newproduct] => 0
                    [bestseller] => 0
                    [discounted] => 0
                    [name] => Adata Shock-Resistant Extra Slim External HDD HD330 4TB
                    [price] => 0
                    [discounted_price] => 
                    [original_price] => 0
                    [brand] => ADATA
                    [promo_line] => Slim and Lightweight Stylish High capacity External HDD.
                    [image] => 1055756090-adata-shock-resistant-extra-slim-external-hdd-hd330-4tb.jpg
                )

            [12] => stdClass Object
                (
                    [id] => 6473
                    [code] => HM800
                    [url_code] => adata-hm800-high-capacity-external-hard-disk-drive
                    [quantity] => 0
                    [newproduct] => 0
                    [bestseller] => 0
                    [discounted] => 0
                    [name] => Adata HM800 High capacity External Hard Disk Drive
                    [price] => 23400
                    [discounted_price] => 
                    [original_price] => 23400
                    [brand] => ADATA
                    [promo_line] => High capacity Storage Slim and stylish External HDD.
                    [image] => 127433364-adata-hm800-high-capacity-external-hard-disk-drive.jpg
                )

            [13] => stdClass Object
                (
                    [id] => 2170
                    [code] => ST2000DM006
                    [url_code] => 2000gb-seagate-barracuda-hard-drive-7200rpm-cache
                    [quantity] => 0
                    [newproduct] => 0
                    [bestseller] => 0
                    [discounted] => 0
                    [name] => 2000GB Seagate BarraCuda Hard Drive 7200RPM/CACHE 64MB 3.5 (8.9cm) SATA
                    [price] => 9999
                    [discounted_price] => 
                    [original_price] => 10625
                    [brand] => Seagate
                    [promo_line] => Don&amp;amp;#039;t compromise with your data and Seagate understand that
                    [image] => 12000gb-seagate-barracuda-hard-drive-7200rpm-cache-.jpg
                )

            [14] => stdClass Object
                (
                    [id] => 3292
                    [code] => ADATAhdd1
                    [url_code] => adata-external-hdd-hc660-1-tb
                    [quantity] => 0
                    [newproduct] => 0
                    [bestseller] => 0
                    [discounted] => 0
                    [name] => Adata External HDD HC660 1 TB
                    [price] => 0
                    [discounted_price] => 
                    [original_price] => 0
                    [brand] => ADATA
                    [promo_line] => Ultra-slim through smart engineering
                    [image] => 1adata-external-hdd-hc660-1-tb.jpg
                )

        )

    [product_more] => Array
        (
            [0] => Array
                (
                    [value] => 0.136 KG
                    [field_name] => Weight
                )

            [1] => Array
                (
                    [value] => Transcend
                    [field_name] => manufacturer
                    [manu_code] => transcend-products-in-nepal
                )

        )

    [manufacturer] => 39
    [Promo Line] => Extra Slim Ultra Portable Hard Disk Drive
    [Description] => &lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;PRODUCT INFORMATION&amp;nbsp;&lt;/p&gt;&lt;div&gt;&amp;nbsp;&lt;/div&gt;&lt;div&gt;Brand : Transcend&amp;nbsp;&lt;/div&gt;&lt;div&gt;Item Model No : C3N&lt;/div&gt;&lt;div&gt;Memory : 2 TGB&amp;nbsp;&lt;/div&gt;&lt;div&gt;USB: 3.0&amp;nbsp;&lt;/div&gt;&lt;div&gt;Item Weight : 0.136 kg&amp;nbsp;&lt;/div&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;
    [Weight] => 0.136
    [Original Price] => 12875
    [Name] => TRANSCEND C3N Extra Slim 2.5&amp;amp;quot; 2TB Ultra Portable HDD
    [extra_attributes] => Array
        (
            [checkopts] => 0
            [istheretxtbx] => 0
            [checktxtbx] => 0
            [selectattributes] => 
        )

    [noofprodsinstock] => 0
    [noofpaybycheque] => 0
    [stock] => Out of Stock
)
</pre>